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 most common form of a join
Join
HAVING Clause
Natural Join
Primary Key
2. The SQL command that creates an index in a table
SQL (Structured Query Language)
CREATE INDEX
INSERT
Sort
3. The relational algebra command for performing the difference of two tables
Column
Aggregate Functions
SUBTRACT
Query-By-Example (QBE)
4. An association between entities
Union Compatible
Grouping
Query
Relationship
5. A rule that must be followed by data in a database
SQL (Structured Query Language)
Integrity Constraint
Database Management System (DBMS)
Major Sort Key
6. The field or fields on which an index is built
Index Key
Relationship
Redundancy
OR Criterion
7. The individual who is responsible for a database or the head of database administration
Relational Algebra
Multiple-Field Index
Unnormalized Relation
Database Administrator (DBA)
8. The prevention of unauthorized access to a database
Form
Security
Grouping
Join Line
9. When comparing tables the set of all rows that are in the first table but that are not in the second table
Difference
ORDER BY Clause
Sort Key
Database Administration (DBA)
10. A file that relates key values to records that contain those key values
Cascade Update
Relationship
Intersection
Index
11. The table obtained by concatenating every row in the first table with every row in the second table
Database Management System (DBMS)
Integrity Constraint
Product
Data Macro
12. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Update Query
FROM Clause
Unnormalized Relation
Column
13. An index built on more than one field
Relational Database
Concatenation
Multiple Column Index
Database
14. A condition that involves only a single field and a single value
Form
Database Management System (DBMS)
Outer Join
Simple Condition
15. A rule in Access that data entered in a field must satisfy
Concatenation
Minor Sort Key
Validation Rule
INTERSECT
16. Duplication of data or the storing of the same data in more than one place.
Compound Conditions
HAVING Clause
SELECT Clause
Redundancy
17. The form of a join in which all records appear - even if they don't match
Query
Outer Join
Validation Rule
CREATE TABLE
18. When comparing tables an intersection is a new table containing all rows that are in both original tables
Security
Defining Query
Delete Query
Intersection
19. A field whose value is computed from other fields in the database
Calculated Field
Sysindexes
FROM Clause
Sort
20. A collection of relations
Relational Database
One-to-Many Relationship
PRIMARY KEY
Query
21. Two simple criteria in a query the are combined with the AND or OR operators
Primary Key
Aggregate Functions
One-to-Many Relationship
Compound Conditions
22. The field on which data are sorted
Database Administrator (DBA)
Sort Key
Entity-Relationship (E-R) Diagram
Redundancy
23. 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
One-to-Many Relationship
Relational Database
Primary Sort Key
Redundancy
24. A person or place or object or event or idea for which you want to store and process data
Entity
Difference
Database
Database Design
25. When sorting on two fields - the less important field
Join
Relational Database
Secondary Sort Key
Single-Field Index
26. In relational algebra the operation in which two tables are connected on the basis of common data.
Criteria
Join
Attribute
Database Management System (DBMS)
27. A combination of two tables consisting of all records that are in either table
Single-Field Index
Union
SELECT
Null
28. When sorting on two fields this is the more important field
Relational Algebra
CREATE TABLE
Primary Sort Key
Update Query
29. An association between entities
Relationship
Form
Design Grid
Primary Key
30. 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
Compound Conditions
Systables
Major Sort Key
31. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
Single-Field Index
Database Administration (DBA)
Trigger
Sort
32. The form of a join in which all records appear - even if they don't match
Index Key
Outer Join
Referential Integrity
Functions
33. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Entity-Relationship (E-R) Diagram
Database
Secondary Sort Key
Attribute
34. 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
Join
Product
Relation
SQL (Structured Query Language)
35. When sorting on two fields this is the more important field
Minor Sort Key
Primary Sort Key
Relationship
Database Administrator (DBA)
36. 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
Server
Integrity
Relation
Integrity Constraint
37. In an Access query the line drawn between tables to indicate how they are related
Join Line
Primary Key
View
Database
38. The part of an SQL SELECT command that indicates the columns to be included in the query results
Redundancy
SELECT Clause
Query
FOREIGN KEY
39. When sorting on two fields - the less important field
Relational Database
Delimiter
Concatenation
Secondary Sort Key
40. A field whose value is computed from other fields in the database
Attribute
Repeating Groups
Computed Field
Join Line
41. The individual or group that is responsible for a database
Statement History
DELETE
Database Administration (DBA)
Qualify
42. A file used to store data about a single entity. Such a file can be thought of as a table.
Subquery
Database
Redundancy
Data File
43. The table obtained by concatenating every row in the first table with every row in the second table
Cartesian Product
Database Administration (DBA)
Attribute
Reserved Words
44. The query that is used to define the structure of a viewk
Single-Column Index
Integrity Constraint
Defining Query
Design Grid
45. The SQL command used to add new data to a table
INSERT
Security
Query
Calculated Field
46. A Characteristic or property of an entity
Computed Field
Database Administration (DBA)
Column
Data Independence
47. 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
Cascade Update
CREATE TABLE
Union
Computed Field
48. The property that no record can exist in the database with a value in a field other than a legal value
Legal-Values Integrity
Relation
Relational Database
Primary Key
49. In an Access query the line drawn between tables to indicate how they are related
Join Line
Entity Integrity
Entity
SELECT Clause
50. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
PRIMARY KEY
Data Macro
Sort Key
Delimiter