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 data value meaning "unknown" or "not applicable"
SELECT
Row-and Column Subset View
Functions
Null
2. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Query-By-Example (QBE)
Database Design
Database Management System (DBMS)
3. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
SELECT
Criteria
Design Grid
Trigger
4. The area of memory in MySQL that stores the most recently entered command
Query
Minor Sort Key
Statement History
Index
5. The process of creating collections of records that share some common characteristics
Criterion
Sysindexes
UPDATE
Grouping
6. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Integrity
HAVING Clause
Qualify
Union Compatible
7. An association between entities
Difference
CREATE TABLE
Relation
Relationship
8. A file used to store data about a single entity. Such a file can be thought of as a table.
Qualify
Data File
Comparison Operator
Sysviews
9. The SQL command used to make changes to existing table data
UPDATE
SQL (Structured Query Language)
Union
Relation
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
Referential Integrity
Primary Key
Entity-Relationship (E-R) Diagram
Relational Algebra
11. The part of an SQL SELECT command that restricts the groups to be displayed
HAVING Clause
Minor Sort Key
Update Query
Command
12. The prevention of unauthorized access to a database
Entity
Redundancy
Calculated Field
Security
13. 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
PROJECT
DROP TABLE
Database Design
Cascade Delete
14. The rule that no column (attribute) that is part of the primary key may accept null values
Entity-Relationship (E-R) Diagram
Relational Database
Make-Table Query
Entity Integrity
15. The part of an SQL SELECT command that indicates grouping
CREATE INDEX
Query-By-Example (QBE)
GROUP BY Clause
Single-Column Index
16. A file containing a collection of compiled and optimized SQL statements that are available for future use
Stored Procedure
Update Query
Documenter
Product
17. The SQL command used to add new data to a table
Qualify
Compound Conditions
Row-and Column Subset View
INSERT
18. When sorting on two fields - the less important field
Trigger
Delimiter
Secondary Sort Key
CREATE INDEX
19. The SQL clause that is used to enforce legal-values integrity
Concatenation
ALTER TABLE
Row-and Column Subset View
CHECK
20. The column on which two tables are joined
Catalog
Join Column
Database
Delete Query
21. The relational algebra command for performing the difference of two tables
Relational Algebra
Repeating Groups
Unnormalized Relation
SUBTRACT
22. The individual who is responsible for a database or the head of database administration
Primary Sort Key
Data File
Database Administrator (DBA)
Make-Table Query
23. A characteristic or property of an entity
Field
Syscolumns
REVOKE
Concatenation
24. A characteristic or property of an entity
Field
Relational Algebra
Comparison Operator
Functions
25. A database has integrity if the data in it satisfies all established integrity constraints
Make-Table Query
Integrity
Computed Field
Database Administration (DBA)
26. 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
SUBTRACT
REVOKE
One-to-Many Relationship
Design Grid
27. A Characteristic or property of an entity
Compound Conditions
Column
HAVING Clause
Functions
28. A delete option in which related records are automatically deleted
Compound Criteria
Primary Sort Key
Cascade Delete
Repeating Groups
29. An access tool that provides documentation about the objects in a database
Attribute
Documenter
Comparison Operator
Minor Sort Key
30. 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.
PROJECT
Database
Primary Key
SELECT Clause
31. The relational algebra command to select rows from a table
Grouping
Relational Algebra
SELECT
Entity Integrity
32. A program or a collection of programs through which users interact with a database
Entity-Relationship (E-R) Diagram
Difference
SELECT
Database Management System (DBMS)
33. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Natural Join
Query-By-Example (QBE)
Database Administrator (DBA)
Sysviews
34. The process of arranging rows in a table or results of a query in a particular order
Sort
Query
One-to-Many Relationship
Sysindexes
35. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Intersection
Intersection
Qualify
Product
36. The field on which data are sorted
OR Criterion
Sort Key
Primary Key
Minor Sort Key
37. 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
Query-By-Example (QBE)
Relation
Secondary Sort Key
Entity-Relationship (E-R) Diagram
38. The most common form of a join
Natural Join
Sort Key
Design Grid
Database Administration (DBA)
39. The SQL command used to delete a table
Qualify
Entity-Relationship (E-R) Diagram
Unnormalized Relation
DELETE
40. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Unnormalized Relation
Design Grid
Grouping
Form
41. 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
System Catalog
Union
Concatenation
Unnormalized Relation
42. In relational algebra the operation in which two tables are connected on the basis of common data.
Join
Comparison Operator
Primary Key
Minor Sort Key
43. The SQL statement that is used to revoke privileges from users of a database
Update Query
Form
Secondary Sort Key
REVOKE
44. The table obtained by concatenating every row in the first table with every row in the second table
Primary Sort Key
Entity
Cartesian Product
Form
45. 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
Concatenation
Minor Sort Key
CREATE TABLE
Relationship
46. When sorting on two fields this is the more important field
Primary Sort Key
Validation Text
Major Sort Key
Query-By-Example (QBE)
47. A file used to store data about a single entity. Such a file can be thought of as a table.
Join Column
Entity Integrity
Data File
Make-Table Query
48. The relational algebra command for performing the intersection of two tables
Relationship
Syscolumns
INTERSECT
SELECT
49. A condition that involves only a single field and a single value
Data Independence
ALTER TABLE
Simple Condition
Relation
50. An index built on more than one field
Multiple Column Index
INTERSECT
Null
GROUP BY Clause