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 property that lets you change the structure of a database without requiring you to change the programs that access the database
Sort Key
Row-and Column Subset View
Database Administration (DBA)
Data Independence
2. An index built on a single field
Major Sort Key
DROP TABLE
Form
Single-Field Index
3. The SQL command that creates an index in a table
HAVING Clause
CREATE INDEX
Data Independence
Integrity
4. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Security
Sysviews
Qualify
Cascade Update
5. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Functions
SELECT
Entity-Relationship (E-R) Diagram
Unnormalized Relation
6. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Simple Condition
Functions
Design Grid
Database Administration (DBA)
7. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Design Grid
Qualify
Data File
PROJECT
8. The relational algebra command for performing the intersection of two tables
Foreign Key
Entity
INTERSECT
CHECK
9. The table obtained by concatenating every row in the first table with every row in the second table
Product
Index Key
Relational Algebra
Data File
10. An index built on more than one field
Security
Criterion
Multiple Column Index
Entity-Relationship (E-R) Diagram
11. The relational algebra command to select rows from a table
ORDER BY Clause
SELECT
Computed Field
Relational Algebra
12. A screen object you use to maintain or view and print data from a database
Form
Database Management System (DBMS)
Secondary Sort Key
GRANT
13. A message in Access that is displayed when a validation rule is violated
Cascade Delete
Concatenation
Validation Text
Column
14. In Access the query that updates the contents of a table
Row-and Column Subset View
Systables
Simple Condition
Update Query
15. The individual or group that is responsible for a database
Database Administration (DBA)
Simple Condition
Integrity Constraint
Arguments
16. A view that consists of a subset of the rows and columns in a table
Qualify
Row-and Column Subset View
One-to-Many Relationship
WHERE Clause
17. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Qualify
ALTER TABLE
Field
Data Independence
18. 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
Documenter
Update Query
Entity-Relationship (E-R) Diagram
Cascade Update
19. 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
Database
Arguments
Entity-Relationship (E-R) Diagram
Data File
20. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
Security
Join Line
Form
21. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.
Data Macro
Integrity Constraint
Field
INSERT
22. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Sort
Major Sort Key
Unnormalized Relation
GRANT
23. A screen object you use to maintain or view and print data from a database
Intersection
Form
Entity-Relationship (E-R) Diagram
OR Criterion
24. 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
Data Independence
PRIMARY KEY
CREATE TABLE
Division
25. A characteristic or property of an entity
ALTER TABLE
Field
Referential Integrity
Union Compatible
26. An association between entities
Trigger
Relationship
Database Administration (DBA)
Query
27. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
Design Grid
UPDATE
Validation Text
PRIMARY KEY
28. A punctuation mark - such as a semicolon - that separates pieces of data
Command
Functions
Delimiter
CREATE INDEX
29. A computer that provides services to the clients in a client/server system
Server
Division
Union
Query-By-Example (QBE)
30. The property that no record can exist in the database with a value in a field other than a legal value
Referential Integrity
Sort Key
Legal-Values Integrity
Criteria
31. A Characteristic or property of an entity
Sysindexes
Column
Database Management System (DBMS)
Primary Key
32. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
GROUP BY Clause
Join Line
Repeating Groups
33. A file used to store data about a single entity. Such a file can be thought of as a table.
Query
Data File
Reserved Words
AND Criterion
34. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Database Administrator (DBA)
UPDATE
GRANT
Query-By-Example (QBE)
35. 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.
Relationship
Primary Key
Relational Algebra
Delimiter
36. When sorting on two fields - the less important field
Join
Calculated Field
Query-By-Example (QBE)
Secondary Sort Key
37. 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
Design Grid
Functions
Form
SUBTRACT
38. A collection of relations
Data File
One-to-Many Relationship
Relational Database
Criterion
39. Two simple criteria in a query the are combined with the AND or OR operators
Concatenation
Compound Criteria
Relational Algebra
One-to-Many Relationship
40. A file used to store data about a single entity. Such a file can be thought of as a table.
Single-Column Index
Functions
AND Criterion
Data File
41. 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
Index Key
Intersection
Relation
Criteria
42. The relational algebra command used to select columns from a table
Documenter
Database Administration (DBA)
Division
PROJECT
43. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
PRIMARY KEY
Primary Key
Relational Algebra
PROJECT
44. The field or fields on which an index is built
Comparison Operator
Update Query
Security
Index Key
45. A field whose value is computed from other fields in the database
Calculated Field
Primary Sort Key
Aggregate Functions
Functions
46. The SQL command used to make changes to existing table data
Entity-Relationship (E-R) Diagram
Cartesian Product
Null
UPDATE
47. An instruction by a user that directs a database to perform a certain way
Statement History
Unnormalized Relation
Command
Database Administrator (DBA)
48. A screen object you use to maintain or view and print data from a database
SELECT Clause
Primary Sort Key
Criteria
Form
49. 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)
Attribute
Validation Rule
Aggregate Functions
50. A person or place or object or event or idea for which you want to store and process data
Entity
Cascade Update
SELECT Clause
Index Key