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. In Access the query that updates the contents of a table
Comparison Operator
Update Query
Multiple Column Index
Attribute
2. A condition that involves only a single field and a single value
Row-and Column Subset View
Simple Condition
INSERT
Sort
3. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Union Compatible
Entity Integrity
Primary Sort Key
Concatenation
4. A field whose value is computed from other fields in the database
Stored Procedure
Secondary Sort Key
UPDATE
Calculated Field
5. When comparing tables an intersection is a new table containing all rows that are in both original tables
Field
Intersection
Join Line
Grouping
6. The portion of the system catalog the contains column information
Form
Secondary Sort Key
Join Line
Syscolumns
7. 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
CREATE TABLE
Arguments
Functions
8. 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.
Primary Key
Update Query
DROP TABLE
One-to-Many Relationship
9. A statement the can be either true or false. Also called a condition
Criterion
Arguments
Major Sort Key
Functions
10. An access query that creates a table using the results of a query
Outer Join
Make-Table Query
Outer Join
Form
11. A file containing a collection of compiled and optimized SQL statements that are available for future use
Qualify
Column
Stored Procedure
Database Design
12. 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
Concatenation
Entity-Relationship (E-R) Diagram
Null
Attribute
13. 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
Database Design
Grouping
Data File
Database Administrator (DBA)
14. A rule that must be followed by data in a database
Integrity Constraint
Statement History
GRANT
Secondary Sort Key
15. When sorting on two fields this is the more important field
Repeating Groups
Functions
Database Administrator (DBA)
Major Sort Key
16. A Characteristic or property of an entity
Relational Database
Database Design
Column
Entity-Relationship (E-R) Diagram
17. A collection of relations
Secondary Sort Key
Relational Database
Query
Reserved Words
18. In an Access query the line drawn between tables to indicate how they are related
Join Line
Query
Join Column
Cartesian Product
19. A Characteristic or property of an entity
Query
Join Line
Compound Criteria
Column
20. A characteristic or property of an entity
Join Line
Form
Field
Cartesian Product
21. More than one entry at a single location in a table
Index Key
Delete Query
Repeating Groups
ORDER BY Clause
22. The field or fields on which an index is built
Index Key
INTERSECT
Data File
Multiple-Field Index
23. 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
Natural Join
Major Sort Key
Query
24. A field whose value is computed from other fields in the database
Column
Computed Field
GROUP BY Clause
Redundancy
25. A very popular relational data definition and manipulation language that is used in many relational DBMS's
FOREIGN KEY
SQL (Structured Query Language)
Primary Sort Key
Database Administration (DBA)
26. An association between entities
Field
INSERT
Integrity Constraint
Relationship
27. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Server
Data Independence
Stored Procedure
Database
28. A characteristic or property of an entity
Entity-Relationship (E-R) Diagram
Attribute
Security
Join Line
29. The column on which two tables are joined
Compound Conditions
ALTER TABLE
Foreign Key
Join Column
30. A screen object you use to maintain or view and print data from a database
Relationship
CREATE TABLE
Form
INTERSECT
31. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Syscolumns
Design Grid
Entity
Functions
32. The area of memory in MySQL that stores the most recently entered command
Database Management System (DBMS)
Statement History
Sysindexes
Relation
33. A word that is part of the SQL language
Data File
Documenter
Reserved Words
Relation
34. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Criterion
Product
Arguments
35. What type of an operator is >= ?
DROP INDEX
Compound Criteria
Data File
Comparison Operator
36. An application program's or an individual user's picture of a database
Stored Procedure
Reserved Words
Field
View
37. A characteristic or property of an entity
Attribute
AND Criterion
Sort
Database
38. When comparing tables an intersection is a new table containing all rows that are in both original tables
Server
Query
Natural Join
Intersection
39. A screen object you use to maintain or view and print data from a database
Attribute
Minor Sort Key
Update Query
Form
40. The process of arranging rows in a table or results of a query in a particular order
PROJECT
Stored Procedure
Sort
Primary Sort Key
41. In an Access query the line drawn between tables to indicate how they are related
Data Independence
Data File
Reserved Words
Join Line
42. The SQL statement that is used to revoke privileges from users of a database
Primary Sort Key
REVOKE
Sort Key
Relationship
43. The SQL command used to make changes to existing table data
UPDATE
Column
Database Management System (DBMS)
Integrity
44. A database has integrity if the data in it satisfies all established integrity constraints
Sysviews
Integrity
Validation Text
Entity Integrity
45. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Arguments
Join Line
Intersection
46. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
Primary Key
WHERE Clause
PRIMARY KEY
Unnormalized Relation
47. What type of an operator is >= ?
One-to-Many Relationship
Delimiter
Field
Comparison Operator
48. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Database Administration (DBA)
Data Independence
Qualify
49. An index built on more than one field
Relationship
Multiple-Field Index
Form
Repeating Groups
50. The part of an SQL SELECT command that indicates grouping
Entity
Integrity Constraint
Arguments
GROUP BY Clause