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 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
Unnormalized Relation
Field
Calculated Field
Relation
2. When sorting on two fields - the less important field
Secondary Sort Key
Single-Field Index
INTERSECT
Functions
3. A computer that provides services to the clients in a client/server system
PRIMARY KEY
Server
Database Management System (DBMS)
DROP TABLE
4. A Characteristic or property of an entity
Minor Sort Key
Column
Sort Key
Form
5. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Join Line
Null
Relational Database
6. Duplication of data or the storing of the same data in more than one place.
Cascade Update
Qualify
Attribute
Redundancy
7. The part of an SQL SELECT command that indicates the tables in the query
Multiple Column Index
Delete Query
Data Independence
FROM Clause
8. A Characteristic or property of an entity
Column
Single-Field Index
Relation
Database Administrator (DBA)
9. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
Join
Join Column
DELETE
Trigger
10. A rule that must be followed by data in a database
Grouping
Integrity Constraint
Database Design
Relationship
11. A delete option in which related records are automatically deleted
System Catalog
Catalog
Minor Sort Key
Cascade Delete
12. A query in SQL that appears within another
Catalog
One-to-Many Relationship
Trigger
Subquery
13. A program or a collection of programs through which users interact with a database
Referential Integrity
Outer Join
Database Management System (DBMS)
Data Independence
14. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Null
Data File
DROP INDEX
Relational Algebra
15. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Database
Cascade Update
Primary Key
Data Independence
16. The relational algebra command for performing the intersection of two tables
INTERSECT
Attribute
Relational Database
PRIMARY KEY
17. The portion of the system catalog the contains column information
Syscolumns
Query
Intersection
Unnormalized Relation
18. The field or fields on which an index is built
Delimiter
Index Key
Relation
ORDER BY Clause
19. The SQL command that drops (deletes) and index from a table
DROP INDEX
Database Administration (DBA)
Query
Design Grid
20. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity
Sort
Relational Algebra
Difference
FOREIGN KEY
21. A characteristic or property of an entity
Field
Primary Key
Outer Join
Row-and Column Subset View
22. 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
SUBTRACT
Integrity
Functions
Relational Database
23. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Integrity
Entity
Database
24. 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
Difference
Foreign Key
Cartesian Product
Query
25. When sorting on two fields this is the more important field
Primary Sort Key
Data File
Join Line
Database Management System (DBMS)
26. The plural of Criterion
Criteria
Relationship
ALTER TABLE
CHECK
27. In an Access query the line drawn between tables to indicate how they are related
OR Criterion
Join Line
Relation
Database
28. A person or place or object or event or idea for which you want to store and process data
Trigger
Relation
Entity
Union
29. A question the answer to which is found in the database
Query
Sort Key
Database
Database Administration (DBA)
30. More than one entry at a single location in a table
SELECT
CREATE INDEX
Comparison Operator
Repeating Groups
31. 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
Entity
Delete Query
Referential Integrity
Concatenation
32. The prevention of unauthorized access to a database
Computed Field
Systables
Form
Security
33. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Sort Key
Query
Database Administrator (DBA)
Query-By-Example (QBE)
34. A field whose value is computed from other fields in the database
Redundancy
Qualify
Computed Field
Concatenation
35. 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
Database Administration (DBA)
Join Column
Minor Sort Key
Functions
36. A Characteristic or property of an entity
Relational Algebra
PROJECT
Column
Delimiter
37. A characteristic or property of an entity
Relational Database
Union
WHERE Clause
Attribute
38. A data value meaning "unknown" or "not applicable"
System Catalog
Subquery
Null
Unnormalized Relation
39. A statement the can be either true or false. Also called a condition
HAVING Clause
Criterion
Database Administrator (DBA)
Criteria
40. A field whose value is computed from other fields in the database
ORDER BY Clause
Database Administration (DBA)
Calculated Field
Command
41. The SQL command used to add new data to a table
Redundancy
Data Independence
Single-Column Index
INSERT
42. Additional information required by an action in a data macro to complete the action
Arguments
Command
Column
CHECK
43. An index built on more than one field
Multiple Column Index
Integrity Constraint
Attribute
Integrity Constraint
44. The prevention of unauthorized access to a database
Compound Conditions
Security
Data Independence
Relational Algebra
45. An application program's or an individual user's picture of a database
REVOKE
Database Management System (DBMS)
View
Functions
46. A word that is part of the SQL language
Outer Join
Criterion
Relational Database
Reserved Words
47. The process of arranging rows in a table or results of a query in a particular order
Sort Key
Sort
Referential Integrity
Relational Algebra
48. 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.
Trigger
Comparison Operator
Primary Key
Delete Query
49. The form of a join in which all records appear - even if they don't match
Data Independence
Outer Join
Redundancy
Data File
50. An index built on a single field
Sysindexes
Secondary Sort Key
Relational Database
Single-Column Index