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. The part of an SQL SELECT command that indicates the tables in the query
Unnormalized Relation
FROM Clause
Concatenation
Join Column
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
INSERT
Database
Functions
System Catalog
3. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Database Administrator (DBA)
One-to-Many Relationship
FROM Clause
Database
4. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
Redundancy
Intersection
Database Administrator (DBA)
5. The most common form of a join
Redundancy
Attribute
Secondary Sort Key
Natural Join
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
Delete Query
Concatenation
Repeating Groups
Repeating Groups
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
Simple Condition
Data Independence
Grouping
Aggregate Functions
8. The SQL command that drops (deletes) and index from a table
Entity
DROP INDEX
SELECT Clause
Relational Database
9. The field on which data are sorted
Sort Key
Intersection
Computed Field
Join
10. The relational algebra command to select rows from a table
One-to-Many Relationship
Database Administration (DBA)
Aggregate Functions
SELECT
11. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Trigger
Join Column
Qualify
SELECT Clause
12. 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
Database
One-to-Many Relationship
Secondary Sort Key
Cartesian Product
13. A characteristic or property of an entity
Relation
Attribute
Integrity
SUBTRACT
14. The form of a join in which all records appear - even if they don't match
Aggregate Functions
Outer Join
Command
Join
15. 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
Integrity Constraint
Relationship
Delimiter
16. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Qualify
INSERT
Entity-Relationship (E-R) Diagram
17. The prevention of unauthorized access to a database
SELECT Clause
Relational Database
Security
Repeating Groups
18. The relational algebra command to select rows from a table
SELECT
Row-and Column Subset View
Redundancy
Database
19. When sorting on two fields this is the more important field
Relational Algebra
Primary Sort Key
Integrity
Security
20. The form of a join in which all records appear - even if they don't match
Outer Join
INSERT
Query
PROJECT
21. In an Access query the line drawn between tables to indicate how they are related
Primary Sort Key
Cascade Update
Join Line
ORDER BY Clause
22. In relational algebra the operation in which two tables are connected on the basis of common data.
Database Administrator (DBA)
CREATE INDEX
Join
Entity-Relationship (E-R) Diagram
23. More than one entry at a single location in a table
Relation
REVOKE
Functions
Repeating Groups
24. The process of arranging rows in a table or results of a query in a particular order
Sort
SUBTRACT
Data Independence
Qualify
25. The most common form of a join
Null
Criteria
Natural Join
Server
26. The individual who is responsible for a database or the head of database administration
Attribute
Database Administrator (DBA)
Relation
Aggregate Functions
27. An association between entities
Primary Sort Key
Database Administrator (DBA)
Relationship
Design Grid
28. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Form
Query-By-Example (QBE)
Data Independence
Sort Key
29. A field whose value is computed from other fields in the database
Product
Criteria
Query-By-Example (QBE)
Computed Field
30. A person or place or object or event or idea for which you want to store and process data
Entity
Query-By-Example (QBE)
Form
Database Administration (DBA)
31. An instruction by a user that directs a database to perform a certain way
One-to-Many Relationship
Command
Database Management System (DBMS)
Database Design
32. When sorting on two fields - the less important field
Secondary Sort Key
Multiple-Field Index
Data File
Syscolumns
33. In Access the query that updates the contents of a table
Query
Attribute
Compound Criteria
Update Query
34. When comparing tables an intersection is a new table containing all rows that are in both original tables
Compound Criteria
Statement History
Join
Intersection
35. 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
Relationship
Column
Catalog
Relation
36. 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
FOREIGN KEY
Database Design
Relational Algebra
Delete Query
37. A field whose value is computed from other fields in the database
Computed Field
Entity
Relational Database
Calculated Field
38. A screen object you use to maintain or view and print data from a database
Delete Query
Primary Sort Key
Form
Relationship
39. A Characteristic or property of an entity
Reserved Words
Column
Systables
Criterion
40. A screen object you use to maintain or view and print data from a database
Criteria
Aggregate Functions
Form
PROJECT
41. 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
SELECT Clause
Single-Column Index
Aggregate Functions
WHERE Clause
42. An application program's or an individual user's picture of a database
Legal-Values Integrity
View
Column
Relational Database
43. 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
Qualify
Relational Database
Repeating Groups
Entity-Relationship (E-R) Diagram
44. Additional information required by an action in a data macro to complete the action
Criterion
GRANT
Cascade Update
Arguments
45. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Sort Key
Make-Table Query
AND Criterion
Database
46. In relational algebra the operation in which two tables are connected on the basis of common data.
Join
HAVING Clause
Database Administration (DBA)
Repeating Groups
47. The field or fields on which an index is built
Form
Index Key
Security
INTERSECT
48. A field whose value is computed from other fields in the database
Unnormalized Relation
Natural Join
Functions
Calculated Field
49. The portion of the system catalog the contains column information
Form
Join Column
Syscolumns
Major Sort Key
50. The SQL command that creates an index in a table
Data Independence
Server
Database
CREATE INDEX