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 field whose value is computed from other fields in the database
Calculated Field
PROJECT
Database Management System (DBMS)
Update Query
2. A screen object you use to maintain or view and print data from a database
Form
SELECT
CREATE INDEX
Primary Key
3. The relational algebra command to select rows from a table
Redundancy
SELECT
Integrity Constraint
Criteria
4. The part of an SQL SELECT command that indicates the tables in the query
Sysviews
Computed Field
FROM Clause
Primary Key
5. 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
CREATE TABLE
Redundancy
SELECT
Update Query
6. A characteristic or property of an entity
Relational Algebra
Secondary Sort Key
Server
Attribute
7. The SQL command that drops (deletes) and index from a table
DROP INDEX
Entity-Relationship (E-R) Diagram
INTERSECT
Catalog
8. A characteristic or property of an entity
Database Design
Sort
Primary Key
Attribute
9. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Query-By-Example (QBE)
Relational Algebra
Union
UPDATE
10. In Access the query that updates the contents of a table
Update Query
Relational Database
SELECT Clause
Concatenation
11. An index built on a single field
Single-Field Index
UPDATE
REVOKE
Relational Algebra
12. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Integrity Constraint
REVOKE
Join Line
13. The process of arranging rows in a table or results of a query in a particular order
Cascade Update
Database Administrator (DBA)
Sort
Sort Key
14. A statement the can be either true or false. Also called a condition
Database Administration (DBA)
OR Criterion
Database Design
Criterion
15. A person or place or object or event or idea for which you want to store and process data
Difference
UPDATE
Integrity Constraint
Entity
16. Duplication of data or the storing of the same data in more than one place.
Redundancy
Criterion
Multiple-Field Index
PRIMARY KEY
17. Two simple criteria in a query the are combined with the AND or OR operators
Data Independence
Simple Condition
DROP INDEX
Compound Criteria
18. A punctuation mark - such as a semicolon - that separates pieces of data
Column
Database
Delimiter
Data Independence
19. The individual or group that is responsible for a database
Security
Column
Secondary Sort Key
Database Administration (DBA)
20. A characteristic or property of an entity
Attribute
Unnormalized Relation
Index
Criterion
21. A combination of two tables consisting of all records that are in either table
Repeating Groups
Union
SELECT
Systables
22. A characteristic or property of an entity
Difference
Field
Relational Database
Data Independence
23. 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.
Join
Qualify
Primary Key
Difference
24. The relational algebra command used to select columns from a table
PROJECT
Join Line
Relation
Server
25. 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
Functions
Join
Relation
DELETE
26. 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
Integrity Constraint
Foreign Key
Unnormalized Relation
Grouping
27. Duplication of data or the storing of the same data in more than one place.
One-to-Many Relationship
Redundancy
Relationship
Trigger
28. A collection of relations
Validation Text
Relational Database
Subquery
PROJECT
29. 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
Sort Key
Referential Integrity
Outer Join
30. 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
Minor Sort Key
One-to-Many Relationship
Compound Criteria
Criteria
31. 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
Primary Key
SELECT
Division
Functions
32. 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
Field
DELETE
Database Design
Major Sort Key
33. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Functions
Natural Join
INSERT
34. The relational algebra command for performing the intersection of two tables
Arguments
INTERSECT
Defining Query
Data File
35. A word that is part of the SQL language
Field
Database Design
Reserved Words
Grouping
36. 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
UPDATE
Join Line
Database Design
CREATE TABLE
37. The column on which two tables are joined
One-to-Many Relationship
One-to-Many Relationship
Join Column
Relation
38. A database has integrity if the data in it satisfies all established integrity constraints
PROJECT
View
Integrity
Database Management System (DBMS)
39. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Query-By-Example (QBE)
Database Administration (DBA)
Join Column
SUBTRACT
40. A delete option in which related records are automatically deleted
Integrity Constraint
Relational Database
Cascade Delete
Legal-Values Integrity
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
Relation
Entity-Relationship (E-R) Diagram
Sysindexes
Intersection
42. An association between entities
CREATE TABLE
Null
Relationship
Natural Join
43. Duplication of data or the storing of the same data in more than one place.
Redundancy
Database Management System (DBMS)
Concatenation
Attribute
44. A characteristic or property of an entity
Field
DROP INDEX
Database Management System (DBMS)
Repeating Groups
45. In relational algebra the operation in which two tables are connected on the basis of common data.
Relationship
Arguments
Join
Referential Integrity
46. An index built on more than one field
REVOKE
Sort
HAVING Clause
Multiple Column Index
47. The part of an SQL SELECT command that restricts the groups to be displayed
One-to-Many Relationship
HAVING Clause
Database Administrator (DBA)
Field
48. The prevention of unauthorized access to a database
Data Independence
Join
Security
Criteria
49. When sorting on two fields this is the more important field
Data Macro
SELECT
Row-and Column Subset View
Primary Sort Key
50. A Characteristic or property of an entity
Foreign Key
Column
ALTER TABLE
Sort