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. An index built on a single field
Unnormalized Relation
Repeating Groups
Criteria
Single-Column Index
2. The SQL statement that is used to grant different types of privileges to users of a dataabase
GRANT
FROM Clause
HAVING Clause
Column
3. The most common form of a join
Database Management System (DBMS)
Integrity
Natural Join
Query-By-Example (QBE)
4. A program or a collection of programs through which users interact with a database
Major Sort Key
Entity-Relationship (E-R) Diagram
Validation Rule
Database Management System (DBMS)
5. A Characteristic or property of an entity
Integrity
ORDER BY Clause
Column
Comparison Operator
6. A rule that must be followed by data in a database
Integrity Constraint
Null
Database Administrator (DBA)
Form
7. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Design Grid
Union
Column
8. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Sort Key
Unnormalized Relation
Data Independence
Join Column
9. The column on which two tables are joined
Unnormalized Relation
Form
Join Column
Security
10. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Referential Integrity
Relationship
Major Sort Key
Unnormalized Relation
11. The process of creating collections of records that share some common characteristics
CREATE TABLE
Design Grid
Grouping
Relationship
12. A program or a collection of programs through which users interact with a database
Join Line
Division
Database Management System (DBMS)
Relation
13. The portion of the system catalog that contains view information
Join Line
INSERT
Sysviews
Comparison Operator
14. The SQL command used to make changes to existing table data
Join Line
UPDATE
Simple Condition
Data File
15. The form of a join in which all records appear - even if they don't match
Outer Join
DROP TABLE
Entity
Relational Database
16. A combination of two tables consisting of all records that are in either table
Compound Criteria
Form
Database
Union
17. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Catalog
Delimiter
Simple Condition
Primary Key
18. The portion of the system catalog that contains table information
Qualify
Unnormalized Relation
Systables
Subquery
19. A screen object you use to maintain or view and print data from a database
Defining Query
CREATE INDEX
Relational Database
Form
20. A program or a collection of programs through which users interact with a database
SELECT
Database Management System (DBMS)
Database Administration (DBA)
Sysviews
21. When sorting on two fields - the less important field
Natural Join
Intersection
Cascade Delete
Secondary Sort Key
22. A person or place or object or event or idea for which you want to store and process data
Computed Field
Query-By-Example (QBE)
Secondary Sort Key
Entity
23. The prevention of unauthorized access to a database
Sysindexes
Security
Database Design
Form
24. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Natural Join
Referential Integrity
One-to-Many Relationship
25. The individual who is responsible for a database or the head of database administration
DELETE
Database Administrator (DBA)
FOREIGN KEY
SQL (Structured Query Language)
26. A rule in Access that data entered in a field must satisfy
UPDATE
Legal-Values Integrity
Validation Rule
Data Macro
27. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Delimiter
Unnormalized Relation
Concatenation
Relational Database
28. A query that deletes all records that satisfy some criterion
Join
Delete Query
Minor Sort Key
Unnormalized Relation
29. An access query that creates a table using the results of a query
Make-Table Query
Repeating Groups
WHERE Clause
Systables
30. A combination of criteria in which at least on the criteria must be true
PRIMARY KEY
OR Criterion
Integrity Constraint
Server
31. A word that is part of the SQL language
Join Column
Compound Criteria
Reserved Words
OR Criterion
32. The rule that no column (attribute) that is part of the primary key may accept null values
CREATE INDEX
View
Database Administration (DBA)
Entity Integrity
33. The portion of the system catalog the contains column information
Data Independence
AND Criterion
Computed Field
Syscolumns
34. The relational algebra command used to select columns from a table
Natural Join
Redundancy
Compound Conditions
PROJECT
35. The table obtained by concatenating every row in the first table with every row in the second table
Single-Column Index
Product
HAVING Clause
Delete Query
36. Two simple criteria in a query the are combined with the AND or OR operators
AND Criterion
Update Query
Compound Conditions
View
37. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Database Design
Relational Database
Relational Algebra
Unnormalized Relation
38. When comparing tables the set of all rows that are in the first table but that are not in the second table
Difference
Make-Table Query
Cascade Delete
Intersection
39. The process of arranging rows in a table or results of a query in a particular order
Sort
GRANT
Query
Concatenation
40. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
Make-Table Query
REVOKE
Relationship
41. A characteristic or property of an entity
INSERT
Field
Data File
Entity
42. In relational algebra the operation in which two tables are connected on the basis of common data.
Join
Database
Data Independence
SELECT Clause
43. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Criterion
Major Sort Key
Null
Qualify
44. The SQL command used to delete a table
Outer Join
Qualify
Relation
DELETE
45. A rule that must be followed by data in a database
PROJECT
Unnormalized Relation
Integrity Constraint
Documenter
46. 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
Union Compatible
Comparison Operator
Functions
Sysviews
47. The SQL command that drops (deletes) a table from a database
DROP TABLE
Primary Key
Attribute
Null
48. 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
SELECT
Database Design
ALTER TABLE
Entity Integrity
49. An application program's or an individual user's picture of a database
Simple Condition
Database Administration (DBA)
View
Data File
50. 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
Criteria
Design Grid
Database Design