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 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. A collection of relations
Compound Criteria
SELECT Clause
Relational Database
Database Design
2. A rule that must be followed by data in a database
Integrity Constraint
Null
OR Criterion
Data Independence
3. The SQL command that drops (deletes) a table from a database
SQL (Structured Query Language)
Repeating Groups
DROP TABLE
Database Administrator (DBA)
4. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Relation
Unnormalized Relation
Relation
Data Macro
5. The field or fields on which an index is built
Repeating Groups
Make-Table Query
ORDER BY Clause
Index Key
6. The SQL command used to make changes to existing table data
Compound Criteria
Join Column
Database Administration (DBA)
UPDATE
7. The SQL clause that is used to enforce legal-values integrity
Stored Procedure
Repeating Groups
CHECK
Relation
8. When sorting on two fields - the less important field
Index
ORDER BY Clause
Secondary Sort Key
Foreign Key
9. An association between entities
Update Query
Relationship
Cascade Delete
AND Criterion
10. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Criterion
Update Query
Query-By-Example (QBE)
11. The field on which data are sorted
HAVING Clause
Sort Key
Criteria
Integrity
12. A characteristic or property of an entity
Database
Field
Integrity Constraint
Database Management System (DBMS)
13. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
ALTER TABLE
CREATE INDEX
AND Criterion
Qualify
14. The rule that if table A contains a foreign key that matches the primary key of table B then the value of this foreign key must either match the value of the primary key for some row in table B or be null
Grouping
Design Grid
OR Criterion
Referential Integrity
15. A Characteristic or property of an entity
Security
Delete Query
Column
Secondary Sort Key
16. The property that no record can exist in the database with a value in a field other than a legal value
Legal-Values Integrity
CHECK
Syscolumns
Server
17. The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users
Join Column
Delete Query
View
Database Design
18. The part of an SQL SELECT command that indicates a sort order
Criterion
Index
View
ORDER BY Clause
19. The rule that no column (attribute) that is part of the primary key may accept null values
DROP INDEX
Entity Integrity
Sysindexes
Defining Query
20. The individual who is responsible for a database or the head of database administration
Criteria
Computed Field
Database Administrator (DBA)
Relation
21. A characteristic or property of an entity
Field
Relational Database
Database Administration (DBA)
Make-Table Query
22. When comparing tables the set of all rows that are in the first table but that are not in the second table
Secondary Sort Key
Difference
Database Administration (DBA)
Validation Rule
23. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Data Independence
Natural Join
Database Management System (DBMS)
24. A question the answer to which is found in the database
Data File
Sysviews
Query
Natural Join
25. An index built on more than one field
GRANT
Single-Field Index
Data File
Multiple Column Index
26. An update option in which related records are automatically updated
Entity-Relationship (E-R) Diagram
Redundancy
Cascade Update
Delete Query
27. When comparing tables an intersection is a new table containing all rows that are in both original tables
Catalog
Relational Algebra
GROUP BY Clause
Intersection
28. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Arguments
SUBTRACT
Unnormalized Relation
Join Column
29. A combination of criteria in which at least on the criteria must be true
OR Criterion
Union Compatible
Major Sort Key
Compound Conditions
30. When sorting on two fields - the less important field
Union
Minor Sort Key
Database
Index Key
31. When sorting on two fields - the less important field
INSERT
Database Design
Minor Sort Key
Security
32. The process of creating collections of records that share some common characteristics
Update Query
Field
Grouping
Make-Table Query
33. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
Grouping
Calculated Field
CREATE INDEX
34. The area of memory in MySQL that stores the most recently entered command
Query
Statement History
Integrity Constraint
Database Administrator (DBA)
35. A Characteristic or property of an entity
Column
Delete Query
Database Design
Natural Join
36. A Characteristic or property of an entity
Update Query
Entity Integrity
Column
One-to-Many Relationship
37. The prevention of unauthorized access to a database
CREATE INDEX
Qualify
Primary Key
Security
38. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns
Relation
Relational Database
Command
Systables
39. The individual who is responsible for a database or the head of database administration
Field
Database Administrator (DBA)
Major Sort Key
Qualify
40. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Database
Major Sort Key
SUBTRACT
Criteria
41. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
Query
Data Independence
Integrity Constraint
42. The portion of the system catalog that contains index information
WHERE Clause
Design Grid
Sysindexes
Integrity
43. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column
Sort
Functions
Join Column
DELETE
44. The plural of Criterion
Unnormalized Relation
Division
Criteria
One-to-Many Relationship
45. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Qualify
Relational Database
One-to-Many Relationship
46. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Index Key
Design Grid
Union Compatible
Subquery
47. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Criterion
Relational Algebra
Unnormalized Relation
Integrity Constraint
48. A word that is part of the SQL language
Query
Reserved Words
Secondary Sort Key
Relation
49. When sorting on two fields this is the more important field
Data Independence
Design Grid
SELECT
Primary Sort Key
50. A field whose value is computed from other fields in the database
Row-and Column Subset View
INTERSECT
Column
Calculated Field