SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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 part of an SQL SELECT command that indicates the tables in the query
Outer Join
FROM Clause
Qualify
Database
2. A file containing a collection of compiled and optimized SQL statements that are available for future use
Data Independence
Security
Update Query
Stored Procedure
3. Combination of criteria in which both criteria must be true
Grouping
Data Independence
AND Criterion
Sysviews
4. The field or fields on which an index is built
Index Key
Subquery
Integrity
Join
5. 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
Entity
Simple Condition
Relation
DROP TABLE
6. When sorting on two fields this is the more important field
Join Column
Subquery
Single-Field Index
Primary Sort Key
7. 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.
Aggregate Functions
Systables
OR Criterion
Primary Key
8. The SQL command that drops (deletes) and index from a table
Primary Sort Key
Database Administration (DBA)
DROP INDEX
Single-Field Index
9. A statement the can be either true or false. Also called a condition
Secondary Sort Key
Criterion
Form
Column
10. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Database Administrator (DBA)
View
Unnormalized Relation
Natural Join
11. A query in SQL that appears within another
Data Independence
Major Sort Key
Subquery
Union
12. The part of an SQL SELECT command that indicates a sort order
ORDER BY Clause
Validation Text
One-to-Many Relationship
Entity
13. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Grouping
Redundancy
INTERSECT
14. 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.
CREATE TABLE
Union
Criterion
Primary Key
15. The form of a join in which all records appear - even if they don't match
CHECK
Concatenation
Outer Join
Secondary Sort Key
16. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Unnormalized Relation
Database
Column
Qualify
17. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Simple Condition
Join
Database Administration (DBA)
18. The individual or group that is responsible for a database
Defining Query
Division
Database Administration (DBA)
Compound Criteria
19. A collection of relations
Systables
PRIMARY KEY
Multiple-Field Index
Relational Database
20. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Repeating Groups
AND Criterion
DROP TABLE
Database
21. 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
Statement History
Concatenation
ORDER BY Clause
One-to-Many Relationship
22. The part of an SQL SELECT command that indicates grouping
Query-By-Example (QBE)
Unnormalized Relation
GROUP BY Clause
Database Administration (DBA)
23. Duplication of data or the storing of the same data in more than one place.
Redundancy
Relation
Data File
Criterion
24. When sorting on two fields - the less important field
Systables
Secondary Sort Key
Data Macro
Primary Sort Key
25. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Simple Condition
Aggregate Functions
SQL (Structured Query Language)
Integrity Constraint
26. The property that no record can exist in the database with a value in a field other than a legal value
Integrity Constraint
Database
Join Line
Legal-Values Integrity
27. A database has integrity if the data in it satisfies all established integrity constraints
AND Criterion
DELETE
Integrity
Arguments
28. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Trigger
Syscolumns
Design Grid
Primary Sort Key
29. What type of an operator is >= ?
Redundancy
Single-Field Index
Compound Conditions
Comparison Operator
30. 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.
Primary Key
Command
CHECK
Stored Procedure
31. A Characteristic or property of an entity
Delimiter
AND Criterion
Column
AND Criterion
32. The query that is used to define the structure of a viewk
Relationship
Attribute
Defining Query
AND Criterion
33. In an Access query the line drawn between tables to indicate how they are related
Join
Validation Text
Make-Table Query
Join Line
34. A view that consists of a subset of the rows and columns in a table
Row-and Column Subset View
Relational Algebra
Index Key
Intersection
35. The individual who is responsible for a database or the head of database administration
PRIMARY KEY
Criterion
Database Administrator (DBA)
Natural Join
36. When sorting on two fields - the less important field
Criteria
Minor Sort Key
Concatenation
UPDATE
37. The table obtained by concatenating every row in the first table with every row in the second table
OR Criterion
One-to-Many Relationship
Product
Union Compatible
38. A screen object you use to maintain or view and print data from a database
Division
Aggregate Functions
Database Administration (DBA)
Form
39. An instruction by a user that directs a database to perform a certain way
Calculated Field
Join
Command
Outer Join
40. When sorting on two fields - the less important field
Attribute
Compound Conditions
Minor Sort Key
Index
41. A rule that must be followed by data in a database
Union
Integrity Constraint
Relationship
Aggregate Functions
42. 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
SELECT
Intersection
Difference
43. A combination of criteria in which at least on the criteria must be true
Database Design
Row-and Column Subset View
Repeating Groups
OR Criterion
44. A field whose value is computed from other fields in the database
Form
Computed Field
Entity-Relationship (E-R) Diagram
Join Line
45. A screen object you use to maintain or view and print data from a database
Form
Attribute
Intersection
Compound Conditions
46. The process of arranging rows in a table or results of a query in a particular order
Sort
Entity-Relationship (E-R) Diagram
Attribute
Single-Field Index
47. 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
Relational Database
Aggregate Functions
Stored Procedure
Integrity
48. In an Access query the line drawn between tables to indicate how they are related
Join Line
Minor Sort Key
Functions
Data Macro
49. In Access the query that updates the contents of a table
Update Query
Functions
Entity
Redundancy
50. Two simple criteria in a query the are combined with the AND or OR operators
Product
Compound Criteria
Repeating Groups
CREATE TABLE