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 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
Attribute
Data File
Field
Entity-Relationship (E-R) Diagram
2. A file containing a collection of compiled and optimized SQL statements that are available for future use
Column
Stored Procedure
Data File
Subquery
3. The SQL statement that is used to grant different types of privileges to users of a dataabase
Concatenation
Database
GRANT
Attribute
4. The SQL command that is used to change the structure of a table
ALTER TABLE
Database Management System (DBMS)
Data Independence
Minor Sort Key
5. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column
Relational Database
Aggregate Functions
Database Design
Intersection
6. A field whose value is computed from other fields in the database
Primary Sort Key
Entity
Intersection
Computed Field
7. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Make-Table Query
Qualify
Sort Key
Relational Database
8. The relational algebra command for performing the intersection of two tables
INTERSECT
Criteria
Criteria
REVOKE
9. In Access the query that updates the contents of a table
Computed Field
Form
Concatenation
Update Query
10. The individual who is responsible for a database or the head of database administration
Aggregate Functions
View
SELECT
Database Administrator (DBA)
11. The rule that no column (attribute) that is part of the primary key may accept null values
Multiple Column Index
Entity Integrity
Compound Criteria
Relational Database
12. 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
GRANT
Entity-Relationship (E-R) Diagram
Reserved Words
Join Line
13. The SQL clause that is used to enforce legal-values integrity
Query-By-Example (QBE)
Redundancy
Unnormalized Relation
CHECK
14. More than one entry at a single location in a table
Stored Procedure
SELECT
Repeating Groups
Entity Integrity
15. 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
Data File
Referential Integrity
Natural Join
Data Independence
16. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Relation
Database
One-to-Many Relationship
Database Design
17. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns
Minor Sort Key
Attribute
Relation
ALTER TABLE
18. An access query that creates a table using the results of a query
SUBTRACT
Multiple Column Index
Make-Table Query
Intersection
19. In relational algebra the operation in which two tables are connected on the basis of common data.
Integrity
FROM Clause
Join
Single-Field Index
20. The portion of the system catalog that contains index information
Outer Join
Sysindexes
Relation
Repeating Groups
21. A file used to store data about a single entity. Such a file can be thought of as a table.
Column
Data File
Sysviews
Validation Rule
22. The portion of the system catalog the contains column information
Aggregate Functions
Row-and Column Subset View
Database Administrator (DBA)
Syscolumns
23. More than one entry at a single location in a table
DROP TABLE
Aggregate Functions
Field
Repeating Groups
24. The relational algebra command for performing the difference of two tables
SUBTRACT
Join Column
Validation Rule
Compound Conditions
25. The column on which two tables are joined
Union
Redundancy
Join Column
System Catalog
26. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Security
Sort Key
INTERSECT
Unnormalized Relation
27. A question the answer to which is found in the database
Row-and Column Subset View
Integrity
Query
Unnormalized Relation
28. In an Access query the line drawn between tables to indicate how they are related
Division
Database
Join Line
Sort Key
29. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Relational Database
Database
Statement History
30. The individual or group that is responsible for a database
Aggregate Functions
Primary Key
Database Administration (DBA)
Database Management System (DBMS)
31. A person or place or object or event or idea for which you want to store and process data
Cascade Delete
Grouping
Entity
Update Query
32. Two simple criteria in a query the are combined with the AND or OR operators
Repeating Groups
Data Independence
Integrity
Compound Conditions
33. What type of an operator is >= ?
Attribute
Comparison Operator
One-to-Many Relationship
Relation
34. A combination of two tables consisting of all records that are in either table
Product
Union
HAVING Clause
Entity-Relationship (E-R) Diagram
35. 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
Primary Sort Key
Redundancy
One-to-Many Relationship
Query-By-Example (QBE)
36. The individual or group that is responsible for a database
Database Administration (DBA)
FOREIGN KEY
Update Query
Redundancy
37. The SQL command that drops (deletes) a table from a database
Primary Key
Criteria
DROP TABLE
Join
38. An index built on more than one field
Relation
Field
Multiple-Field Index
PRIMARY KEY
39. Additional information required by an action in a data macro to complete the action
Attribute
Update Query
Join
Arguments
40. The portion of the system catalog that contains view information
Relation
Simple Condition
Unnormalized Relation
Sysviews
41. When comparing tables an intersection is a new table containing all rows that are in both original tables
Query-By-Example (QBE)
Cascade Update
Intersection
Redundancy
42. In an Access query the line drawn between tables to indicate how they are related
Redundancy
FOREIGN KEY
Database Administrator (DBA)
Join Line
43. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Relational Database
Redundancy
Unnormalized Relation
Data Independence
44. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column
Data Independence
Repeating Groups
Syscolumns
Functions
45. 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
Sort
Database Design
Division
PROJECT
46. A data value meaning "unknown" or "not applicable"
Delimiter
Unnormalized Relation
Null
Index Key
47. The SQL command that drops (deletes) and index from a table
DROP INDEX
Union
Reserved Words
Index
48. The individual or group that is responsible for a database
Data File
SELECT Clause
GRANT
Database Administration (DBA)
49. When comparing tables the set of all rows that are in the first table but that are not in the second table
Difference
Computed Field
OR Criterion
Field
50. The area of memory in MySQL that stores the most recently entered command
Union Compatible
Statement History
Outer Join
Primary Key