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
Integrity Constraint
Legal-Values Integrity
Design Grid
Qualify
2. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Data Macro
Unnormalized Relation
Subquery
Null
3. A question the answer to which is found in the database
Query
Database Administration (DBA)
Relationship
Division
4. The individual or group that is responsible for a database
Database Management System (DBMS)
Database Administration (DBA)
Index Key
Make-Table Query
5. A person or place or object or event or idea for which you want to store and process data
Entity
FOREIGN KEY
Security
Sort
6. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
CHECK
Validation Rule
Database
GROUP BY Clause
7. When sorting on two fields - the less important field
ORDER BY Clause
Comparison Operator
Secondary Sort Key
Database Management System (DBMS)
8. The table obtained by concatenating every row in the first table with every row in the second table
Minor Sort Key
Cartesian Product
Catalog
Integrity Constraint
9. The process of creating collections of records that share some common characteristics
Database Management System (DBMS)
Grouping
Join Line
Integrity
10. 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
Relation
Data Independence
DROP INDEX
Stored Procedure
11. In an Access query the line drawn between tables to indicate how they are related
Statement History
Reserved Words
Delete Query
Join Line
12. The portion of the system catalog that contains index information
Compound Criteria
Entity-Relationship (E-R) Diagram
Design Grid
Sysindexes
13. The SQL command used to delete a table
Unnormalized Relation
Query-By-Example (QBE)
DELETE
Integrity
14. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null
Database Administrator (DBA)
Grouping
Join Line
Foreign Key
15. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
Database
FOREIGN KEY
Integrity Constraint
SQL (Structured Query Language)
16. A screen object you use to maintain or view and print data from a database
Security
Form
Cascade Update
Multiple Column Index
17. An instruction by a user that directs a database to perform a certain way
Command
Server
One-to-Many Relationship
Validation Rule
18. An access tool that provides documentation about the objects in a database
Primary Sort Key
Documenter
Foreign Key
Field
19. A condition that involves only a single field and a single value
Calculated Field
Simple Condition
PROJECT
Difference
20. The relational algebra command to select rows from a table
Security
SELECT
Outer Join
Entity
21. A file that relates key values to records that contain those key values
Index
Entity-Relationship (E-R) Diagram
Computed Field
Data File
22. The SQL command used to make changes to existing table data
Update Query
Relational Database
UPDATE
Integrity Constraint
23. A field whose value is computed from other fields in the database
Calculated Field
Database
Minor Sort Key
SELECT
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.
One-to-Many Relationship
Primary Key
Index
FROM Clause
25. The SQL statement that is used to grant different types of privileges to users of a dataabase
Entity
Secondary Sort Key
Systables
GRANT
26. A message in Access that is displayed when a validation rule is violated
Qualify
Validation Text
Subquery
CREATE TABLE
27. When sorting on two fields this is the more important field
Multiple-Field Index
FROM Clause
Major Sort Key
INSERT
28. Duplication of data or the storing of the same data in more than one place.
Secondary Sort Key
Systables
Redundancy
Compound Criteria
29. The SQL command that drops (deletes) and index from a table
Compound Criteria
DROP INDEX
AND Criterion
Arguments
30. When sorting on two fields this is the more important field
Database Design
Primary Sort Key
PROJECT
Database
31. 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
Documenter
Entity-Relationship (E-R) Diagram
DROP INDEX
32. A program or a collection of programs through which users interact with a database
Database Design
Database Management System (DBMS)
Database Administrator (DBA)
Column
33. The prevention of unauthorized access to a database
Secondary Sort Key
Form
Security
Make-Table Query
34. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Query
Database
Sort Key
Data Independence
35. The query that is used to define the structure of a viewk
Documenter
Defining Query
Security
Sort Key
36. Additional information required by an action in a data macro to complete the action
Arguments
Null
Multiple-Field Index
Catalog
37. An index built on a single field
Single-Field Index
Primary Sort Key
Major Sort Key
Multiple-Field Index
38. 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
Criteria
Difference
CREATE INDEX
One-to-Many Relationship
39. An association between entities
Outer Join
Relationship
Criterion
Attribute
40. A data value meaning "unknown" or "not applicable"
Comparison Operator
Null
System Catalog
Multiple Column Index
41. A statement the can be either true or false. Also called a condition
Grouping
View
Criterion
Join Line
42. A statement the can be either true or false. Also called a condition
Column
Minor Sort Key
Criterion
Repeating Groups
43. Combination of criteria in which both criteria must be true
Integrity
AND Criterion
Repeating Groups
Query
44. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
PROJECT
Division
Relational Algebra
Database Administrator (DBA)
45. A program or a collection of programs through which users interact with a database
Sort
Subquery
Database Management System (DBMS)
Cartesian Product
46. The SQL statement that is used to revoke privileges from users of a database
Foreign Key
REVOKE
Entity
Cartesian Product
47. A characteristic or property of an entity
Attribute
Syscolumns
Database Design
Aggregate Functions
48. The relational algebra command used to select columns from a table
GRANT
OR Criterion
PROJECT
Null
49. The relational algebra command to select rows from a table
System Catalog
Integrity Constraint
SELECT
Union
50. The part of an SQL SELECT command that indicates a sort order
Form
Outer Join
Entity-Relationship (E-R) Diagram
ORDER BY Clause