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. An access query that creates a table using the results of a query
Integrity
Trigger
Calculated Field
Make-Table Query
2. An instruction by a user that directs a database to perform a certain way
Secondary Sort Key
INSERT
Command
Database Design
3. A rule in Access that data entered in a field must satisfy
Security
Concatenation
Validation Rule
Qualify
4. In relational algebra the operation in which two tables are connected on the basis of common data.
Trigger
Join
Union
Computed Field
5. The process of creating collections of records that share some common characteristics
Grouping
One-to-Many Relationship
Update Query
Attribute
6. 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
Primary Key
Database Design
DELETE
Single-Field Index
7. When sorting on two fields - the less important field
Relational Database
Entity-Relationship (E-R) Diagram
Outer Join
Secondary Sort Key
8. The column on which two tables are joined
Intersection
Join Column
Compound Conditions
AND Criterion
9. A computer that provides services to the clients in a client/server system
AND Criterion
Criteria
Server
Data Macro
10. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
Database Administrator (DBA)
System Catalog
Security
11. Combination of criteria in which both criteria must be true
Database Administrator (DBA)
AND Criterion
Attribute
FOREIGN KEY
12. A question the answer to which is found in the database
Column
Query
Qualify
Redundancy
13. A combination of criteria in which at least on the criteria must be true
Join Column
OR Criterion
Join Column
Column
14. 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
Stored Procedure
Relational Algebra
Catalog
Relation
15. Combination of criteria in which both criteria must be true
AND Criterion
Data File
Criteria
Integrity
16. Additional information required by an action in a data macro to complete the action
Integrity
Outer Join
Arguments
SUBTRACT
17. The prevention of unauthorized access to a database
Concatenation
Qualify
Security
Computed Field
18. A combination of two tables consisting of all records that are in either table
Make-Table Query
Column
CREATE INDEX
Union
19. A rule that must be followed by data in a database
FROM Clause
Integrity Constraint
OR Criterion
Criteria
20. A characteristic or property of an entity
Database Administrator (DBA)
Arguments
Attribute
Sysviews
21. A statement the can be either true or false. Also called a condition
Grouping
Criterion
OR Criterion
Systables
22. When sorting on two fields - the less important field
OR Criterion
Minor Sort Key
Repeating Groups
One-to-Many Relationship
23. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
One-to-Many Relationship
Validation Rule
Major Sort Key
24. A Characteristic or property of an entity
Relation
Column
Security
Integrity Constraint
25. A file used to store data about a single entity. Such a file can be thought of as a table.
Repeating Groups
Unnormalized Relation
Data File
Intersection
26. A Characteristic or property of an entity
One-to-Many Relationship
Field
Column
Query
27. 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
Systables
Single-Field Index
Aggregate Functions
Referential Integrity
28. The plural of Criterion
Unnormalized Relation
Minor Sort Key
PROJECT
Criteria
29. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
Index
Compound Criteria
Division
DROP INDEX
30. An application program's or an individual user's picture of a database
System Catalog
Qualify
Sort
View
31. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
PROJECT
Sort
Query-By-Example (QBE)
OR Criterion
32. The SQL command used to add new data to a table
Entity Integrity
Delete Query
Major Sort Key
INSERT
33. A field whose value is computed from other fields in the database
Outer Join
One-to-Many Relationship
Computed Field
Compound Criteria
34. A file used to store data about a single entity. Such a file can be thought of as a table.
Concatenation
Repeating Groups
Data File
Calculated Field
35. A combination of two tables consisting of all records that are in either table
Join Column
Union
Design Grid
Row-and Column Subset View
36. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Unnormalized Relation
GRANT
Compound Criteria
37. 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
Cartesian Product
Entity Integrity
One-to-Many Relationship
Entity-Relationship (E-R) Diagram
38. When comparing tables an intersection is a new table containing all rows that are in both original tables
SELECT Clause
Attribute
GRANT
Intersection
39. In an Access query the line drawn between tables to indicate how they are related
Single-Column Index
Secondary Sort Key
Data File
Join Line
40. 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
Entity-Relationship (E-R) Diagram
Database Design
PROJECT
Single-Field Index
41. The query that is used to define the structure of a viewk
CREATE INDEX
Catalog
Integrity
Defining Query
42. The relational algebra command to select rows from a table
Integrity Constraint
SELECT
Index Key
Database Administrator (DBA)
43. The individual or group that is responsible for a database
Sort
Primary Key
Intersection
Database Administration (DBA)
44. A person or place or object or event or idea for which you want to store and process data
Entity
Compound Criteria
Cascade Delete
Form
45. The part of an SQL SELECT command that restricts the groups to be displayed
Sort
Outer Join
HAVING Clause
Query-By-Example (QBE)
46. An index built on more than one field
Multiple-Field Index
Union
Stored Procedure
Compound Criteria
47. The individual who is responsible for a database or the head of database administration
CREATE TABLE
Database Administrator (DBA)
Sort
Data File
48. 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
GROUP BY Clause
Entity
CREATE TABLE
Grouping
49. A query that deletes all records that satisfy some criterion
Delete Query
Integrity Constraint
FROM Clause
Security
50. The field or fields on which an index is built
Database Administrator (DBA)
Index Key
Integrity
Foreign Key