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 Management
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 conditional expession that is to be used to select particular data records from a larger set of records.
Normalization
Criteria
Foreign Key
Attribute
2. A data type that is used for fields and calculations involving money
Null
Currency Data Type
Access
Candidate Key
3. One or more fields whose values uniquely identify each record in a table.
Primary Key
Query
Row
SQL
4. A primary key that is comprised of more than one field.
Primary Key
Form
Composite Key
Field
5. The program which is used to organize - access and manage the data in a database - Creates - processes - and administers databases.
Fourth Normal Form
Database Management System (DBMS)
Primary Key
Compound Key
6. Groups of database commands which are to be treated as a single atomic event.
Transaction
Metadata
Best Normal Form
Super key
7. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Data Manipulation Language
Trigger
Database Object
Super key
8. A window that shows the design or structure of the database objects: tables - queries - forms - reports - macros and data access pages.
Many-to-many Relationship
Select Query
Row
Design Vie
9. The actual pieces of facts that are stored in the fields in a database table.
Default Value
Query
Tuple
Data
10. The dominant database model
Column
Relational Database Model
Referential Integrity Constraint
Comparison Operator
11. One (or more fields) in a table that refer to the primary key in another table.
Foreign Key
Candidate Key
Normalization
Fourth Normal Form
12. Two or more controls that can be treated as one unit while designing a form or report. You can select the group instead of selecting each individual control as you are arranging controls or assigning properties.
Database
Recursive Dependency
Cardinality
Group
13. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.
Data Sheet
Relation
Primary Key
Schema
14. Data from a table - form - query which is displayed in a row-and-column format.
Data Sheet
Key
Data Type
Determinant
15. An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of one and only one record in the related table.
Primary Key
Report
Second Normal Form
One-To-One Relationship
16. A database object that stores data in records and fields. The data is usually about a particular category of things.
Table
First Normal Form
Recursive Dependency
Cardinality
17. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Expression Builder
Sort
Autonumber
Recursive Dependency
18. A field - set up in a query - that displays the result of an evaluated expression rather than displaying stored data.The value of the calculated field is re-calculated each time a value in the expression changes.
Expression Builder
Many-to-many Relationship
Calculated Field
Table Window
19. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Criteria
Normalization
Action Query
Flat File
20. A Key composed of more than one attribute.
Schema
Compound Key
Numeric Data Type
Tuple
21. A table which is not only in 2NF but whose non-primary key fields are dependent only on the primary key and therefore have no dependence on (relationship to) any other non-primary key field in the table.
SQL View
Third Normal Form
Transitive Dependency
Column
22. Refers to the number of associations that can exist between two record types.
Cardinality
Autonumber
Text Box
Select
23. A graphical representation of any portion of a database scheme.
Second Normal Form
Text Box
Database Diagram
Second Normal Form
24. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Numeric Data Type
One-To-One Relationship
Object-Oriented Database
Secondary Key
25. A combination of attributes that can be used to uniquely identify a database record. Candidate keys are a special subset of super keys that do not have any extraneous information in them
Attribute
Access 2007
Group
Super key
26. Relations which allow you to retrieve related records from the same table.
Self-Join
Trigger
Data Definiton Language
Data Integrity Rules
27. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Key
Data Warehouse
Domain/Key Normal Form
Metadata
28. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.
Database Diagram
Flat File
Boyce-Codd Normal Form
Many-to-Many Relationships
29. Dependency where determinant determines a list of values.
Fourth Normal Form
Database
Recursive Dependency
Multi-valued Dependency
30. Arrange the records in a view set in order according to a particular field
Relation
First Normal Form
Sort
Database Management System (DBMS)
31. A referential integrity constraint is a statement that limits the values of the foreign key to those already existing as primary key values in the corresponding table.
Data Type
Database Diagram
Referential Integrity Constraint
Report
32. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Hierarchical Database
Autonumber
Compound Key
Tuple
33. A type of computer file system that stores all data in a single file.
Flat File
Data Type
Database
Default Value
34. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
Record
Schema
Fourth Normal Form
Numeric Data Type
35. An association/link established between common fields in two different tables. A relationship can be one-to-one - many-to-many or more usually one-to-many.
Relation
Metadata
Object-Oriented Database
Data Sheet
36. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Text Box
Data Mining
Aggregate Function
Make Table Query
37. The set of fields in a table which stores unique values and so any one from the list can be selected to be the primary key.
Candidate Key
Group
Select Query
Table
38. A query that asks a question about the data stored in your tables and returns a results set in the form of a data sheet without changing the actual data in the table(s).
Select Query
Foreign Key
Form
Make Table Query
39. Functional dependency involving only non-key attributes.
Hierarchical Database
Access 2007
Aggregate Function
Transitive Dependency
40. The part of an SQL statement that specifies which record to retrieve.
Where clause
Third Normal Form
Comparison Operator
Multi-valued Dependency
41. A window that displays the SQL statement for the current query or is used to create a SQL specific query. When you create a query in design view - Access constructs the SQL equivalent in the SQL view.
Third Normal Form
SQL View
Data
Make Table Query
42. A control that indicates whether an option is selected or not. A tick mark appears in the box when the option is selected.
Null
Transact
Check Box
Composite Key
43. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Boyce-Codd Normal Form
Object-Oriented Database
One-To-Many Relationship
Data Type
44. A link between two or more tables.
Key
Autonumber
Join
Null
45. An action query that adds the records in a query's result set to the end of an existing table.
Transitive Dependency
Row
Access 2007
Append Query
46. A central repository for databases across an entire enterprise.
Self-Join
Design Vie
Data Warehouse
Column
47. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Trigger
Data Warehouse
Default Value
Totals Query
48. The window that appears when you open an Access database or an Access project. It displays the commands for creating new database objects and opening and manipulating existing objects.
Database Window
Self-Join
Row
Domain/Key Normal Form
49. All determinants are candidate keys.
Boyce-Codd Normal Form
Make Table Query
Key
Primary Key
50. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Schema
Access
Access 2007
Key