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. The form of a join in which all records appear - even if they don't match
Update Query
Database Management System (DBMS)
System Catalog
Outer Join
2. The relational algebra command to select rows from a table
Relation
SELECT
Secondary Sort Key
Catalog
3. A collection of relations
Database Administrator (DBA)
Relational Database
Computed Field
Attribute
4. The portion of the system catalog that contains index information
Syscolumns
Sysindexes
Repeating Groups
Compound Conditions
5. The column on which two tables are joined
Primary Key
Entity-Relationship (E-R) Diagram
Sort Key
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.
Make-Table Query
Primary Key
Stored Procedure
Database Administrator (DBA)
7. A field whose value is computed from other fields in the database
Row-and Column Subset View
INTERSECT
Query
Calculated Field
8. A characteristic or property of an entity
Arguments
Attribute
Product
Database Management System (DBMS)
9. A Characteristic or property of an entity
Secondary Sort Key
Aggregate Functions
Calculated Field
Column
10. 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
SELECT Clause
Foreign Key
Grouping
Field
11. The process of arranging rows in a table or results of a query in a particular order
Database Design
Sort
Database Design
Simple Condition
12. A Characteristic or property of an entity
Column
Field
Documenter
Primary Key
13. An index built on more than one field
Relation
Multiple Column Index
Server
Entity-Relationship (E-R) Diagram
14. When sorting on two fields - the less important field
Secondary Sort Key
Comparison Operator
Product
Null
15. Duplication of data or the storing of the same data in more than one place.
Redundancy
Concatenation
Integrity Constraint
Relationship
16. What type of an operator is >= ?
Column
Union Compatible
Minor Sort Key
Comparison Operator
17. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Data File
Design Grid
Criteria
OR Criterion
18. A statement the can be either true or false. Also called a condition
Functions
Join Column
Criterion
Database Administrator (DBA)
19. A program or a collection of programs through which users interact with a database
Form
Query
Database Management System (DBMS)
Systables
20. A program or a collection of programs through which users interact with a database
Join Line
SQL (Structured Query Language)
Database Management System (DBMS)
Secondary Sort Key
21. In an Access query the line drawn between tables to indicate how they are related
Join Line
PRIMARY KEY
Reserved Words
Concatenation
22. The SQL command used to add new data to a table
Computed Field
Trigger
INSERT
Column
23. A Characteristic or property of an entity
Arguments
Column
Redundancy
Cascade Delete
24. The prevention of unauthorized access to a database
Database Administrator (DBA)
Reserved Words
Security
REVOKE
25. The rule that if table A contains a foreign key that matches the primary key of table B then the value of this foreign key must either match the value of the primary key for some row in table B or be null
Command
Form
Referential Integrity
Validation Text
26. The SQL statement that is used to revoke privileges from users of a database
Join
REVOKE
Null
Union
27. A database has integrity if the data in it satisfies all established integrity constraints
INTERSECT
Data Independence
Integrity
Natural Join
28. The individual or group that is responsible for a database
Secondary Sort Key
Repeating Groups
Database Administration (DBA)
Concatenation
29. The relational algebra command used to select columns from a table
Qualify
Security
Functions
PROJECT
30. 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
Sysviews
Entity
Integrity
Database Design
31. A field whose value is computed from other fields in the database
Sysviews
Database Management System (DBMS)
CHECK
Computed Field
32. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Grouping
Data Independence
Entity
Criterion
33. An association between entities
Relationship
Integrity
Stored Procedure
PRIMARY KEY
34. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
Data Independence
Relation
Trigger
Syscolumns
35. 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
Relational Database
SELECT Clause
Entity-Relationship (E-R) Diagram
Entity
36. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Grouping
Catalog
Make-Table Query
Query
37. A person or place or object or event or idea for which you want to store and process data
Entity
Arguments
Unnormalized Relation
Minor Sort Key
38. When sorting on two fields this is the more important field
Grouping
Delimiter
Major Sort Key
Defining Query
39. The portion of the system catalog the contains column information
Syscolumns
Single-Column Index
Database Management System (DBMS)
Criterion
40. The form of a join in which all records appear - even if they don't match
PROJECT
Calculated Field
Outer Join
Integrity
41. A query in SQL that appears within another
Relational Database
Subquery
Union
Relational Algebra
42. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
FROM Clause
Sort
Integrity
43. The area of memory in MySQL that stores the most recently entered command
Statement History
Repeating Groups
Compound Conditions
Catalog
44. The SQL command that drops (deletes) a table from a database
Unnormalized Relation
Product
DROP TABLE
One-to-Many Relationship
45. A combination of two tables consisting of all records that are in either table
Column
Redundancy
Database Management System (DBMS)
Union
46. A file used to store data about a single entity. Such a file can be thought of as a table.
Union Compatible
REVOKE
Data File
PROJECT
47. A word that is part of the SQL language
Relational Database
Relational Database
ALTER TABLE
Reserved Words
48. The SQL command that drops (deletes) and index from a table
Single-Column Index
DROP INDEX
AND Criterion
Sysviews
49. A rule that must be followed by data in a database
Compound Criteria
REVOKE
Relational Database
Integrity Constraint
50. Two simple criteria in a query the are combined with the AND or OR operators
Documenter
Compound Criteria
Compound Conditions
Relationship