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 source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Redundancy
Catalog
Column
GROUP BY Clause
2. A word that is part of the SQL language
FOREIGN KEY
Reserved Words
Command
Relation
3. 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
Documenter
Catalog
PRIMARY KEY
Database Design
4. A person or place or object or event or idea for which you want to store and process data
Calculated Field
Entity
Database Design
SELECT
5. The process of arranging rows in a table or results of a query in a particular order
HAVING Clause
Sort
Join Line
Data Independence
6. The rule that no column (attribute) that is part of the primary key may accept null values
CREATE INDEX
Query
Integrity
Entity Integrity
7. The property that no record can exist in the database with a value in a field other than a legal value
Difference
Compound Conditions
Legal-Values Integrity
Data Macro
8. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Qualify
Statement History
Legal-Values Integrity
Union Compatible
9. A Characteristic or property of an entity
Delimiter
Database Design
Column
Update Query
10. 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
WHERE Clause
Relation
Division
Entity-Relationship (E-R) Diagram
11. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Relational Algebra
Functions
SQL (Structured Query Language)
Unnormalized Relation
12. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
View
Join Line
Qualify
Unnormalized Relation
13. An index built on more than one field
Comparison Operator
Database Management System (DBMS)
Redundancy
Multiple Column Index
14. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Computed Field
Unnormalized Relation
Intersection
Secondary Sort Key
15. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database
Data Independence
Database
System Catalog
Syscolumns
16. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
Division
Database Management System (DBMS)
FOREIGN KEY
17. A question the answer to which is found in the database
Integrity Constraint
Data File
Field
Query
18. The table obtained by concatenating every row in the first table with every row in the second table
Product
Functions
Query
Server
19. When sorting on two fields this is the more important field
Data File
Database
Secondary Sort Key
Major Sort Key
20. A field whose value is computed from other fields in the database
Defining Query
Relational Database
SELECT
Calculated Field
21. The process of creating collections of records that share some common characteristics
Grouping
Primary Sort Key
Primary Key
Integrity
22. A field whose value is computed from other fields in the database
PROJECT
Simple Condition
Difference
Computed Field
23. When sorting on two fields this is the more important field
Unnormalized Relation
Primary Sort Key
View
Repeating Groups
24. An access query that creates a table using the results of a query
One-to-Many Relationship
Make-Table Query
Integrity
Sort Key
25. The portion of the system catalog that contains index information
Documenter
Query
Redundancy
Sysindexes
26. 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
Functions
Foreign Key
OR Criterion
Comparison Operator
27. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Union Compatible
Entity Integrity
Qualify
Relational Algebra
28. The portion of the system catalog the contains column information
Syscolumns
Delete Query
Database
Integrity Constraint
29. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
OR Criterion
Entity
Join
30. The individual or group that is responsible for a database
Delete Query
Intersection
Data Macro
Database Administration (DBA)
31. The SQL command used to delete a table
Aggregate Functions
Row-and Column Subset View
Defining Query
DELETE
32. A characteristic or property of an entity
Attribute
AND Criterion
Design Grid
Cascade Update
33. 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
Concatenation
Join Column
Cartesian Product
34. A field whose value is computed from other fields in the database
Query
Single-Field Index
Natural Join
Computed Field
35. The relational algebra command for performing the intersection of two tables
Cascade Delete
INTERSECT
Repeating Groups
Multiple Column Index
36. A question the answer to which is found in the database
OR Criterion
Query
Functions
Union Compatible
37. An index built on more than one field
ORDER BY Clause
Simple Condition
Foreign Key
Multiple-Field Index
38. The relational algebra command used to select columns from a table
Comparison Operator
Sort
PROJECT
Primary Sort Key
39. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
Database Administration (DBA)
Form
Functions
40. The portion of the system catalog that contains view information
FOREIGN KEY
Relation
Sysviews
Field
41. The process of creating collections of records that share some common characteristics
Database Management System (DBMS)
Grouping
OR Criterion
Entity-Relationship (E-R) Diagram
42. Combination of criteria in which both criteria must be true
Security
Single-Field Index
Primary Sort Key
AND Criterion
43. 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
Field
Foreign Key
Arguments
Aggregate Functions
44. 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
Concatenation
Database Administration (DBA)
Attribute
Integrity
45. A Characteristic or property of an entity
Column
Integrity Constraint
Repeating Groups
Primary Sort Key
46. A collection of relations
Database
CREATE TABLE
Relational Database
Integrity
47. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
Relational Algebra
Unnormalized Relation
Form
48. The part of an SQL SELECT command that indicates grouping
Integrity
GROUP BY Clause
Simple Condition
Major Sort Key
49. A statement the can be either true or false. Also called a condition
Criterion
SQL (Structured Query Language)
Entity-Relationship (E-R) Diagram
PROJECT
50. The relational algebra command to select rows from a table
Relation
Reserved Words
SELECT
Compound Conditions