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. The SQL clause that is used to enforce legal-values integrity
Outer Join
CHECK
Subquery
Database Administration (DBA)
2. When sorting on two fields this is the more important field
Sysviews
Functions
Major Sort Key
Attribute
3. The form of a join in which all records appear - even if they don't match
Secondary Sort Key
Outer Join
Integrity Constraint
Join Line
4. Two simple criteria in a query the are combined with the AND or OR operators
Join Column
Major Sort Key
Minor Sort Key
Compound Criteria
5. An update option in which related records are automatically updated
Union
Integrity Constraint
Cascade Update
SELECT Clause
6. A message in Access that is displayed when a validation rule is violated
Validation Text
Query-By-Example (QBE)
View
Sort Key
7. The SQL command used to make changes to existing table data
UPDATE
Data Independence
Query
Outer Join
8. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
Relational Database
Criterion
Join Line
9. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Grouping
Database Design
Intersection
Design Grid
10. 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
Update Query
One-to-Many Relationship
Field
Data File
11. The individual or group that is responsible for a database
Primary Key
Database Administration (DBA)
Attribute
Integrity
12. More than one entry at a single location in a table
Data File
Cascade Delete
Calculated Field
Repeating Groups
13. Two simple criteria in a query the are combined with the AND or OR operators
Relational Algebra
Database
Compound Conditions
Data Independence
14. A delete option in which related records are automatically deleted
Cascade Delete
Integrity
Entity
Criteria
15. The relational algebra command to select rows from a table
DROP TABLE
Outer Join
SELECT
Computed Field
16. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Compound Criteria
Database Management System (DBMS)
SQL (Structured Query Language)
Repeating Groups
17. In relational algebra the operation in which two tables are connected on the basis of common data.
Defining Query
Join
Security
Major Sort Key
18. The process of arranging rows in a table or results of a query in a particular order
Database Management System (DBMS)
Criterion
Major Sort Key
Sort
19. In an Access query the line drawn between tables to indicate how they are related
Field
Join Line
Primary Sort Key
Entity-Relationship (E-R) Diagram
20. A characteristic or property of an entity
Redundancy
Sysindexes
Comparison Operator
Field
21. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
Data Independence
Minor Sort Key
Security
FOREIGN KEY
22. The column on which two tables are joined
Join Column
Aggregate Functions
View
Entity
23. A characteristic or property of an entity
Field
Union
OR Criterion
Database
24. A combination of criteria in which at least on the criteria must be true
OR Criterion
Column
Integrity Constraint
AND Criterion
25. The SQL statement that is used to grant different types of privileges to users of a dataabase
Qualify
GRANT
SELECT
Attribute
26. A data value meaning "unknown" or "not applicable"
Security
Primary Sort Key
Null
Qualify
27. The rule that no column (attribute) that is part of the primary key may accept null values
ALTER TABLE
Attribute
Database
Entity Integrity
28. The part of an SQL SELECT command that restricts the groups to be displayed
Cascade Update
HAVING Clause
Delete Query
Database Administration (DBA)
29. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Database Management System (DBMS)
Join Column
Data Independence
Unnormalized Relation
30. The part of an SQL SELECT command that indicates a sort order
Database Management System (DBMS)
Defining Query
One-to-Many Relationship
ORDER BY Clause
31. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Trigger
Union
Database
Product
32. The field on which data are sorted
Criteria
Reserved Words
Sort Key
Join Column
33. A person or place or object or event or idea for which you want to store and process data
Entity
DROP INDEX
Integrity Constraint
Difference
34. An instruction by a user that directs a database to perform a certain way
Secondary Sort Key
Command
Sysindexes
Division
35. An index built on a single field
Query-By-Example (QBE)
Single-Column Index
Concatenation
Minor Sort Key
36. 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
Index
Join Line
GROUP BY Clause
Referential Integrity
37. The SQL command that drops (deletes) a table from a database
DROP TABLE
Entity Integrity
FROM Clause
Systables
38. A Characteristic or property of an entity
Multiple Column Index
Form
Column
Relation
39. When comparing tables an intersection is a new table containing all rows that are in both original tables
Join Line
Redundancy
Intersection
Integrity Constraint
40. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Database Administrator (DBA)
Data File
Join Line
41. The portion of the system catalog that contains index information
Integrity Constraint
Unnormalized Relation
Sysindexes
Null
42. The relational algebra command to select rows from a table
Sort
SELECT
Validation Rule
Query
43. The portion of the system catalog the contains column information
Validation Rule
Syscolumns
Data Independence
FOREIGN KEY
44. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database
Database Administration (DBA)
Primary Key
System Catalog
Grouping
45. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Delete Query
Relation
Query-By-Example (QBE)
Database
46. The prevention of unauthorized access to a database
Design Grid
Security
Union
Intersection
47. The field on which data are sorted
Index Key
Intersection
Sort Key
Design Grid
48. The SQL command that is used to change the structure of a table
Data Independence
Database
ALTER TABLE
Relational Database
49. When sorting on two fields - the less important field
Multiple-Field Index
Delete Query
Secondary Sort Key
Primary Sort Key
50. 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
Intersection
Attribute
Entity-Relationship (E-R) Diagram
Update Query