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. When sorting on two fields this is the more important field
View
Primary Sort Key
SELECT
Design Grid
2. An index built on more than one field
Query-By-Example (QBE)
Difference
Integrity Constraint
Multiple Column Index
3. 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
Entity Integrity
DELETE
Database Design
Concatenation
4. The relational algebra command for performing the difference of two tables
Query
SUBTRACT
Integrity Constraint
Grouping
5. In relational algebra the operation in which two tables are connected on the basis of common data.
Join Column
Database Design
Join
Repeating Groups
6. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity
Data Macro
Join
One-to-Many Relationship
OR Criterion
7. The process of creating collections of records that share some common characteristics
Make-Table Query
Null
Grouping
Validation Rule
8. When sorting on two fields - the less important field
Minor Sort Key
Primary Key
GROUP BY Clause
DROP INDEX
9. A combination of criteria in which at least on the criteria must be true
OR Criterion
Primary Key
Row-and Column Subset View
DROP INDEX
10. A rule that must be followed by data in a database
Null
Integrity Constraint
Integrity
Data Independence
11. The plural of Criterion
Relational Database
Delimiter
Field
Criteria
12. When comparing tables the set of all rows that are in the first table but that are not in the second table
Intersection
Repeating Groups
Database
Difference
13. An index built on a single field
Single-Field Index
Relation
Union Compatible
Criteria
14. The rule that no column (attribute) that is part of the primary key may accept null values
Union Compatible
Division
Entity Integrity
Compound Conditions
15. The SQL command that drops (deletes) and index from a table
Primary Key
Join
DROP INDEX
Delimiter
16. The SQL statement that is used to revoke privileges from users of a database
Join Line
Database Administration (DBA)
Multiple-Field Index
REVOKE
17. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
Natural Join
Computed Field
Database Design
18. When sorting on two fields this is the more important field
Legal-Values Integrity
Null
Integrity
Major Sort Key
19. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity
Secondary Sort Key
SELECT
One-to-Many Relationship
Natural Join
20. A message in Access that is displayed when a validation rule is violated
REVOKE
Syscolumns
Criteria
Validation Text
21. The portion of the system catalog that contains index information
Sysindexes
Database Administrator (DBA)
Query
Major Sort Key
22. An association between entities
Relationship
Primary Sort Key
Sysindexes
Repeating Groups
23. The form of a join in which all records appear - even if they don't match
Outer Join
Natural Join
Primary Sort Key
View
24. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
OR Criterion
ORDER BY Clause
PRIMARY KEY
One-to-Many Relationship
25. The part of an SQL SELECT command that indicates grouping
Foreign Key
GROUP BY Clause
Repeating Groups
Concatenation
26. 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
Integrity
Systables
Relationship
Referential Integrity
27. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Database
Catalog
Computed Field
Index
28. A screen object you use to maintain or view and print data from a database
Trigger
Primary Key
CHECK
Form
29. When sorting on two fields - the less important field
Trigger
Secondary Sort Key
Compound Criteria
Computed Field
30. 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
Functions
PROJECT
Major Sort Key
Database Design
31. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
DROP INDEX
Intersection
Functions
32. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
One-to-Many Relationship
Security
Referential Integrity
33. The process of creating collections of records that share some common characteristics
Defining Query
DROP INDEX
Grouping
Relationship
34. The part of an SQL SELECT command that restricts the groups to be displayed
Integrity Constraint
Field
Unnormalized Relation
HAVING Clause
35. A characteristic or property of an entity
Qualify
AND Criterion
Data Independence
Attribute
36. More than one entry at a single location in a table
Criterion
Repeating Groups
Sysindexes
Form
37. A characteristic or property of an entity
Relationship
Command
Field
Attribute
38. The individual or group that is responsible for a database
Qualify
Database Administration (DBA)
Sort
Comparison Operator
39. An application program's or an individual user's picture of a database
Database Administration (DBA)
Single-Column Index
View
Calculated Field
40. When sorting on two fields this is the more important field
AND Criterion
Redundancy
Data Macro
Primary Sort Key
41. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Data Independence
Division
Security
Entity-Relationship (E-R) Diagram
42. The column on which two tables are joined
Command
GROUP BY Clause
CREATE INDEX
Join Column
43. A characteristic or property of an entity
UPDATE
Redundancy
Field
Command
44. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Data Macro
Attribute
Redundancy
Database
45. A characteristic or property of an entity
Field
Product
Delete Query
One-to-Many Relationship
46. The plural of Criterion
Intersection
Criteria
Subquery
CHECK
47. A query that deletes all records that satisfy some criterion
Integrity Constraint
Primary Sort Key
Delete Query
Relational Database
48. 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
Functions
Relational Database
Field
Null
49. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Intersection
Database
Query
Qualify
50. A combination of two tables consisting of all records that are in either table
Database Management System (DBMS)
Minor Sort Key
Multiple Column Index
Union