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. In relational algebra the operation in which two tables are connected on the basis of common data.
SUBTRACT
Unnormalized Relation
Qualify
Join
2. The SQL command that drops (deletes) and index from a table
DROP INDEX
Minor Sort Key
DELETE
Field
3. An index built on a single field
Single-Field Index
Relationship
Field
Query-By-Example (QBE)
4. A rule that must be followed by data in a database
Product
Data Macro
Integrity Constraint
Aggregate Functions
5. The relational algebra command to select rows from a table
Division
SELECT
Trigger
PROJECT
6. More than one entry at a single location in a table
INTERSECT
Database Administrator (DBA)
Foreign Key
Repeating Groups
7. When comparing tables an intersection is a new table containing all rows that are in both original tables
Qualify
Intersection
SQL (Structured Query Language)
Union
8. The part of an SQL SELECT command that indicates the columns to be included in the query results
Single-Column Index
SUBTRACT
SELECT Clause
Compound Conditions
9. The area of memory in MySQL that stores the most recently entered command
Statement History
Database
Join
Database Administration (DBA)
10. A file that relates key values to records that contain those key values
REVOKE
Difference
Relational Algebra
Index
11. The property that lets you change the structure of a database without requiring you to change the programs that access the database
CREATE TABLE
Form
GRANT
Data Independence
12. Duplication of data or the storing of the same data in more than one place.
SUBTRACT
Redundancy
Comparison Operator
DROP TABLE
13. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Database
Data Independence
Null
Integrity Constraint
14. The SQL command used to add new data to a table
Entity-Relationship (E-R) Diagram
INSERT
SQL (Structured Query Language)
Relation
15. 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
Aggregate Functions
Join Column
Entity-Relationship (E-R) Diagram
Entity Integrity
16. The field or fields on which an index is built
Simple Condition
Index Key
Natural Join
Criterion
17. More than one entry at a single location in a table
Documenter
Repeating Groups
Grouping
Concatenation
18. The relational algebra command to select rows from a table
AND Criterion
Criterion
SELECT
FROM Clause
19. 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
SQL (Structured Query Language)
Minor Sort Key
Entity Integrity
Concatenation
20. 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
Form
Attribute
Functions
CHECK
21. The part of an SQL SELECT command that indicates a sort order
Repeating Groups
Criteria
PROJECT
ORDER BY Clause
22. The plural of Criterion
Data File
Join Line
Criteria
Arguments
23. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
Field
Redundancy
Computed Field
24. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Major Sort Key
Cartesian Product
View
25. 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
Field
Functions
Entity-Relationship (E-R) Diagram
Row-and Column Subset View
26. A characteristic or property of an entity
Field
Design Grid
Make-Table Query
Server
27. 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.
Entity
PROJECT
Relational Database
Primary Key
28. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Minor Sort Key
Data Independence
Computed Field
Referential Integrity
29. A query that deletes all records that satisfy some criterion
Entity
Security
Null
Delete Query
30. An update option in which related records are automatically updated
Sysindexes
Documenter
Major Sort Key
Cascade Update
31. The portion of the system catalog that contains table information
Systables
Compound Criteria
Calculated Field
Computed Field
32. A Characteristic or property of an entity
Column
Update Query
Integrity
Comparison Operator
33. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Update Query
Relational Algebra
DELETE
Query
34. The SQL command that creates an index in a table
Integrity
DROP TABLE
CREATE INDEX
Query-By-Example (QBE)
35. A rule in Access that data entered in a field must satisfy
Database Administrator (DBA)
Validation Rule
UPDATE
Integrity
36. The relational algebra command for performing the difference of two tables
SUBTRACT
Database Management System (DBMS)
Query
Database
37. The individual or group that is responsible for a database
Computed Field
Database Administration (DBA)
Subquery
Attribute
38. Two simple criteria in a query the are combined with the AND or OR operators
Major Sort Key
Database Administrator (DBA)
Compound Criteria
Criterion
39. A message in Access that is displayed when a validation rule is violated
CREATE INDEX
Repeating Groups
Validation Text
Minor Sort Key
40. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Database
DROP TABLE
Database Management System (DBMS)
FOREIGN KEY
41. A field whose value is computed from other fields in the database
Computed Field
CHECK
Relational Algebra
Secondary Sort Key
42. The SQL clause that is used to enforce legal-values integrity
Integrity Constraint
Intersection
CHECK
Criterion
43. A data value meaning "unknown" or "not applicable"
Null
Relation
Row-and Column Subset View
Compound Conditions
44. A field whose value is computed from other fields in the database
Server
OR Criterion
HAVING Clause
Calculated Field
45. A rule that must be followed by data in a database
Integrity Constraint
DELETE
Secondary Sort Key
Database Design
46. When sorting on two fields - the less important field
Primary Key
Secondary Sort Key
Relational Algebra
AND Criterion
47. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database
Minor Sort Key
System Catalog
OR Criterion
Security
48. 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
Primary Sort Key
Repeating Groups
Foreign Key
Intersection
49. In an Access query the line drawn between tables to indicate how they are related
Join Line
Relational Algebra
Security
Natural Join
50. A database has integrity if the data in it satisfies all established integrity constraints
Query
Entity-Relationship (E-R) Diagram
Integrity
WHERE Clause