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 structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Update Query
Database
Entity-Relationship (E-R) Diagram
Attribute
2. A punctuation mark - such as a semicolon - that separates pieces of data
Update Query
Delimiter
ORDER BY Clause
Secondary Sort Key
3. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
SELECT
REVOKE
Trigger
Make-Table Query
4. A question the answer to which is found in the database
Index
Index Key
Query
Calculated Field
5. The relational algebra command used to select columns from a table
Relational Algebra
Cartesian Product
PROJECT
SUBTRACT
6. The individual who is responsible for a database or the head of database administration
Entity
Database Administrator (DBA)
Join Line
Aggregate Functions
7. A Characteristic or property of an entity
Entity-Relationship (E-R) Diagram
Column
Single-Column Index
Stored Procedure
8. The column on which two tables are joined
Systables
Database Administration (DBA)
Integrity Constraint
Join Column
9. The plural of Criterion
Legal-Values Integrity
Validation Text
Primary Key
Criteria
10. The process of arranging rows in a table or results of a query in a particular order
One-to-Many Relationship
Make-Table Query
Sort
WHERE Clause
11. Additional information required by an action in a data macro to complete the action
Column
PROJECT
Arguments
Delete Query
12. Two simple criteria in a query the are combined with the AND or OR operators
Calculated Field
Qualify
REVOKE
Compound Criteria
13. When sorting on two fields - the less important field
Query
AND Criterion
Database
Minor Sort Key
14. A word that is part of the SQL language
Reserved Words
Unnormalized Relation
Compound Conditions
Sort
15. Duplication of data or the storing of the same data in more than one place.
Integrity
Entity-Relationship (E-R) Diagram
Redundancy
Make-Table Query
16. A question the answer to which is found in the database
Minor Sort Key
Query
Relationship
Attribute
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
Attribute
GROUP BY Clause
Simple Condition
Relation
18. The plural of Criterion
Validation Text
PRIMARY KEY
Systables
Criteria
19. 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
Arguments
HAVING Clause
Database Design
Sort
20. A data value meaning "unknown" or "not applicable"
Relational Database
Database Management System (DBMS)
Null
Major Sort Key
21. A view that consists of a subset of the rows and columns in a table
Primary Key
Row-and Column Subset View
Secondary Sort Key
Stored Procedure
22. The rule that no column (attribute) that is part of the primary key may accept null values
Relation
Join Line
Integrity
Entity Integrity
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
Defining Query
Criteria
Computed Field
Functions
24. 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.
Minor Sort Key
Security
Primary Key
Database Administration (DBA)
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
Concatenation
Security
Index Key
Integrity
26. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Single-Column Index
Qualify
Database
Calculated Field
27. The column on which two tables are joined
Join Column
Relation
Referential Integrity
Major Sort Key
28. A rule that must be followed by data in a database
Join Line
Query-By-Example (QBE)
CHECK
Integrity Constraint
29. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Comparison Operator
Data File
Data Independence
Column
30. The SQL command that is used to change the structure of a table
Null
Primary Sort Key
Join Column
ALTER TABLE
31. The part of an SQL SELECT command that indicates the columns to be included in the query results
SELECT Clause
Redundancy
Database Management System (DBMS)
Union Compatible
32. The process of creating collections of records that share some common characteristics
ALTER TABLE
Calculated Field
Grouping
Database
33. The part of an SQL SELECT command that indicates the tables in the query
Intersection
FROM Clause
Security
Database Management System (DBMS)
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
Repeating Groups
Relation
Unnormalized Relation
Query-By-Example (QBE)
35. A person or place or object or event or idea for which you want to store and process data
Entity
ALTER TABLE
Attribute
AND Criterion
36. The individual or group that is responsible for a database
Sort Key
Relation
OR Criterion
Database Administration (DBA)
37. The prevention of unauthorized access to a database
Security
Data Independence
CREATE INDEX
Delimiter
38. 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
Relational Algebra
CREATE TABLE
Compound Criteria
SUBTRACT
39. The relational algebra command to select rows from a table
Primary Sort Key
SELECT
Simple Condition
Intersection
40. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Entity-Relationship (E-R) Diagram
Qualify
Functions
Minor Sort Key
41. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Criterion
Redundancy
Index Key
Union Compatible
42. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Simple Condition
GROUP BY Clause
Sysviews
SQL (Structured Query Language)
43. The portion of the system catalog that contains index information
Sysindexes
PROJECT
Field
Stored Procedure
44. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Catalog
Single-Field Index
DELETE
Legal-Values Integrity
45. Duplication of data or the storing of the same data in more than one place.
Column
Delete Query
Outer Join
Redundancy
46. An index built on a single field
Single-Field Index
Data Independence
Field
Natural Join
47. 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
Update Query
Division
Referential Integrity
Database Design
48. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.
Catalog
Database Design
Data Macro
Query
49. A field whose value is computed from other fields in the database
View
SELECT
Form
Calculated Field
50. A combination of two tables consisting of all records that are in either table
Union
Relational Database
Entity
Make-Table Query