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 criteria in which at least on the criteria must be true
Field
Query-By-Example (QBE)
OR Criterion
Criterion
2. The form of a join in which all records appear - even if they don't match
Outer Join
Database
Primary Key
Primary Sort Key
3. Duplication of data or the storing of the same data in more than one place.
Redundancy
Database Administration (DBA)
Computed Field
Database
4. The SQL command used to delete a table
Trigger
DELETE
Entity
Primary Sort Key
5. A person or place or object or event or idea for which you want to store and process data
Security
Security
Entity
UPDATE
6. The part of an SQL SELECT command that indicates the columns to be included in the query results
Make-Table Query
Repeating Groups
Index
SELECT Clause
7. 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
Repeating Groups
Entity-Relationship (E-R) Diagram
Command
Aggregate Functions
8. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Query-By-Example (QBE)
Cascade Delete
Sysviews
Concatenation
9. The individual or group that is responsible for a database
One-to-Many Relationship
Unnormalized Relation
Sort
Database Administration (DBA)
10. The process of arranging rows in a table or results of a query in a particular order
Sort
Entity
Database Administration (DBA)
Data File
11. A statement the can be either true or false. Also called a condition
Criterion
Integrity Constraint
Sysindexes
Security
12. In an Access query the line drawn between tables to indicate how they are related
Relationship
Join Line
Update Query
Functions
13. A characteristic or property of an entity
PRIMARY KEY
Attribute
UPDATE
INSERT
14. A database has integrity if the data in it satisfies all established integrity constraints
SUBTRACT
Column
Integrity
Catalog
15. When comparing tables an intersection is a new table containing all rows that are in both original tables
Data File
Compound Conditions
Data File
Intersection
16. The part of an SQL SELECT command that restricts the groups to be displayed
Relational Algebra
HAVING Clause
Entity
Data Independence
17. What type of an operator is >= ?
OR Criterion
Unnormalized Relation
Comparison Operator
Grouping
18. 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
Primary Key
Query
Concatenation
Join
19. 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 Administration (DBA)
Database Design
GROUP BY Clause
ALTER TABLE
20. The prevention of unauthorized access to a database
Product
Security
INTERSECT
Referential Integrity
21. A punctuation mark - such as a semicolon - that separates pieces of data
Data File
Delimiter
Relational Database
Join Column
22. In an Access query the line drawn between tables to indicate how they are related
Join Line
Concatenation
AND Criterion
Query
23. A combination of criteria in which at least on the criteria must be true
OR Criterion
INSERT
Query
Null
24. A rule in Access that data entered in a field must satisfy
Relational Database
Form
Validation Rule
Foreign Key
25. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Database Design
HAVING Clause
Unnormalized Relation
Query-By-Example (QBE)
26. An access query that creates a table using the results of a query
Product
Redundancy
REVOKE
Make-Table Query
27. A question the answer to which is found in the database
Compound Conditions
GRANT
Database
Query
28. A characteristic or property of an entity
ORDER BY Clause
Field
Referential Integrity
Unnormalized Relation
29. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
Criteria
Entity
WHERE Clause
Aggregate Functions
30. Two simple criteria in a query the are combined with the AND or OR operators
Design Grid
Design Grid
Legal-Values Integrity
Compound Criteria
31. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Relational Algebra
Join Line
Data Independence
Entity
32. 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
Integrity Constraint
Database Design
Database
Query
33. The portion of the system catalog the contains column information
Database
Syscolumns
Relationship
Security
34. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Integrity
Join Column
View
35. A rule that must be followed by data in a database
Concatenation
Trigger
Integrity Constraint
Comparison Operator
36. In relational algebra the operation in which two tables are connected on the basis of common data.
DROP TABLE
Join
Sort Key
Database Administrator (DBA)
37. A characteristic or property of an entity
Attribute
Entity-Relationship (E-R) Diagram
Simple Condition
Form
38. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Sort Key
Outer Join
Design Grid
Entity-Relationship (E-R) Diagram
39. A combination of two tables consisting of all records that are in either table
Delete Query
Repeating Groups
Data Macro
Union
40. 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
Update Query
Relational Database
Relationship
41. The SQL command that is used to change the structure of a table
ALTER TABLE
Join
Primary Key
Stored Procedure
42. The SQL clause that is used to enforce legal-values integrity
CHECK
CREATE INDEX
Row-and Column Subset View
Union
43. An access query that creates a table using the results of a query
Make-Table Query
GROUP BY Clause
Database Administration (DBA)
Column
44. The field or fields on which an index is built
Index Key
Outer Join
Relation
Arguments
45. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Form
Entity-Relationship (E-R) Diagram
Database
Index
46. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Computed Field
Sysindexes
Database
Field
47. 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
Relation
Attribute
Difference
Index Key
48. The portion of the system catalog that contains view information
Sysviews
OR Criterion
PRIMARY KEY
Syscolumns
49. When sorting on two fields - the less important field
Minor Sort Key
DROP INDEX
FOREIGN KEY
Primary Key
50. The part of an SQL SELECT command that indicates the tables in the query
Secondary Sort Key
Security
FROM Clause
Computed Field