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 portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Grouping
Query-By-Example (QBE)
Sort
2. The column on which two tables are joined
Form
Repeating Groups
REVOKE
Join Column
3. An index built on more than one field
Primary Key
Multiple-Field Index
Qualify
SUBTRACT
4. 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
Delete Query
Aggregate Functions
Functions
GROUP BY Clause
5. The part of an SQL SELECT command that indicates the columns to be included in the query results
SELECT Clause
Major Sort Key
Command
Entity
6. A file that relates key values to records that contain those key values
Index
Union
Row-and Column Subset View
Sysviews
7. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Validation Rule
Qualify
Relationship
DROP INDEX
8. The individual or group that is responsible for a database
Database Administration (DBA)
Multiple Column Index
Sort Key
Sysindexes
9. When sorting on two fields this is the more important field
Form
Relation
Primary Sort Key
SELECT
10. A view that consists of a subset of the rows and columns in a table
Row-and Column Subset View
One-to-Many Relationship
Integrity Constraint
Major Sort Key
11. A punctuation mark - such as a semicolon - that separates pieces of data
Delimiter
Single-Field Index
Unnormalized Relation
Data Independence
12. 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
Field
One-to-Many Relationship
Data Independence
Unnormalized Relation
13. When comparing tables an intersection is a new table containing all rows that are in both original tables
Command
Multiple Column Index
Primary Key
Intersection
14. The SQL command used to delete a table
Qualify
Compound Criteria
DELETE
Attribute
15. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database
FOREIGN KEY
Aggregate Functions
System Catalog
Data Independence
16. The process of arranging rows in a table or results of a query in a particular order
Sort
Relation
Compound Conditions
Primary Key
17. Combination of criteria in which both criteria must be true
Difference
Cascade Update
AND Criterion
Database Administrator (DBA)
18. The SQL command that drops (deletes) and index from a table
DROP INDEX
Database Administration (DBA)
Delimiter
Database Design
19. A collection of relations
Outer Join
Relational Database
SELECT
Database Administrator (DBA)
20. The rule that no column (attribute) that is part of the primary key may accept null values
SELECT
Entity Integrity
SELECT Clause
Column
21. Combination of criteria in which both criteria must be true
Functions
HAVING Clause
Concatenation
AND Criterion
22. 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
Qualify
One-to-Many Relationship
Update Query
Cascade Update
23. A word that is part of the SQL language
Reserved Words
Natural Join
Primary Key
Repeating Groups
24. When comparing tables an intersection is a new table containing all rows that are in both original tables
Repeating Groups
Integrity
DELETE
Intersection
25. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table
Compound Criteria
Concatenation
SUBTRACT
Column
26. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Data Macro
Cascade Update
Database
Redundancy
27. The SQL command used to describe the layout of a table. The word table is followed by the name of the table to be created and then by the names and data types of the column (fields) that comprise the table
Primary Key
Entity
CREATE TABLE
Integrity Constraint
28. The portion of the system catalog that contains table information
Systables
Union
Redundancy
Documenter
29. 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
Repeating Groups
Redundancy
Entity-Relationship (E-R) Diagram
Entity
30. More than one entry at a single location in a table
Redundancy
OR Criterion
Database Management System (DBMS)
Repeating Groups
31. In an Access query the line drawn between tables to indicate how they are related
Join Line
SUBTRACT
DROP INDEX
One-to-Many Relationship
32. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table
OR Criterion
Multiple Column Index
Concatenation
Sort
33. 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 Design
ORDER BY Clause
Query-By-Example (QBE)
OR Criterion
34. The SQL command that is used to change the structure of a table
Validation Text
Entity
ALTER TABLE
Single-Field Index
35. In relational algebra the operation in which two tables are connected on the basis of common data.
Entity-Relationship (E-R) Diagram
Calculated Field
Join
INSERT
36. The process of creating collections of records that share some common characteristics
Sort
Integrity
Column
Grouping
37. The form of a join in which all records appear - even if they don't match
Legal-Values Integrity
PRIMARY KEY
Primary Sort Key
Outer Join
38. The SQL statement that is used to grant different types of privileges to users of a dataabase
Database Administrator (DBA)
Criterion
GRANT
Criteria
39. A field whose value is computed from other fields in the database
Unnormalized Relation
Calculated Field
Data File
One-to-Many Relationship
40. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Secondary Sort Key
Command
Query-By-Example (QBE)
Relational Database
41. When sorting on two fields - the less important field
Cartesian Product
Repeating Groups
Column
Minor Sort Key
42. An update option in which related records are automatically updated
Integrity
Catalog
Cascade Update
Index
43. A database has integrity if the data in it satisfies all established integrity constraints
Database Management System (DBMS)
GROUP BY Clause
Integrity
Grouping
44. 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
Database Design
Database
Multiple Column Index
Relation
45. The process of creating collections of records that share some common characteristics
Qualify
Database Design
Grouping
Entity
46. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Secondary Sort Key
DROP INDEX
Database Design
47. A file used to store data about a single entity. Such a file can be thought of as a table.
OR Criterion
Database Administration (DBA)
Aggregate Functions
Data File
48. 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
Criterion
One-to-Many Relationship
Relationship
Field
49. An index built on a single field
Data File
Field
Single-Field Index
Data File
50. The column on which two tables are joined
Attribute
Join Column
GRANT
Security