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 screen object you use to maintain or view and print data from a database
SQL (Structured Query Language)
Form
Natural Join
One-to-Many Relationship
2. The relational algebra command for performing the difference of two tables
Query-By-Example (QBE)
Delimiter
SUBTRACT
Delete Query
3. More than one entry at a single location in a table
Database
Repeating Groups
Integrity
Legal-Values Integrity
4. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
Query-By-Example (QBE)
FOREIGN KEY
Redundancy
Entity-Relationship (E-R) Diagram
5. The relational algebra command used to select columns from a table
Cascade Delete
Design Grid
PROJECT
Subquery
6. An access query that creates a table using the results of a query
Computed Field
Outer Join
Make-Table Query
One-to-Many Relationship
7. The part of an SQL SELECT command that restricts the groups to be displayed
Entity
Natural Join
HAVING Clause
System Catalog
8. The individual or group that is responsible for a database
Database Administration (DBA)
Data File
Reserved Words
Simple Condition
9. The SQL command used to add new data to a table
One-to-Many Relationship
INSERT
Database Administration (DBA)
Field
10. The part of an SQL SELECT command that indicates a sort order
Concatenation
Relationship
ORDER BY Clause
Aggregate Functions
11. A combination of two tables consisting of all records that are in either table
Union
Security
Make-Table Query
Defining Query
12. 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
Form
Make-Table Query
Entity-Relationship (E-R) Diagram
Server
13. The form of a join in which all records appear - even if they don't match
Integrity Constraint
Outer Join
Update Query
Computed Field
14. An index built on a single field
Relation
Single-Field Index
Entity-Relationship (E-R) Diagram
Unnormalized Relation
15. 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
FROM Clause
Relation
Unnormalized Relation
SELECT Clause
16. More than one entry at a single location in a table
Field
Cartesian Product
Primary Sort Key
Repeating Groups
17. A program or a collection of programs through which users interact with a database
PROJECT
Data Macro
Minor Sort Key
Database Management System (DBMS)
18. A rule that must be followed by data in a database
Database Design
Validation Text
Integrity Constraint
Primary Sort Key
19. 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.
Server
Primary Key
Relationship
CHECK
20. A characteristic or property of an entity
Unnormalized Relation
Redundancy
Join Column
Attribute
21. The individual or group that is responsible for a database
Database Administration (DBA)
Secondary Sort Key
Attribute
GRANT
22. 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
Entity-Relationship (E-R) Diagram
Attribute
REVOKE
23. 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
Database Design
Relation
Defining Query
SELECT Clause
24. A computer that provides services to the clients in a client/server system
Sysviews
Primary Sort Key
Server
FROM Clause
25. The process of creating collections of records that share some common characteristics
Multiple-Field Index
Compound Criteria
Grouping
Row-and Column Subset View
26. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
INTERSECT
Relation
Repeating Groups
27. Combination of criteria in which both criteria must be true
Database
AND Criterion
Trigger
Form
28. A characteristic or property of an entity
Relationship
Attribute
Aggregate Functions
SELECT
29. 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.
Relation
Attribute
Calculated Field
Primary Key
30. A database has integrity if the data in it satisfies all established integrity constraints
Primary Key
Subquery
Delimiter
Integrity
31. The relational algebra command to select rows from a table
One-to-Many Relationship
Make-Table Query
Qualify
SELECT
32. A Characteristic or property of an entity
INSERT
Foreign Key
Column
Documenter
33. An association between entities
Relationship
Sysindexes
One-to-Many Relationship
DROP TABLE
34. The query that is used to define the structure of a viewk
Defining Query
Validation Text
DROP INDEX
Redundancy
35. The SQL statement that is used to revoke privileges from users of a database
Database Administration (DBA)
Database Design
Criterion
REVOKE
36. The portion of the system catalog that contains table information
Column
Database Design
Systables
Attribute
37. A program or a collection of programs through which users interact with a database
Command
Database Management System (DBMS)
Database Design
Update Query
38. Combination of criteria in which both criteria must be true
Data Macro
Design Grid
Primary Key
AND Criterion
39. In relational algebra the operation in which two tables are connected on the basis of common data.
Join
Relationship
Relation
Primary Key
40. The most common form of a join
CHECK
Product
Security
Natural Join
41. 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
Data Independence
Foreign Key
Outer Join
42. A combination of criteria in which at least on the criteria must be true
OR Criterion
Validation Text
FOREIGN KEY
GROUP BY Clause
43. The rule that no column (attribute) that is part of the primary key may accept null values
ORDER BY Clause
DROP TABLE
Entity Integrity
Primary Sort Key
44. 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
Security
One-to-Many Relationship
Calculated Field
Systables
45. Two simple criteria in a query the are combined with the AND or OR operators
Design Grid
Attribute
Delete Query
Compound Conditions
46. A file that relates key values to records that contain those key values
Index
Difference
Integrity
Sysviews
47. The portion of the system catalog the contains column information
Integrity
Syscolumns
Database
PROJECT
48. An index built on more than one field
Multiple-Field Index
Union Compatible
Reserved Words
Column
49. The portion of the system catalog that contains view information
Sysviews
Reserved Words
Relationship
Computed Field
50. The column on which two tables are joined
Database Administrator (DBA)
Form
Join Column
Database Design