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 combination of two tables consisting of all records that are in either table
Union
Systables
Cascade Update
Column
2. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Field
ORDER BY Clause
Data Independence
Statement History
3. An index built on a single field
Secondary Sort Key
Single-Column Index
Entity
SELECT
4. The SQL command used to add new data to a table
One-to-Many Relationship
Division
INSERT
Delimiter
5. The part of an SQL SELECT command that indicates a sort order
Null
Concatenation
ORDER BY Clause
Join
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
Database Management System (DBMS)
Qualify
Aggregate Functions
Database Design
7. What type of an operator is >= ?
DELETE
Database
Row-and Column Subset View
Comparison Operator
8. 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.
Database Administrator (DBA)
Primary Key
AND Criterion
Attribute
9. The SQL command that drops (deletes) and index from a table
Multiple Column Index
DROP INDEX
Cascade Update
Integrity
10. The property that no record can exist in the database with a value in a field other than a legal value
Union
Relational Algebra
Legal-Values Integrity
Referential Integrity
11. When comparing tables the set of all rows that are in the first table but that are not in the second table
Delete Query
Design Grid
Outer Join
Difference
12. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Outer Join
Integrity
Union Compatible
Primary Key
13. The most common form of a join
Delete Query
Database Administration (DBA)
Compound Conditions
Natural Join
14. The process of creating collections of records that share some common characteristics
Design Grid
Grouping
Database
One-to-Many Relationship
15. A file that relates key values to records that contain those key values
Qualify
Entity Integrity
Index
Arguments
16. A screen object you use to maintain or view and print data from a database
Computed Field
Database Management System (DBMS)
Form
Column
17. The SQL command that is used to change the structure of a table
INTERSECT
Calculated Field
Query
ALTER TABLE
18. A collection of relations
Computed Field
Relational Database
PRIMARY KEY
Validation Text
19. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
WHERE Clause
Integrity
System Catalog
FOREIGN KEY
20. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Entity-Relationship (E-R) Diagram
Query-By-Example (QBE)
Calculated Field
System Catalog
21. An update option in which related records are automatically updated
Relation
Relationship
Update Query
Cascade Update
22. A program or a collection of programs through which users interact with a database
Stored Procedure
Database Management System (DBMS)
CHECK
Union
23. 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
Update Query
Attribute
SQL (Structured Query Language)
One-to-Many Relationship
24. In Access the query that updates the contents of a table
Redundancy
Update Query
Simple Condition
Division
25. An index built on a single field
Single-Field Index
Functions
Database Administration (DBA)
Relational Algebra
26. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Design Grid
Join Column
Catalog
SELECT Clause
27. An access tool that provides documentation about the objects in a database
Documenter
Attribute
Relationship
Functions
28. When sorting on two fields - the less important field
Minor Sort Key
Sysindexes
Major Sort Key
Database Design
29. A program or a collection of programs through which users interact with a database
Catalog
Field
Database Management System (DBMS)
Security
30. A rule that must be followed by data in a database
UPDATE
Concatenation
Database Design
Integrity Constraint
31. The relational algebra command for performing the intersection of two tables
Calculated Field
View
SELECT
INTERSECT
32. A field whose value is computed from other fields in the database
Delimiter
Database Design
Computed Field
Database Management System (DBMS)
33. The field on which data are sorted
Data Independence
Sort Key
Minor Sort Key
Primary Sort Key
34. 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 Key
Cartesian Product
One-to-Many Relationship
35. When comparing tables an intersection is a new table containing all rows that are in both original tables
Integrity
Make-Table Query
Compound Conditions
Intersection
36. A characteristic or property of an entity
Field
Compound Conditions
Entity Integrity
Unnormalized Relation
37. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Reserved Words
FROM Clause
Relation
Query-By-Example (QBE)
38. The relational algebra command used to select columns from a table
Documenter
Entity
PROJECT
Computed Field
39. 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
ORDER BY Clause
Data File
Calculated Field
40. An association between entities
Referential Integrity
Relationship
Security
Aggregate Functions
41. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.
Entity-Relationship (E-R) Diagram
Integrity Constraint
Arguments
Data Macro
42. 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
AND Criterion
Relation
Grouping
Sysviews
43. A rule that must be followed by data in a database
Integrity Constraint
Join Line
Database
Grouping
44. A question the answer to which is found in the database
Simple Condition
Natural Join
Database Design
Query
45. More than one entry at a single location in a table
DELETE
Null
Single-Column Index
Repeating Groups
46. The portion of the system catalog that contains table information
Sort Key
Primary Key
Systables
Join
47. When sorting on two fields this is the more important field
Join Column
Computed Field
Major Sort Key
Grouping
48. 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
Aggregate Functions
AND Criterion
Database Administration (DBA)
49. The prevention of unauthorized access to a database
Security
Join Column
Cascade Update
FROM Clause
50. The SQL command used to delete a table
DELETE
Entity-Relationship (E-R) Diagram
Criteria
AND Criterion