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. 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 of0 - 1 - or many records in the related table.
Triggers
One-To-Many Relationship
Trigger
Determinant
2. In an access databse - a window in which you work with tables in design view or datasheet view.
Column Selector
Data Sheet
Select
Table Window
3. A value that is automatically entered in a field or control when you add a new record.
Table
Access
Default Value
Group
4. 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.
Compound Key
Referential Integrity Constraint
E-R diagram
Entities
5. The process of examining and analyzing data with a view to extracting patterns from it. It is usually done on data warehouses
One-To-Many Relationship
Many-to-many Relationship
Data Mining
Triggers
6. Knowingly violates one or more rules of normalization.
Best Normal Form
Row
Table Window
Database Object
7. The horizontal bar at the top of a column. You can click a column selector to select the entire column in the query design grid or the filter design grid
Column Selector
Autonumber
Database Object
Many-to-Many Relationships
8. 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.
Third Normal Form
Criteria
Database Object
Action Query
9. An action query that adds the records in a query's result set to the end of an existing table.
Calculated Field
Query
Database Window
Append Query
10. A characteristic of the items in a database i.e. a field
Entity Relationship Diagram
Hierarchical Database
Data
Attribute
11. A question about the data stored in your tables - or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form. report or data access page.
Sort
Data Model
Table
Query
12. A self-describing collection of integrated tables. The tables are called integrated because they store data about the relationships between the rows of data.
Database
Data Sheet
Referential Integrity Constraint
Candidate Key
13. One (or more fields) in a table that refer to the primary key in another table.
Third Normal Form
Data Definiton Language
Many-to-Many Relationships
Foreign Key
14. A location within a database table that stores one particular type of data i.e. a field
Table Window
Transaction
Hierarchical Database
Column
15. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Table Window
Access 2007
Join
Query
16. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.
Schema
First Normal Form
Multi-valued Dependency
Append Query
17. A primary key that is comprised of more than one field.
Composite Key
Boyce-Codd Normal Form
Access 2007
Data Definiton Language
18. A graphical representation of all entity relationships (Data Model)
Entity Relationship Diagram
Query
Database Window
Third Normal Form
19. A graphical representation of any portion of a database scheme.
Alternate Key
Database Diagram
Referential Integrity
Table Window
20. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Fourth Normal Form
Second Normal Form
Entity Relationship Diagram
Best Normal Form
21. The dominant database model
Relational Database Model
Record
Best Normal Form
Sort
22. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Aggregate Function
Key
Trigger
Table Window
23. No Transitive Dependencies.
Database Window
Fourth Normal Form
Null
Third Normal Form
24. A field data type that automatically stores a unique number for each record as it is added to a table.
Secondary Key
Criteria
Autonumber
Database Diagram
25. DOC MADE UP
Relation
Recursive Dependency
Data Warehouse
Composite Key
26. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Tuple
Field
Secondary Key
Many-to-many Relationship
27. An organised pool of related data files which can be easily accessed and managed and that may be used by a number of different application programs
Triggers
Boyce-Codd Normal Form
Key
Database
28. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.
Access 2007
Form
Data Definiton Language
Delete Query
29. 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.
Cardinality
Relation
Calculated Field
Determinant
30. The part of an SQL statement that specifies which record to retrieve.
Database Window
Where clause
Many-to-Many Relationships
Second Normal Form
31. 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.
Group
Entity Relationship Diagram
Transact
Third Normal Form
32. All determinants are candidate keys.
Self-Join
Boyce-Codd Normal Form
Action Query
Many-to-many Relationship
33. A data type that is used for fields and calculations involving money
SQL
Recursive Dependency
Currency Data Type
Database Diagram
34. All key attributes defined - attributes depend on key and no repeating groups.
Entities
Many-to-Many Relationships
Database
First Normal Form
35. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Numeric Data Type
Form
Index
Fourth Normal Form
36. 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.
Alternate Key
Domain/Key Normal Form
One-To-One Relationship
Best Normal Form
37. No multiple multi-valued dependencies.
Fourth Normal Form
Foreign Key
Second Normal Form
Determinant
38. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Where clause
Primary Key
SQL View
Select
39. A control - also called an edit field - used on a form - report or data access page to display text or accept data entry.It can have a label attached to it.
Data Warehouse
Text Box
Transitive Dependency
Composite Key
40. An abstract model that documents and organizes the business data for communication between team members and is used as a plan for developing applications - specifically how data is stored and accessed.
Join
Data Model
Action Query
Second Normal Form
41. The program which is used to organize - access and manage the data in a database - Creates - processes - and administers databases.
Database Management System (DBMS)
Database Window
Hierarchical Database
First Normal Form
42. 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.
Many-to-Many Relationships
Secondary Key
Default Value
Database Window
43. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Boyce-Codd Normal Form
Referential Integrity Constraint
Database Window
Relational Database Model
44. 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.
Aggregate Function
Relational Database Model
Relation
Action Query
45. One or more fields whose values uniquely identify each record in a table.
Primary Key
Column Selector
Database Window
Compound Key
46. Groups of database commands which are to be treated as a single atomic event.
Null
Entities
Best Normal Form
Transaction
47. A DBMS created by Microsoft - it is a collection of data and objects - such as tables - queries - or forms - related to a particular topic or purpose.
Domain/Key Normal Form
Access
Fourth Normal Form
Alternate Key
48. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Action Query
Domain/Key Normal Form
Comparison Operator
Trigger
49. Data about data.
Metadata
Composite Key
Primary Key
Functional Dependency
50. 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
Alternate Key
Super key
Cardinality
Design Vie