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. In an Access query the line drawn between tables to indicate how they are related
CREATE TABLE
Sort Key
Cascade Delete
Join Line
2. A file that relates key values to records that contain those key values
Database Administration (DBA)
Index
Database Management System (DBMS)
Join Column
3. A characteristic or property of an entity
Field
Redundancy
Attribute
SELECT
4. An instruction by a user that directs a database to perform a certain way
Criteria
Command
Form
Simple Condition
5. The relational algebra command to select rows from a table
Unnormalized Relation
Join Line
Database Management System (DBMS)
SELECT
6. A Characteristic or property of an entity
Reserved Words
Column
System Catalog
Data Independence
7. The query that is used to define the structure of a viewk
Validation Text
OR Criterion
Defining Query
Sort Key
8. 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
Compound Criteria
One-to-Many Relationship
Primary Sort Key
Database Management System (DBMS)
9. When sorting on two fields - the less important field
FROM Clause
Minor Sort Key
Redundancy
Query-By-Example (QBE)
10. A screen object you use to maintain or view and print data from a database
Repeating Groups
Comparison Operator
Data Independence
Form
11. The portion of the system catalog the contains column information
Aggregate Functions
Arguments
Syscolumns
Minor Sort Key
12. The SQL command that creates an index in a table
Database Administration (DBA)
Attribute
Functions
CREATE INDEX
13. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Aggregate Functions
Unnormalized Relation
Data Independence
One-to-Many Relationship
14. The SQL statement that is used to revoke privileges from users of a database
Query
Database Administration (DBA)
Unnormalized Relation
REVOKE
15. A very popular relational data definition and manipulation language that is used in many relational DBMS's
SQL (Structured Query Language)
ORDER BY Clause
Query
Secondary Sort Key
16. A characteristic or property of an entity
Attribute
Concatenation
Primary Sort Key
Field
17. The field on which data are sorted
Sort Key
Relationship
Server
Outer Join
18. A field whose value is computed from other fields in the database
Database
Calculated Field
DELETE
ORDER BY Clause
19. Two simple criteria in a query the are combined with the AND or OR operators
SELECT
FOREIGN KEY
Redundancy
Compound Conditions
20. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Redundancy
Attribute
Integrity Constraint
Database
21. When comparing tables the set of all rows that are in the first table but that are not in the second table
Syscolumns
AND Criterion
PROJECT
Difference
22. A database has integrity if the data in it satisfies all established integrity constraints
Data File
Integrity
Delimiter
Primary Key
23. The portion of the system catalog that contains table information
Systables
Relational Algebra
Update Query
Catalog
24. When sorting on two fields this is the more important field
Union
Major Sort Key
Primary Sort Key
Design Grid
25. A characteristic or property of an entity
OR Criterion
Field
FOREIGN KEY
Integrity
26. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Database
Database Design
Criterion
Entity
27. A rule that must be followed by data in a database
Integrity Constraint
Command
Aggregate Functions
Integrity
28. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Database Administration (DBA)
Database Management System (DBMS)
Field
29. The individual who is responsible for a database or the head of database administration
Sort
Column
Database Administrator (DBA)
FOREIGN KEY
30. A word that is part of the SQL language
Reserved Words
Server
Database Administration (DBA)
SUBTRACT
31. An access query that creates a table using the results of a query
Database Administrator (DBA)
Make-Table Query
Validation Rule
Integrity
32. The prevention of unauthorized access to a database
Division
Security
Command
One-to-Many Relationship
33. A condition that involves only a single field and a single value
Qualify
Database Administrator (DBA)
Simple Condition
Database Administration (DBA)
34. In relational algebra the operation in which two tables are connected on the basis of common data.
Union
INSERT
Join
Entity-Relationship (E-R) Diagram
35. A collection of relations
Database Management System (DBMS)
Database Administrator (DBA)
Update Query
Relational Database
36. Combination of criteria in which both criteria must be true
AND Criterion
Database
Design Grid
Data File
37. A Characteristic or property of an entity
Data File
Minor Sort Key
Column
Concatenation
38. A query that deletes all records that satisfy some criterion
Entity-Relationship (E-R) Diagram
Entity
Calculated Field
Delete Query
39. The part of an SQL SELECT command that restricts the groups to be displayed
HAVING Clause
Minor Sort Key
Grouping
Relationship
40. The individual or group that is responsible for a database
Secondary Sort Key
Relational Algebra
ALTER TABLE
Database Administration (DBA)
41. A screen object you use to maintain or view and print data from a database
SELECT
Unnormalized Relation
Criterion
Form
42. In an Access query the line drawn between tables to indicate how they are related
Command
REVOKE
INTERSECT
Join Line
43. An index built on more than one field
Multiple-Field Index
Database Design
Comparison Operator
Outer Join
44. A screen object you use to maintain or view and print data from a database
Form
One-to-Many Relationship
Sort Key
INSERT
45. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Query-By-Example (QBE)
Join Line
Criteria
Unnormalized Relation
46. The property that lets you change the structure of a database without requiring you to change the programs that access the database
SELECT
Data Independence
Database Design
Referential Integrity
47. The individual or group that is responsible for a database
Relation
Database Design
Design Grid
Database Administration (DBA)
48. The relational algebra command used to select columns from a table
Join Line
PROJECT
Delete Query
Form
49. The prevention of unauthorized access to a database
Security
Sort
Union
UPDATE
50. The table obtained by concatenating every row in the first table with every row in the second table
Data Independence
Field
Cartesian Product
DROP INDEX