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 query in SQL that appears within another
Update Query
Natural Join
Subquery
Multiple Column Index
2. When comparing tables an intersection is a new table containing all rows that are in both original tables
Catalog
Unnormalized Relation
DELETE
Intersection
3. The portion of the system catalog that contains view information
Functions
System Catalog
Sysviews
Database
4. 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
Single-Column Index
Repeating Groups
Data Independence
Relation
5. In Access the query that updates the contents of a table
Database Administration (DBA)
Cartesian Product
Update Query
Join Column
6. 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
Entity-Relationship (E-R) Diagram
Make-Table Query
Sort Key
7. An association between entities
INTERSECT
Documenter
Relationship
Query
8. When sorting on two fields - the less important field
Secondary Sort Key
Database Design
Sort Key
Database Management System (DBMS)
9. A file containing a collection of compiled and optimized SQL statements that are available for future use
Database
Relationship
Major Sort Key
Stored Procedure
10. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Multiple-Field Index
Data File
Database
DROP INDEX
11. The part of an SQL SELECT command that indicates the columns to be included in the query results
SELECT Clause
DELETE
Primary Key
FROM Clause
12. A collection of relations
DROP TABLE
Unnormalized Relation
Data Macro
Relational Database
13. Combination of criteria in which both criteria must be true
Foreign Key
AND Criterion
Integrity Constraint
Database Administrator (DBA)
14. The query that is used to define the structure of a viewk
Major Sort Key
System Catalog
INTERSECT
Defining Query
15. A rule that must be followed by data in a database
Union Compatible
Foreign Key
Criterion
Integrity Constraint
16. The process of arranging rows in a table or results of a query in a particular order
Sort
CREATE TABLE
Database Design
AND Criterion
17. A file used to store data about a single entity. Such a file can be thought of as a table.
Single-Field Index
Security
Relational Algebra
Data File
18. 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
DROP TABLE
Integrity Constraint
System Catalog
19. 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
Column
Relation
Union
Stored Procedure
20. An access query that creates a table using the results of a query
SELECT
Make-Table Query
OR Criterion
Redundancy
21. A characteristic or property of an entity
Multiple-Field Index
Data Independence
Grouping
Attribute
22. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Primary Key
Cascade Delete
Computed Field
Unnormalized Relation
23. 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
Sort Key
Aggregate Functions
SELECT
24. In relational algebra the operation in which two tables are connected on the basis of common data.
Join Column
Data Macro
Relational Algebra
Join
25. The relational algebra command used to select columns from a table
SQL (Structured Query Language)
PROJECT
Database Management System (DBMS)
Query-By-Example (QBE)
26. A characteristic or property of an entity
Qualify
Outer Join
Attribute
Repeating Groups
27. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null
Relational Database
AND Criterion
Foreign Key
Relational Algebra
28. A Characteristic or property of an entity
Union
Column
Join Column
Qualify
29. The individual or group that is responsible for a database
Database Administration (DBA)
Sysviews
OR Criterion
AND Criterion
30. A collection of relations
SELECT Clause
FOREIGN KEY
Relational Database
AND Criterion
31. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Aggregate Functions
Database Management System (DBMS)
Join
32. A word that is part of the SQL language
Reserved Words
SELECT
Relation
Database Administrator (DBA)
33. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
Division
WHERE Clause
Entity-Relationship (E-R) Diagram
Functions
34. When sorting on two fields - the less important field
Integrity
Database Management System (DBMS)
Minor Sort Key
Grouping
35. When sorting on two fields this is the more important field
SELECT
Compound Criteria
Major Sort Key
Concatenation
36. 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
PROJECT
Qualify
System Catalog
37. A combination of two tables consisting of all records that are in either table
Criterion
Concatenation
Union
Data File
38. A person or place or object or event or idea for which you want to store and process data
Entity
Referential Integrity
Validation Text
Computed Field
39. 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
Integrity
Minor Sort Key
Redundancy
One-to-Many Relationship
40. A screen object you use to maintain or view and print data from a database
Union Compatible
Entity
SQL (Structured Query Language)
Form
41. 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 Design
HAVING Clause
Integrity Constraint
Criteria
42. The SQL command that drops (deletes) and index from a table
AND Criterion
Comparison Operator
Join Column
DROP INDEX
43. A field whose value is computed from other fields in the database
Security
Repeating Groups
Single-Column Index
Computed Field
44. The SQL command that creates an index in a table
Sort
Integrity
CREATE INDEX
Criteria
45. A field whose value is computed from other fields in the database
Entity-Relationship (E-R) Diagram
Data Independence
Computed Field
Criterion
46. 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
Entity-Relationship (E-R) Diagram
Cartesian Product
PROJECT
Database Design
47. A field whose value is computed from other fields in the database
Database Design
Entity-Relationship (E-R) Diagram
Referential Integrity
Calculated Field
48. The individual or group that is responsible for a database
SELECT
Database Administration (DBA)
PROJECT
Concatenation
49. An index built on more than one field
Multiple Column Index
Make-Table Query
Simple Condition
Database Administration (DBA)
50. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Comparison Operator
One-to-Many Relationship
Union Compatible
Reserved Words