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 person or place or object or event or idea for which you want to store and process data
SELECT
Attribute
Entity
Database Administrator (DBA)
2. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Join
Database
SELECT Clause
Entity
3. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Relational Algebra
CHECK
Multiple-Field Index
Design Grid
4. The part of an SQL SELECT command that indicates the tables in the query
DROP TABLE
Field
FROM Clause
Compound Criteria
5. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Relational Algebra
Cascade Delete
Compound Conditions
Intersection
6. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Integrity Constraint
Relational Algebra
Major Sort Key
Single-Field Index
7. A screen object you use to maintain or view and print data from a database
Form
Delete Query
Union
FOREIGN KEY
8. 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 Design
Redundancy
Unnormalized Relation
One-to-Many Relationship
9. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Grouping
Catalog
Integrity Constraint
Criterion
10. The prevention of unauthorized access to a database
Security
Data Independence
Referential Integrity
Minor Sort Key
11. 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
Entity-Relationship (E-R) Diagram
Primary Sort Key
Compound Criteria
Relationship
12. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Trigger
Query-By-Example (QBE)
Syscolumns
SELECT Clause
13. A characteristic or property of an entity
Functions
REVOKE
Server
Field
14. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Make-Table Query
Null
Integrity Constraint
Design Grid
15. A computer that provides services to the clients in a client/server system
Server
Calculated Field
CHECK
Database Administration (DBA)
16. 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.
Calculated Field
Primary Key
Repeating Groups
ALTER TABLE
17. The SQL command that drops (deletes) and index from a table
Single-Column Index
Criteria
Relational Database
DROP INDEX
18. 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
Query
Calculated Field
Attribute
Foreign Key
19. The relational algebra command for performing the intersection of two tables
INTERSECT
Foreign Key
CREATE TABLE
Index
20. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Calculated Field
Data Independence
WHERE Clause
Unnormalized Relation
21. The relational algebra command for performing the difference of two tables
Data File
SUBTRACT
Primary Sort Key
Major Sort Key
22. An instruction by a user that directs a database to perform a certain way
Update Query
Outer Join
Command
UPDATE
23. A person or place or object or event or idea for which you want to store and process data
Calculated Field
REVOKE
Compound Conditions
Entity
24. An association between entities
Functions
Qualify
Relationship
Entity
25. A combination of criteria in which at least on the criteria must be true
Query
Column
OR Criterion
Primary Sort Key
26. When sorting on two fields - the less important field
Compound Conditions
Systables
Unnormalized Relation
Secondary Sort Key
27. The portion of the system catalog that contains table information
Criteria
Defining Query
Delete Query
Systables
28. A query that deletes all records that satisfy some criterion
Delete Query
PROJECT
Relational Algebra
Union Compatible
29. Two simple criteria in a query the are combined with the AND or OR operators
Union
Compound Criteria
AND Criterion
Join Line
30. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Relation
Database Administrator (DBA)
WHERE Clause
31. A query that deletes all records that satisfy some criterion
Relational Database
Data File
Delete Query
Difference
32. The relational algebra command to select rows from a table
Documenter
Form
SELECT
Repeating Groups
33. The field on which data are sorted
SELECT Clause
Security
Sort Key
AND Criterion
34. In Access the query that updates the contents of a table
Security
Outer Join
Database Administrator (DBA)
Update Query
35. An index built on a single field
Data File
Foreign Key
Single-Column Index
Unnormalized Relation
36. The process of creating collections of records that share some common characteristics
SELECT Clause
OR Criterion
Single-Column Index
Grouping
37. The rule that if table A contains a foreign key that matches the primary key of table B then the value of this foreign key must either match the value of the primary key for some row in table B or be null
Design Grid
Relational Database
Aggregate Functions
Referential Integrity
38. The prevention of unauthorized access to a database
Primary Key
Referential Integrity
SELECT
Security
39. A program or a collection of programs through which users interact with a database
Intersection
Data File
Design Grid
Database Management System (DBMS)
40. When sorting on two fields this is the more important field
Relation
Primary Sort Key
Computed Field
Legal-Values Integrity
41. A word that is part of the SQL language
Reserved Words
Form
Natural Join
Compound Criteria
42. What type of an operator is >= ?
Join Column
Single-Column Index
Comparison Operator
OR Criterion
43. A field whose value is computed from other fields in the database
Relational Algebra
Computed Field
Outer Join
Relationship
44. An association between entities
Join Column
Concatenation
Compound Criteria
Relationship
45. In relational algebra the operation in which two tables are connected on the basis of common data.
Calculated Field
ORDER BY Clause
Relation
Join
46. A rule in Access that data entered in a field must satisfy
Validation Rule
Computed Field
Arguments
Major Sort Key
47. Two simple criteria in a query the are combined with the AND or OR operators
Aggregate Functions
Entity
Update Query
Compound Conditions
48. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Relationship
Unnormalized Relation
Sort
Product
49. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Database
Server
PRIMARY KEY
50. The table obtained by concatenating every row in the first table with every row in the second table
Delimiter
Functions
Primary Sort Key
Product