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 characteristic or property of an entity
Attribute
Entity-Relationship (E-R) Diagram
Concatenation
Difference
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.
Union
Primary Key
Integrity Constraint
Comparison Operator
3. The process of creating collections of records that share some common characteristics
Grouping
Delete Query
Primary Key
Cartesian Product
4. The portion of the system catalog that contains view information
Sysviews
Relation
Outer Join
One-to-Many Relationship
5. A data value meaning "unknown" or "not applicable"
Join Column
Null
Column
Primary Sort Key
6. A rule in Access that data entered in a field must satisfy
Concatenation
Validation Rule
Design Grid
Sort
7. A query that deletes all records that satisfy some criterion
Relational Algebra
Sort Key
Delete Query
SUBTRACT
8. A combination of two tables consisting of all records that are in either table
Union
Concatenation
Database Management System (DBMS)
Legal-Values Integrity
9. The field or fields on which an index is built
Index Key
Attribute
Minor Sort Key
Compound Conditions
10. Two simple criteria in a query the are combined with the AND or OR operators
Primary Key
FROM Clause
Compound Criteria
AND Criterion
11. The part of an SQL SELECT command that indicates a sort order
Update Query
Primary Sort Key
Sort Key
ORDER BY Clause
12. A combination of criteria in which at least on the criteria must be true
Compound Conditions
OR Criterion
INSERT
Column
13. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Data Independence
Union Compatible
Qualify
Unnormalized Relation
14. The prevention of unauthorized access to a database
Outer Join
Database Design
Security
FOREIGN KEY
15. A message in Access that is displayed when a validation rule is violated
Qualify
Validation Text
Single-Field Index
Comparison Operator
16. The SQL command that drops (deletes) and index from a table
Single-Field Index
DROP INDEX
Index Key
Make-Table Query
17. A collection of relations
Entity-Relationship (E-R) Diagram
Sort
Relational Database
Legal-Values Integrity
18. Additional information required by an action in a data macro to complete the action
Intersection
Calculated Field
Relational Algebra
Arguments
19. A database has integrity if the data in it satisfies all established integrity constraints
Validation Text
Column
Statement History
Integrity
20. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Criteria
DROP TABLE
OR Criterion
21. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Compound Conditions
Data Independence
Design Grid
Reserved Words
22. An update option in which related records are automatically updated
Database Administration (DBA)
Sysindexes
Cascade Update
Sysviews
23. An access query that creates a table using the results of a query
Comparison Operator
Database
Make-Table Query
Relationship
24. The prevention of unauthorized access to a database
Compound Conditions
Simple Condition
Security
Major Sort Key
25. The individual or group that is responsible for a database
Criteria
Entity-Relationship (E-R) Diagram
Database Administration (DBA)
SUBTRACT
26. A screen object you use to maintain or view and print data from a database
Join Column
Make-Table Query
Unnormalized Relation
Form
27. A rule that must be followed by data in a database
Design Grid
Sort Key
Integrity Constraint
Database Administrator (DBA)
28. A query that deletes all records that satisfy some criterion
Minor Sort Key
Legal-Values Integrity
Delete Query
Redundancy
29. The SQL statement that is used to grant different types of privileges to users of a dataabase
Unnormalized Relation
GRANT
Entity
INSERT
30. A characteristic or property of an entity
CREATE TABLE
OR Criterion
Field
System Catalog
31. A collection of relations
Relational Database
DROP INDEX
Delimiter
Database Design
32. A collection of relations
Relation
Attribute
Relational Database
Update Query
33. The most common form of a join
FOREIGN KEY
Natural Join
PROJECT
Cartesian Product
34. 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
Sysviews
Join Column
Integrity
One-to-Many Relationship
35. The relational algebra command used to select columns from a table
DROP TABLE
Trigger
Sort Key
PROJECT
36. A field whose value is computed from other fields in the database
Redundancy
FOREIGN KEY
Calculated Field
Product
37. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Row-and Column Subset View
Make-Table Query
Column
Relational Algebra
38. The area of memory in MySQL that stores the most recently entered command
Functions
Entity-Relationship (E-R) Diagram
Statement History
Join Line
39. An association between entities
Relationship
Delete Query
Primary Key
Query
40. 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
Validation Rule
Command
Integrity Constraint
Entity-Relationship (E-R) Diagram
41. The relational algebra command to select rows from a table
SELECT
Compound Conditions
Legal-Values Integrity
Defining Query
42. A Characteristic or property of an entity
Column
Functions
Make-Table Query
Compound Conditions
43. When sorting on two fields - the less important field
Minor Sort Key
Field
Entity
Integrity Constraint
44. The SQL command that is used to change the structure of a table
ALTER TABLE
DROP TABLE
Join Line
Join
45. A view that consists of a subset of the rows and columns in a table
Data Macro
Row-and Column Subset View
Secondary Sort Key
Primary Key
46. The plural of Criterion
Criteria
Entity
Repeating Groups
INTERSECT
47. The field on which data are sorted
Sort Key
Sort
Division
Database Administrator (DBA)
48. Duplication of data or the storing of the same data in more than one place.
Attribute
Row-and Column Subset View
Database Design
Redundancy
49. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Database
Data File
SELECT Clause
Data Independence
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
Database
Database Design
Make-Table Query
Integrity Constraint