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 question the answer to which is found in the database
Query
SUBTRACT
Relationship
Validation Text
2. 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
Referential Integrity
Primary Key
Subquery
Data File
3. When sorting on two fields this is the more important field
Major Sort Key
Primary Key
Database Design
Delete Query
4. The table obtained by concatenating every row in the first table with every row in the second table
Cartesian Product
PRIMARY KEY
PROJECT
Form
5. The relational algebra command used to select columns from a table
Cartesian Product
Data File
Join
PROJECT
6. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Entity-Relationship (E-R) Diagram
Redundancy
WHERE Clause
7. A database has integrity if the data in it satisfies all established integrity constraints
UPDATE
Integrity
Redundancy
Server
8. A person or place or object or event or idea for which you want to store and process data
Cascade Delete
Query-By-Example (QBE)
Relationship
Entity
9. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
Relational Database
Natural Join
Union Compatible
Trigger
10. A program or a collection of programs through which users interact with a database
PROJECT
Calculated Field
Database Management System (DBMS)
Trigger
11. An index built on more than one field
SELECT
Functions
Security
Multiple-Field Index
12. A characteristic or property of an entity
Criteria
DROP INDEX
Relational Database
Attribute
13. The field or fields on which an index is built
Index Key
Repeating Groups
SQL (Structured Query Language)
Functions
14. The prevention of unauthorized access to a database
Field
Trigger
Security
Database Administration (DBA)
15. 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
Attribute
Database
System Catalog
One-to-Many Relationship
16. The part of an SQL SELECT command that indicates a sort order
Delete Query
ORDER BY Clause
Product
Criteria
17. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Null
Union Compatible
Stored Procedure
Referential Integrity
18. A person or place or object or event or idea for which you want to store and process data
FROM Clause
Qualify
Unnormalized Relation
Entity
19. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Unnormalized Relation
Database
Integrity
Make-Table Query
20. In an Access query the line drawn between tables to indicate how they are related
Reserved Words
FROM Clause
Join Line
Referential Integrity
21. A question the answer to which is found in the database
Column
Join Column
Server
Query
22. The area of memory in MySQL that stores the most recently entered command
Statement History
System Catalog
Stored Procedure
Database Administrator (DBA)
23. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Calculated Field
Relational Algebra
Attribute
SUBTRACT
24. A Characteristic or property of an entity
Primary Key
Column
Join Line
Entity-Relationship (E-R) Diagram
25. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Primary Key
One-to-Many Relationship
Entity-Relationship (E-R) Diagram
Qualify
26. A combination of criteria in which at least on the criteria must be true
OR Criterion
GRANT
PROJECT
Concatenation
27. The SQL command that is used to change the structure of a table
Query
Redundancy
Database Administration (DBA)
ALTER TABLE
28. A field whose value is computed from other fields in the database
Computed Field
Relational Database
Functions
Sort Key
29. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
Relationship
Database Administrator (DBA)
GRANT
30. The property that no record can exist in the database with a value in a field other than a legal value
Legal-Values Integrity
SELECT
Unnormalized Relation
Calculated Field
31. A combination of criteria in which at least on the criteria must be true
Database Design
Database
Unnormalized Relation
OR Criterion
32. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Database Administrator (DBA)
Data Independence
Sort Key
Join Line
33. More than one entry at a single location in a table
Major Sort Key
Legal-Values Integrity
Database Administrator (DBA)
Repeating Groups
34. The plural of Criterion
Security
Criteria
SELECT
Redundancy
35. Combination of criteria in which both criteria must be true
Database Design
Relational Database
AND Criterion
SUBTRACT
36. Combination of criteria in which both criteria must be true
Outer Join
AND Criterion
Unnormalized Relation
Compound Criteria
37. The SQL command used to describe the layout of a table. The word table is followed by the name of the table to be created and then by the names and data types of the column (fields) that comprise the table
Cascade Update
Cartesian Product
Entity-Relationship (E-R) Diagram
CREATE TABLE
38. Duplication of data or the storing of the same data in more than one place.
Calculated Field
Redundancy
Repeating Groups
Compound Criteria
39. The SQL command that drops (deletes) and index from a table
Database
Update Query
DROP INDEX
Minor Sort Key
40. A screen object you use to maintain or view and print data from a database
SELECT
Form
Sort Key
Integrity
41. In relational algebra the operation in which two tables are connected on the basis of common data.
Cascade Delete
Documenter
Join
AND Criterion
42. A statement the can be either true or false. Also called a condition
Criterion
Minor Sort Key
Integrity
Database Administration (DBA)
43. In Access the query that updates the contents of a table
Update Query
Query
Functions
Data Independence
44. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Criterion
Legal-Values Integrity
Server
45. An association between entities
Command
Minor Sort Key
Relationship
Qualify
46. The process of creating collections of records that share some common characteristics
Grouping
DROP INDEX
Computed Field
Join
47. When sorting on two fields - the less important field
Calculated Field
Database Administrator (DBA)
Relation
Minor Sort Key
48. When sorting on two fields this is the more important field
Criterion
Primary Sort Key
DROP INDEX
Database
49. A characteristic or property of an entity
Systables
Field
Integrity Constraint
AND Criterion
50. 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
Query
Database Design
Data File