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 structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Data Macro
Criterion
Database
CREATE INDEX
2. A Characteristic or property of an entity
Index
Column
Computed Field
Entity
3. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Column
AND Criterion
Database
Delimiter
4. An index built on a single field
Integrity
SELECT
Single-Field Index
Multiple-Field Index
5. A characteristic or property of an entity
Database
Field
Column
Update Query
6. The portion of the system catalog the contains column information
WHERE Clause
Syscolumns
Primary Key
Qualify
7. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Join
One-to-Many Relationship
Natural Join
8. A combination of criteria in which at least on the criteria must be true
Integrity Constraint
Security
OR Criterion
Computed Field
9. More than one entry at a single location in a table
Cascade Delete
Repeating Groups
Integrity
Reserved Words
10. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Database Administration (DBA)
Primary Key
Unnormalized Relation
Intersection
11. The SQL command used to delete a table
DELETE
System Catalog
Sort
SELECT
12. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
Index Key
FOREIGN KEY
Delete Query
Primary Key
13. The portion of the system catalog that contains view information
Sysviews
Foreign Key
Simple Condition
Computed Field
14. A person or place or object or event or idea for which you want to store and process data
Data Macro
INSERT
Concatenation
Entity
15. 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
Database
Integrity
Criteria
16. The form of a join in which all records appear - even if they don't match
UPDATE
Outer Join
Delete Query
Security
17. The SQL command used to describe the layout of a table. The word table is followed by the name of the table to be created and then by the names and data types of the column (fields) that comprise the table
Minor Sort Key
Compound Criteria
Grouping
CREATE TABLE
18. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
FROM Clause
One-to-Many Relationship
Data Independence
Query-By-Example (QBE)
19. More than one entry at a single location in a table
Database Management System (DBMS)
Repeating Groups
Index Key
Data File
20. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Data Independence
Database Administrator (DBA)
Unnormalized Relation
Database Design
21. A rule that must be followed by data in a database
Column
Division
Computed Field
Integrity Constraint
22. A combination of criteria in which at least on the criteria must be true
PRIMARY KEY
GRANT
OR Criterion
Sort Key
23. 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
Data Independence
Natural Join
Qualify
24. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
Computed Field
Division
Data File
Entity-Relationship (E-R) Diagram
25. Additional information required by an action in a data macro to complete the action
Arguments
Server
Relationship
Relational Algebra
26. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
Trigger
Catalog
Outer Join
27. 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
Join Column
Query-By-Example (QBE)
Criteria
28. A collection of relations
Division
Relational Database
Secondary Sort Key
Single-Field Index
29. The individual who is responsible for a database or the head of database administration
Relation
Database Administrator (DBA)
Entity Integrity
PROJECT
30. A delete option in which related records are automatically deleted
Primary Key
Criterion
INTERSECT
Cascade Delete
31. 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
DELETE
Sort
Database
Entity-Relationship (E-R) Diagram
32. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Security
Grouping
Catalog
Query
33. The table obtained by concatenating every row in the first table with every row in the second table
Database Administration (DBA)
UPDATE
Database Administration (DBA)
Product
34. A condition that involves only a single field and a single value
Database Management System (DBMS)
Simple Condition
Integrity Constraint
Secondary Sort Key
35. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Relation
Qualify
Defining Query
Database Design
36. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
Form
Database Administration (DBA)
Database Design
37. Duplication of data or the storing of the same data in more than one place.
HAVING Clause
Entity-Relationship (E-R) Diagram
Comparison Operator
Redundancy
38. A statement the can be either true or false. Also called a condition
OR Criterion
Systables
Criterion
Update Query
39. An index built on more than one field
Multiple Column Index
Update Query
Intersection
Command
40. The part of an SQL SELECT command that indicates a sort order
Criteria
ORDER BY Clause
Security
Null
41. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Relationship
Criteria
One-to-Many Relationship
42. When sorting on two fields - the less important field
GRANT
SELECT
SQL (Structured Query Language)
Secondary Sort Key
43. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Make-Table Query
View
Qualify
Sort
44. The prevention of unauthorized access to a database
Compound Criteria
HAVING Clause
Security
Primary Key
45. A query that deletes all records that satisfy some criterion
Database
Compound Criteria
Delete Query
Sysindexes
46. The SQL command that drops (deletes) and index from a table
Delete Query
Qualify
DROP INDEX
Database Design
47. The plural of Criterion
One-to-Many Relationship
CHECK
Minor Sort Key
Criteria
48. The rule that no column (attribute) that is part of the primary key may accept null values
Criterion
Command
Primary Sort Key
Entity Integrity
49. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
Repeating Groups
PRIMARY KEY
Sort
DELETE
50. A screen object you use to maintain or view and print data from a database
HAVING Clause
Form
Reserved Words
Relation