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 comparing tables the set of all rows that are in the first table but that are not in the second table
Data Independence
Union
Difference
Calculated Field
2. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Qualify
Join Line
Delete Query
3. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Single-Column Index
Data Independence
One-to-Many Relationship
Division
4. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table
Compound Criteria
Aggregate Functions
Database Administration (DBA)
Concatenation
5. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Difference
Update Query
Data Independence
Attribute
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
Major Sort Key
One-to-Many Relationship
Integrity Constraint
Database Management System (DBMS)
7. A query that deletes all records that satisfy some criterion
Delete Query
Redundancy
Field
Qualify
8. The SQL clause that is used to enforce legal-values integrity
Cascade Update
Major Sort Key
CHECK
Index
9. An association between entities
Entity
UPDATE
Relationship
ALTER TABLE
10. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Concatenation
PROJECT
Minor Sort Key
11. Two simple criteria in a query the are combined with the AND or OR operators
Field
Compound Criteria
Simple Condition
One-to-Many Relationship
12. An index built on more than one field
Multiple-Field Index
Database Management System (DBMS)
Database
Entity
13. A data value meaning "unknown" or "not applicable"
Entity-Relationship (E-R) Diagram
Null
Subquery
Form
14. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
Relational Algebra
Major Sort Key
Integrity
15. The part of an SQL SELECT command that indicates grouping
Join Line
GROUP BY Clause
Union Compatible
Relational Database
16. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Form
Integrity Constraint
Data Independence
Row-and Column Subset View
17. A rule that must be followed by data in a database
SELECT Clause
Unnormalized Relation
PROJECT
Integrity Constraint
18. The process of arranging rows in a table or results of a query in a particular order
Qualify
Sort
Form
Relational Database
19. A rule in Access that data entered in a field must satisfy
Data File
Join
Validation Rule
Outer Join
20. The process of arranging rows in a table or results of a query in a particular order
Relationship
CREATE INDEX
Single-Column Index
Sort
21. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Catalog
Primary Key
Single-Column Index
SQL (Structured Query Language)
22. An instruction by a user that directs a database to perform a certain way
Command
Database Management System (DBMS)
Arguments
Query-By-Example (QBE)
23. A collection of relations
Validation Rule
DROP TABLE
Database
Relational Database
24. A collection of relations
Relational Database
Sysindexes
Validation Text
Form
25. The SQL command used to delete a table
DELETE
AND Criterion
UPDATE
Database
26. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table
UPDATE
Form
Systables
Concatenation
27. An index built on more than one field
Update Query
Database Administrator (DBA)
Single-Field Index
Multiple Column Index
28. A screen object you use to maintain or view and print data from a database
Query-By-Example (QBE)
One-to-Many Relationship
Qualify
Form
29. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Entity-Relationship (E-R) Diagram
Documenter
Compound Criteria
30. The relational algebra command used to select columns from a table
Column
Integrity
PROJECT
Join
31. The individual or group that is responsible for a database
Database Administration (DBA)
Product
Entity
Make-Table Query
32. The SQL statement that is used to grant different types of privileges to users of a dataabase
GRANT
Single-Field Index
Relationship
CREATE TABLE
33. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Foreign Key
Attribute
Query
34. A program or a collection of programs through which users interact with a database
Aggregate Functions
Qualify
Database Management System (DBMS)
Multiple-Field Index
35. A statement the can be either true or false. Also called a condition
ALTER TABLE
INSERT
Make-Table Query
Criterion
36. A characteristic or property of an entity
Relational Algebra
Relation
SELECT Clause
Attribute
37. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Union Compatible
Relational Database
Unnormalized Relation
Union
38. An access query that creates a table using the results of a query
Database Management System (DBMS)
Integrity
Make-Table Query
Delete Query
39. The column on which two tables are joined
Join Column
UPDATE
Integrity Constraint
Single-Column Index
40. A file that relates key values to records that contain those key values
Aggregate Functions
Secondary Sort Key
Delimiter
Index
41. Combination of criteria in which both criteria must be true
AND Criterion
Documenter
Make-Table Query
Primary Sort Key
42. 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
Database
Unnormalized Relation
Difference
43. A combination of two tables consisting of all records that are in either table
Union
Sort
Data File
Redundancy
44. 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
View
Null
Database Administrator (DBA)
45. In an Access query the line drawn between tables to indicate how they are related
Redundancy
OR Criterion
Join
Join Line
46. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Compound Conditions
Join Column
INSERT
47. 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
Aggregate Functions
CREATE INDEX
FROM Clause
Database Management System (DBMS)
48. A field whose value is computed from other fields in the database
Make-Table Query
DELETE
Computed Field
Server
49. The SQL command used to make changes to existing table data
UPDATE
Column
Repeating Groups
Database Administrator (DBA)
50. The part of an SQL SELECT command that indicates a sort order
Redundancy
Design Grid
One-to-Many Relationship
ORDER BY Clause