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 individual who is responsible for a database or the head of database administration
Delimiter
View
Database Administrator (DBA)
Catalog
2. Duplication of data or the storing of the same data in more than one place.
Functions
Redundancy
Minor Sort Key
Systables
3. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Attribute
Command
Relational Algebra
Integrity Constraint
4. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Data Independence
Difference
Functions
INSERT
5. The SQL command used to delete a table
Database
Concatenation
DELETE
HAVING Clause
6. The SQL command used to add new data to a table
Entity
Defining Query
Delete Query
INSERT
7. An application program's or an individual user's picture of a database
Join Line
View
Entity
Database Administrator (DBA)
8. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Entity Integrity
Integrity
Data Independence
Design Grid
9. An index built on a single field
Criterion
Single-Field Index
Relationship
Join Line
10. A question the answer to which is found in the database
Entity
Query
Index Key
Unnormalized Relation
11. A Characteristic or property of an entity
Database Administration (DBA)
Column
Validation Rule
Criterion
12. A rule that must be followed by data in a database
Primary Key
Column
Integrity Constraint
Repeating Groups
13. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
Database Administration (DBA)
Major Sort Key
Cascade Update
FOREIGN KEY
14. The column on which two tables are joined
Data File
Join Column
Multiple-Field Index
Calculated Field
15. An association between entities
Relationship
SUBTRACT
Repeating Groups
Index
16. The part of an SQL SELECT command that indicates the columns to be included in the query results
AND Criterion
Relation
Functions
SELECT Clause
17. A characteristic or property of an entity
Relation
Field
Relation
Join Line
18. 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
Integrity
Update Query
Relation
Union
19. A rule in Access that data entered in a field must satisfy
Validation Rule
One-to-Many Relationship
Relation
Criteria
20. When sorting on two fields this is the more important field
Difference
Database
Major Sort Key
SELECT
21. When sorting on two fields this is the more important field
Aggregate Functions
PROJECT
Primary Sort Key
Entity Integrity
22. A characteristic or property of an entity
Entity-Relationship (E-R) Diagram
Attribute
Primary Key
CREATE TABLE
23. A Characteristic or property of an entity
Column
Entity-Relationship (E-R) Diagram
SELECT Clause
Comparison Operator
24. When sorting on two fields - the less important field
Entity-Relationship (E-R) Diagram
Secondary Sort Key
DROP INDEX
Multiple Column Index
25. A query that deletes all records that satisfy some criterion
Security
Delete Query
One-to-Many Relationship
Minor Sort Key
26. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Query-By-Example (QBE)
Data Macro
Database Administration (DBA)
AND Criterion
27. A question the answer to which is found in the database
Relational Algebra
Catalog
Query
Attribute
28. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Join Line
Database
Make-Table Query
Validation Text
29. An association between entities
Relationship
Join
Database Administration (DBA)
Union
30. A database has integrity if the data in it satisfies all established integrity constraints
Query-By-Example (QBE)
PROJECT
Database Management System (DBMS)
Integrity
31. A collection of relations
Relational Database
Query-By-Example (QBE)
Comparison Operator
Primary Sort Key
32. Duplication of data or the storing of the same data in more than one place.
Redundancy
Database Administrator (DBA)
WHERE Clause
Syscolumns
33. An access tool that provides documentation about the objects in a database
Sort
Documenter
Validation Rule
Cascade Delete
34. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Relational Algebra
Multiple-Field Index
Qualify
Relationship
35. The table obtained by concatenating every row in the first table with every row in the second table
Relational Database
Query
Product
Secondary Sort Key
36. An index built on a single field
Compound Criteria
Defining Query
Sort Key
Single-Column Index
37. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Catalog
Form
ALTER TABLE
Database
38. 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
HAVING Clause
Relation
Union
Unnormalized Relation
39. The SQL command that is used to change the structure of a table
Relationship
ALTER TABLE
SUBTRACT
Integrity
40. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
Query
CREATE TABLE
Single-Column Index
41. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Delete Query
Database Management System (DBMS)
Reserved Words
42. The query that is used to define the structure of a viewk
CREATE TABLE
Relationship
Defining Query
Relation
43. 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
Database Administrator (DBA)
Trigger
Database Administrator (DBA)
One-to-Many Relationship
44. The prevention of unauthorized access to a database
Security
Sort Key
Make-Table Query
Relationship
45. The property that no record can exist in the database with a value in a field other than a legal value
View
Security
Legal-Values Integrity
Data Independence
46. An index built on more than one field
GROUP BY Clause
Command
Multiple Column Index
Row-and Column Subset View
47. A delete option in which related records are automatically deleted
Cascade Delete
Delete Query
Relation
Compound Criteria
48. The process of creating collections of records that share some common characteristics
Syscolumns
Sysindexes
Comparison Operator
Grouping
49. The individual or group that is responsible for a database
Database Administration (DBA)
SELECT Clause
Documenter
Data File
50. The relational algebra command used to select columns from a table
Database
Relation
PROJECT
Criterion