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 screen object you use to maintain or view and print data from a database
Union Compatible
Secondary Sort Key
Form
Database
2. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database
Validation Text
System Catalog
Cascade Delete
One-to-Many Relationship
3. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate
ALTER TABLE
Update Query
Entity-Relationship (E-R) Diagram
Form
4. In relational algebra the operation in which two tables are connected on the basis of common data.
Relational Database
Functions
Join
Form
5. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate
View
Single-Field Index
Entity-Relationship (E-R) Diagram
Delete Query
6. The SQL command used to make changes to existing table data
UPDATE
Make-Table Query
Primary Sort Key
Form
7. A combination of two tables consisting of all records that are in either table
Update Query
Union
SUBTRACT
Form
8. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Union
Data Independence
Difference
Intersection
9. A question the answer to which is found in the database
Integrity Constraint
Query
Minor Sort Key
Update Query
10. A database has integrity if the data in it satisfies all established integrity constraints
Relationship
Query
Integrity
Repeating Groups
11. The field on which data are sorted
Database
Sort Key
SELECT
Qualify
12. The individual or group that is responsible for a database
Delete Query
Delete Query
ORDER BY Clause
Database Administration (DBA)
13. An index built on a single field
Relationship
Single-Column Index
Data File
OR Criterion
14. When comparing tables the set of all rows that are in the first table but that are not in the second table
Legal-Values Integrity
Design Grid
Difference
Form
15. 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
Validation Text
Aggregate Functions
Entity
Make-Table Query
16. A message in Access that is displayed when a validation rule is violated
Compound Criteria
Statement History
Validation Text
Union
17. A collection of relations
Relational Database
Index
Relationship
Compound Conditions
18. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Major Sort Key
Relational Algebra
Database Administration (DBA)
Referential Integrity
19. The prevention of unauthorized access to a database
Sort
Security
Database Design
Union
20. When sorting on two fields - the less important field
Secondary Sort Key
Database Administrator (DBA)
Data Macro
Data File
21. 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
Repeating Groups
Referential Integrity
Sort
Make-Table Query
22. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Form
FROM Clause
Cartesian Product
23. The portion of the system catalog the contains column information
Syscolumns
Database Administration (DBA)
Qualify
Integrity
24. More than one entry at a single location in a table
Repeating Groups
Relational Database
Data Independence
Relational Database
25. The relational algebra command for performing the intersection of two tables
Form
Statement History
SELECT
INTERSECT
26. A screen object you use to maintain or view and print data from a database
Form
Security
Make-Table Query
GRANT
27. The part of an SQL SELECT command that indicates the tables in the query
Comparison Operator
Integrity Constraint
Sort Key
FROM Clause
28. The relational algebra command for performing the difference of two tables
FROM Clause
SUBTRACT
Unnormalized Relation
Security
29. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.
SELECT Clause
Integrity
Primary Key
Validation Text
30. An index built on more than one field
Multiple Column Index
Data Independence
Simple Condition
Column
31. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
REVOKE
Data File
Primary Key
32. A data value meaning "unknown" or "not applicable"
Relation
Single-Column Index
Referential Integrity
Null
33. Combination of criteria in which both criteria must be true
AND Criterion
Documenter
Product
Criteria
34. An access query that creates a table using the results of a query
Query-By-Example (QBE)
Make-Table Query
Compound Conditions
Statement History
35. A file that relates key values to records that contain those key values
Index
Redundancy
Query-By-Example (QBE)
Computed Field
36. The relational algebra command to select rows from a table
Arguments
GROUP BY Clause
SELECT
Concatenation
37. The field or fields on which an index is built
View
Calculated Field
Integrity
Index Key
38. A statement the can be either true or false. Also called a condition
Field
SELECT
Criterion
Repeating Groups
39. A collection of relations
Relational Database
Join Column
Subquery
Primary Key
40. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
Division
Join Line
Major Sort Key
Simple Condition
41. The table obtained by concatenating every row in the first table with every row in the second table
Join Column
Cartesian Product
Column
Relationship
42. An association between entities
INSERT
Relationship
Division
Primary Key
43. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
Difference
WHERE Clause
REVOKE
Relationship
44. In Access the query that updates the contents of a table
Update Query
Relational Algebra
Secondary Sort Key
DELETE
45. The rule that no column (attribute) that is part of the primary key may accept null values
Relational Database
ORDER BY Clause
Entity Integrity
Query-By-Example (QBE)
46. A combination of two tables consisting of all records that are in either table
INTERSECT
Simple Condition
Unnormalized Relation
Union
47. The part of an SQL SELECT command that restricts the groups to be displayed
FOREIGN KEY
Comparison Operator
Major Sort Key
HAVING Clause
48. A characteristic or property of an entity
OR Criterion
PROJECT
Concatenation
Attribute
49. In an Access query the line drawn between tables to indicate how they are related
Compound Criteria
Join Line
Union
Make-Table Query
50. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Functions
Relation
Database Management System (DBMS)