SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Database Management Fundamentals
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Columns containing numbers only
Data Dictionary
Central Control of data
Foreign Keys
SUM
2. Limits the output of the established groups into the derived result table
Integrated
Indexes
HAVING
MAX
3. Uses two values as limits - selecting any values between the two of them
BETWEEN
Service Broker
GROUP BY
Word
4. Data that has been processed into a format that is understandable by its audience
hidden fields
Information
Object-Oriented Relational (OOR)
BETWEEN
5. Attribute in quotes
Property
End Users
Data
Dynamic
6. Closed in the start tag by adding a slash to the start tag
Empty Elements
ORDER BY
single value
Aggregate Functions
7. Ongoing record of data reflecting the info defining the database
Closing tag
Data Dictionary
Functions
Web Service
8. Uses relationships between independent entities
Relational
Aliases
INSERT INTO
Information
9. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
ESC
single value
Application Programmers
ALL
10. Compares value of the column in the specified condition with the value specified
ASC
Equals Operator
Service Requestor
Database Administrator (DBA)
11. Everything between the start and end tag
Indexes
MIN
Element Content
Subqueries
12. Table displayed in descending order
WHERE
Empty Elements
ESC
Word
13. Interact and manipulates the data in the database
Performance
Hierarchial
Web Service
Data Manipulation
14. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Inner SELECT query
Primary Keys
Service-Oriented Architecture (SOA)
15. Defines a new column
Word
Foreign Keys
Self Join
Calculated Column
16. Used to close a tag properly
Service Provider
Query
Forward Slash
Service Broker
17. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Web Applications
Candidate Keys
HAVING
18. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Equals Operator
Cookie
Calculated Column
19. All Columns indicated and selected
Data Elements
SUM
*
Application Programers
20. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Data Recovery & Concurrance
Embedded SQL
Hardware
Public Key Infrastructure (PKI)
21. Concatenated in SQL Server Database software using the addition symbol
accident
Fields
HAVING
single value
22. Selects from specific values in list
Primary Keys
IN
COUNT
Attributes
23. Uses two values as limits - selecting any values between the two of them
INSERT INTO
Data Manipulation
Aggregate Functions
BETWEEN
24. Limits the rows that appear in the result mathcing a specified condition
Negation Operator
Query
IN
WHERE
25. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
LIKE
Aliases
Database
LIKE
26. Data that has been processed into a format that is understandable by its audience
Comparison Operators
Information
Structured Query Language (SQL)
NOT
27. Used to combine one query to another
Subqueries
Foreign Keys
Structured Query Language (SQL)
HAVING
28. Data remains unchanged in database
MIN
Persistent
Performance
Hypertext Markup Language (HTML)
29. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Comparison Operators
Application Programmers
Views
Data Recovery & Concurrance
30. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Forward Slash
Stateless
Embedded SQL
31. SQL Commands: Define tables - views - _____ - delete or insert info
Foreign Keys
Flat File
BETWEEN
to update
32. Most valuable asset of a database system.
accident
Central control of data
Comparison Operators
Data Recovery & Concurrance
33. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Hypertext Markup Language (HTML)
SELECT
DELETE
Structured Query Language (SQL)
34. Describe information in a tree styled format
Fields
Hierarchial
Application Programmers
Web server
35. Supplies value for the search condition of the SELECT statement containing it
WHERE
Cookie
ALL
Inner SELECT query
36. Network node that discovers and invokes other software services to provide a buisness solution
Word
Application Programers
Service Requestor
Joins
37. Join a table to a copy of itself
Self Join
Service Broker
IN
Relational
38. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Comparison Operators
Bind
Closing tag
39. Compares value of the column in the specified condition with the value specified
Equals Operator
Aliases
GROUP BY
Interactive SQL
40. Command used to show the attributes that define a table.
Public Key Infrastructure (PKI)
sp_help
BETWEEN
Data Recovery & Concurrance
41. Combines rows from a SELECT statements result table into a group
Attributes
Comparison Operators
GROUP BY
Data Dictionary
42. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
AVG
SUM
Opening tag
COUNT
43. Data in database interacts & corresponds with other data
Joins
Integrated
Database Management Systems (DBMS)
Subqueries
44. Specifies the tables or views from which rows and columns are retrieved
Query
Service Provider
FROM
Data Recovery & Concurrance
45. Looks like opening tag - but with a forward slash
Indexes
Closing tag
Inner SELECT query
Session
46. Give the browser more specific information about that tag
Negation Operator
American Standard Code for Information Interchange (ASCII)
Service Requestor
Attributes
47. Table displayed in descending order
MAX
Data Administrator (DAd)
INSERT INTO
ESC
48. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
COUNT
Fields
Primary Keys
49. Limits the output of the established groups into the derived result table
LIKE
Data Recovery & Concurrance
Web Browser
HAVING
50. Uses relationships between independent entities
Service Broker
Joins
hidden fields
Relational