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. More than one entry at a single location in a table
Repeating Groups
Security
Security
Database Administrator (DBA)
2. 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
Form
Relationship
Natural Join
3. The individual or group that is responsible for a database
Sysindexes
GRANT
Data Independence
Database Administration (DBA)
4. 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)
Attribute
Relationship
Join Line
5. A person or place or object or event or idea for which you want to store and process data
Form
Entity
Join Line
Major Sort Key
6. 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
Relational Database
Repeating Groups
Single-Field Index
Concatenation
7. A question the answer to which is found in the database
Intersection
Primary Sort Key
Validation Text
Query
8. A collection of relations
Security
Computed Field
Relational Database
Delete Query
9. A Characteristic or property of an entity
INTERSECT
Repeating Groups
Intersection
Column
10. A file used to store data about a single entity. Such a file can be thought of as a table.
Security
Data File
Unnormalized Relation
Aggregate Functions
11. A query that deletes all records that satisfy some criterion
Validation Text
Database Administration (DBA)
Delete Query
Relation
12. The form of a join in which all records appear - even if they don't match
Outer Join
SELECT
Index
Entity-Relationship (E-R) Diagram
13. 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.
GROUP BY Clause
OR Criterion
Aggregate Functions
Primary Key
14. In Access the query that updates the contents of a table
Integrity Constraint
UPDATE
Validation Text
Update Query
15. The table obtained by concatenating every row in the first table with every row in the second table
Cartesian Product
Syscolumns
One-to-Many Relationship
CREATE INDEX
16. A combination of criteria in which at least on the criteria must be true
Entity-Relationship (E-R) Diagram
Redundancy
Security
OR Criterion
17. A file used to store data about a single entity. Such a file can be thought of as a table.
Referential Integrity
Data File
Secondary Sort Key
Unnormalized Relation
18. Two simple criteria in a query the are combined with the AND or OR operators
CHECK
Delete Query
Database
Compound Conditions
19. The SQL command that drops (deletes) a table from a database
AND Criterion
Join Column
DROP TABLE
SQL (Structured Query Language)
20. An access query that creates a table using the results of a query
CREATE TABLE
AND Criterion
Attribute
Make-Table Query
21. When sorting on two fields - the less important field
Query-By-Example (QBE)
Secondary Sort Key
Join
Data File
22. The SQL command used to make changes to existing table data
Calculated Field
Query
UPDATE
Delete Query
23. An index built on a single field
Criterion
PROJECT
Single-Field Index
Computed Field
24. The field on which data are sorted
Sort Key
Validation Rule
FROM Clause
Field
25. A word that is part of the SQL language
Reserved Words
AND Criterion
Secondary Sort Key
DELETE
26. A data value meaning "unknown" or "not applicable"
Qualify
Null
Statement History
One-to-Many Relationship
27. In relational algebra the operation in which two tables are connected on the basis of common data.
Join
Legal-Values Integrity
Union
Database Administrator (DBA)
28. 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
AND Criterion
Database Design
ORDER BY Clause
Calculated Field
29. Additional information required by an action in a data macro to complete the action
Database
Intersection
Syscolumns
Arguments
30. When sorting on two fields this is the more important field
Primary Sort Key
Form
Field
SQL (Structured Query Language)
31. A database has integrity if the data in it satisfies all established integrity constraints
Sort Key
Integrity
Relation
Relation
32. The relational algebra command to select rows from a table
CREATE TABLE
Data Independence
SELECT
PROJECT
33. An index built on more than one field
Database
Relation
Multiple Column Index
Data Independence
34. 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.
Relational Algebra
Primary Key
Cartesian Product
Join
35. When sorting on two fields this is the more important field
Major Sort Key
Computed Field
Difference
Criterion
36. A database has integrity if the data in it satisfies all established integrity constraints
Relation
Relationship
Integrity
Multiple Column Index
37. The field or fields on which an index is built
CREATE INDEX
Relational Algebra
Single-Column Index
Index Key
38. An update option in which related records are automatically updated
Division
Cascade Update
Join
System Catalog
39. The SQL command used to delete a table
Foreign Key
Minor Sort Key
GROUP BY Clause
DELETE
40. An application program's or an individual user's picture of a database
Major Sort Key
OR Criterion
View
Join
41. The rule that no column (attribute) that is part of the primary key may accept null values
ALTER TABLE
Entity Integrity
OR Criterion
Grouping
42. The prevention of unauthorized access to a database
Form
Cartesian Product
Security
Data Independence
43. A collection of relations
Intersection
CREATE INDEX
ORDER BY Clause
Relational Database
44. A characteristic or property of an entity
Relationship
Simple Condition
Attribute
Cascade Delete
45. Two simple criteria in a query the are combined with the AND or OR operators
Relational Database
Database Administrator (DBA)
Relationship
Compound Criteria
46. A very popular relational data definition and manipulation language that is used in many relational DBMS's
SQL (Structured Query Language)
Attribute
Outer Join
Form
47. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Data Independence
System Catalog
Primary Key
Sort
48. 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
Entity-Relationship (E-R) Diagram
Join Column
PRIMARY KEY
Aggregate Functions
49. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
Data Independence
WHERE Clause
Relation
Query
50. The part of an SQL SELECT command that indicates a sort order
Aggregate Functions
Redundancy
Primary Key
ORDER BY Clause