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 table obtained by concatenating every row in the first table with every row in the second table
Security
Outer Join
Delimiter
Product
2. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Intersection
REVOKE
Relational Algebra
Primary Key
3. A data value meaning "unknown" or "not applicable"
Column
Integrity
Null
Database Administration (DBA)
4. A combination of two tables consisting of all records that are in either table
Grouping
Union
Column
Comparison Operator
5. In an Access query the line drawn between tables to indicate how they are related
View
Multiple-Field Index
Delete Query
Join Line
6. An access tool that provides documentation about the objects in a database
PROJECT
Redundancy
Documenter
Single-Column Index
7. A statement the can be either true or false. Also called a condition
Criterion
Qualify
Arguments
Secondary Sort Key
8. When comparing tables the set of all rows that are in the first table but that are not in the second table
Systables
Grouping
Difference
Compound Conditions
9. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Primary Sort Key
Catalog
Join
Qualify
10. A field whose value is computed from other fields in the database
Redundancy
Outer Join
Comparison Operator
Computed Field
11. An access query that creates a table using the results of a query
Database Management System (DBMS)
Form
Command
Make-Table Query
12. A condition that involves only a single field and a single value
Integrity Constraint
Simple Condition
View
SELECT
13. The portion of the system catalog that contains index information
Sysindexes
Relation
Relationship
Unnormalized Relation
14. 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
Validation Text
One-to-Many Relationship
Secondary Sort Key
Database Design
15. When sorting on two fields this is the more important field
Make-Table Query
Database
Primary Sort Key
DROP INDEX
16. A view that consists of a subset of the rows and columns in a table
Row-and Column Subset View
Integrity
Attribute
Make-Table Query
17. The plural of Criterion
Relation
Attribute
Sysindexes
Criteria
18. A collection of relations
One-to-Many Relationship
Relational Database
Delimiter
SELECT Clause
19. A query that deletes all records that satisfy some criterion
Data Independence
Delete Query
Difference
Security
20. A data value meaning "unknown" or "not applicable"
PROJECT
Relationship
Column
Null
21. More than one entry at a single location in a table
Field
Join
Repeating Groups
Design Grid
22. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Primary Sort Key
Join Line
Unnormalized Relation
Compound Criteria
23. 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
Functions
Validation Rule
Attribute
HAVING Clause
24. 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
Aggregate Functions
Entity-Relationship (E-R) Diagram
Data File
Field
25. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Primary Sort Key
One-to-Many Relationship
OR Criterion
Database
26. A screen object you use to maintain or view and print data from a database
Relationship
Repeating Groups
Form
Attribute
27. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
Division
Cartesian Product
Qualify
Defining Query
28. A person or place or object or event or idea for which you want to store and process data
Database Administrator (DBA)
Entity
Join
One-to-Many Relationship
29. When sorting on two fields - the less important field
Sysindexes
Criterion
Secondary Sort Key
Concatenation
30. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
Index
Delete Query
Arguments
31. 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
Qualify
Redundancy
Relation
Comparison Operator
32. A Characteristic or property of an entity
Concatenation
Column
Sort Key
Make-Table Query
33. A database has integrity if the data in it satisfies all established integrity constraints
Criteria
Integrity
Sysindexes
Join
34. 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.
Grouping
Primary Key
ALTER TABLE
Syscolumns
35. What type of an operator is >= ?
Comparison Operator
CREATE INDEX
Attribute
Sysviews
36. The relational algebra command for performing the difference of two tables
Security
SUBTRACT
Relationship
Defining Query
37. The form of a join in which all records appear - even if they don't match
Design Grid
Outer Join
Minor Sort Key
Database Administration (DBA)
38. A combination of criteria in which at least on the criteria must be true
Column
Index
Intersection
OR Criterion
39. The relational algebra command used to select columns from a table
Update Query
PROJECT
Repeating Groups
Single-Field Index
40. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
HAVING Clause
Division
Sort
41. 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
Query
Join
Functions
Qualify
42. 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
Join Column
One-to-Many Relationship
View
Update Query
43. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Multiple-Field Index
Reserved Words
Referential Integrity
44. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Database Administrator (DBA)
Compound Criteria
Design Grid
Primary Key
45. A file used to store data about a single entity. Such a file can be thought of as a table.
Delimiter
Sysviews
Data File
Design Grid
46. The field on which data are sorted
Column
Sort Key
Column
Attribute
47. A question the answer to which is found in the database
Query
Delete Query
SQL (Structured Query Language)
Delete Query
48. Two simple criteria in a query the are combined with the AND or OR operators
SUBTRACT
Sort Key
Compound Conditions
Query
49. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.
Cascade Update
Integrity
Data Macro
Outer Join
50. More than one entry at a single location in a table
Integrity Constraint
Foreign Key
Documenter
Repeating Groups