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 - the less important field
Minor Sort Key
Aggregate Functions
Sort Key
Relationship
2. 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.
Primary Key
Integrity Constraint
UPDATE
Data File
3. The individual or group that is responsible for a database
Database Administration (DBA)
Multiple Column Index
Documenter
Database Management System (DBMS)
4. A characteristic or property of an entity
CREATE INDEX
Delete Query
Trigger
Attribute
5. The process of arranging rows in a table or results of a query in a particular order
Join Line
Sort
Relationship
ALTER TABLE
6. A delete option in which related records are automatically deleted
Cascade Delete
Data File
Single-Field Index
Arguments
7. A query that deletes all records that satisfy some criterion
Primary Key
Form
SUBTRACT
Delete Query
8. When sorting on two fields - the less important field
OR Criterion
Query
Secondary Sort Key
Entity
9. 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
Join
SELECT
Entity-Relationship (E-R) Diagram
Update Query
10. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Union Compatible
SELECT Clause
Foreign Key
Column
11. A field whose value is computed from other fields in the database
Sort
DELETE
Calculated Field
Join Line
12. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Union
Unnormalized Relation
PROJECT
13. The relational algebra command for performing the intersection of two tables
Make-Table Query
Integrity
INTERSECT
Primary Sort Key
14. A person or place or object or event or idea for which you want to store and process data
Entity
Database
Aggregate Functions
Repeating Groups
15. What type of an operator is >= ?
Intersection
Database Design
Functions
Comparison Operator
16. In relational algebra the operation in which two tables are connected on the basis of common data.
Join Line
Data Macro
Join
Comparison Operator
17. When sorting on two fields - the less important field
Secondary Sort Key
CHECK
Database
Natural Join
18. A database has integrity if the data in it satisfies all established integrity constraints
Product
Qualify
Sort
Integrity
19. The SQL command that drops (deletes) a table from a database
Validation Rule
Documenter
PROJECT
DROP TABLE
20. A word that is part of the SQL language
Computed Field
WHERE Clause
Reserved Words
Query-By-Example (QBE)
21. A query in SQL that appears within another
AND Criterion
Subquery
Comparison Operator
Database Management System (DBMS)
22. A message in Access that is displayed when a validation rule is violated
Database Management System (DBMS)
Compound Criteria
Simple Condition
Validation Text
23. Two simple criteria in a query the are combined with the AND or OR operators
Natural Join
Qualify
Compound Conditions
Comparison Operator
24. The relational algebra command for performing the difference of two tables
OR Criterion
Grouping
SUBTRACT
Attribute
25. 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
Systables
Database Design
Database
Qualify
26. A screen object you use to maintain or view and print data from a database
Concatenation
Form
Database Management System (DBMS)
HAVING Clause
27. A question the answer to which is found in the database
Attribute
Reserved Words
Query
Outer Join
28. In an Access query the line drawn between tables to indicate how they are related
Update Query
Join Line
Security
Cartesian Product
29. A program or a collection of programs through which users interact with a database
Integrity
Database Management System (DBMS)
Design Grid
Index
30. A field whose value is computed from other fields in the database
Concatenation
Join
Referential Integrity
Computed Field
31. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Criterion
Index
Qualify
Design Grid
32. The property that no record can exist in the database with a value in a field other than a legal value
Legal-Values Integrity
REVOKE
Integrity Constraint
DELETE
33. The field or fields on which an index is built
Index Key
Make-Table Query
Qualify
Database Design
34. Combination of criteria in which both criteria must be true
Primary Key
AND Criterion
Data Macro
Database Administration (DBA)
35. In Access the query that updates the contents of a table
Integrity
Sort Key
Relationship
Update Query
36. The rule that no column (attribute) that is part of the primary key may accept null values
Repeating Groups
Entity Integrity
Database Design
Integrity
37. The process of creating collections of records that share some common characteristics
Database Administration (DBA)
Grouping
Entity-Relationship (E-R) Diagram
Delete Query
38. When sorting on two fields this is the more important field
Field
Arguments
Major Sort Key
Relational Database
39. A Characteristic or property of an entity
Column
Query
SELECT Clause
Security
40. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Entity-Relationship (E-R) Diagram
PROJECT
Unnormalized Relation
Compound Criteria
41. 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
Compound Conditions
Integrity
Database Administrator (DBA)
Entity-Relationship (E-R) Diagram
42. An application program's or an individual user's picture of a database
Subquery
Legal-Values Integrity
View
Grouping
43. The SQL clause that is used to enforce legal-values integrity
Design Grid
Update Query
Catalog
CHECK
44. The SQL command that creates an index in a table
Relational Algebra
Database Design
Data Independence
CREATE INDEX
45. The relational algebra command to select rows from a table
SELECT
Computed Field
Cartesian Product
Design Grid
46. An index built on a single field
Index Key
Single-Field Index
Sysviews
Natural Join
47. In relational algebra the operation in which two tables are connected on the basis of common data.
Data Independence
Join
Simple Condition
Intersection
48. 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
Criterion
Secondary Sort Key
One-to-Many Relationship
Database
49. Additional information required by an action in a data macro to complete the action
Sysviews
Difference
Arguments
Primary Key
50. A database has integrity if the data in it satisfies all established integrity constraints
Sort Key
Integrity
Update Query
Relational Algebra