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. A query that removes records which match the criteria you specify from one or more tables
Numeric Data Type
Column
Delete Query
Form
2. Dependency where determinant determines a list of values.
Multi-valued Dependency
Boyce-Codd Normal Form
Boyce-Codd Normal Form
Default Value
3. One or more fields whose values uniquely identify each record in a table.
Domain/Key Normal Form
Primary Key
Data Integrity Rules
Numeric Data Type
4. Candidate key selected for use.
First Normal Form
Data Warehouse
Primary Key
Schema
5. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.
Object-Oriented Database
Column
Many-to-Many Relationships
Entities
6. All determinants are candidate keys.
View
Field
Boyce-Codd Normal Form
Second Normal Form
7. A control that indicates whether an option is selected or not. A tick mark appears in the box when the option is selected.
Check Box
Column
Many-to-Many Relationships
Expression Builder
8. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
Triggers
Fourth Normal Form
Form
Metadata
9. 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
Best Normal Form
Aggregate Function
Table Window
10. A characteristic of a field that determines what kind of data it can store and what type of operations can be performed on it.
Hierarchical Database
One-To-One Relationship
Many-to-Many Relationships
Data Type
11. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Second Normal Form
Data Mining
Report
First Normal Form
12. One (or more fields) in a table that refer to the primary key in another table.
Access 2007
Foreign Key
First Normal Form
Primary Key
13. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Alternate Key
Transitive Dependency
Access
Text Box
14. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Numeric Data Type
Calculated Field
Table
Field
15. 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.
Referential Integrity Constraint
Data
Access
Default Value
16. Functional dependency involving only non-key attributes.
Transitive Dependency
Compound Key
Fourth Normal Form
Action Query
17. 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.
Calculated Field
Text Box
Multi-valued Dependency
Hierarchical Database
18. This is a property of data which - when satisfied - requires every value of one field (attribute) of a table to exist as a value of another field in another related table.
Referential Integrity
Best Normal Form
Composite Key
Relation
19. 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.
Access 2007
SQL View
Primary Key
Best Normal Form
20. 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.
Tuple
One-To-One Relationship
Primary Key
SQL View
21. 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
Field
One-To-Many Relationship
Key
Database
22. A characteristic of the items in a database i.e. a field
Calculated Field
Data Sheet
Attribute
SQL View
23. A database object on which you place controls for entering - displaying and editing records in a table.
Candidate Key
Data Sheet
Form
One-To-One Relationship
24. All key attributes defined - attributes depend on key and no repeating groups.
Recursive Dependency
First Normal Form
Data Type
Currency Data Type
25. Knowing the value of one attribute you can determine the value of another attribute.
Functional Dependency
Select
Domain/Key Normal Form
Access
26. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
E-R diagram
Third Normal Form
Expression Builder
Action Query
27. a.k.a record
Database Window
Query
Data
Tuple
28. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Make Table Query
Cardinality
Fourth Normal Form
Form
29. A data model in which the data is organized into a tree-like structure. The structure allows representing information using parent/child relationships: each parent can have many children - but each child has only one parent
Data Model
Many-to-many Relationship
Hierarchical Database
Comparison Operator
30. 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.
Expression Builder
Third Normal Form
Domain/Key Normal Form
Relational Database Model
31. 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.
Select
One-To-Many Relationship
Make Table Query
Database Management System (DBMS)
32. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
E-R diagram
Key
Record
Schema
33. A field data type that automatically stores a unique number for each record as it is added to a table.
Autonumber
Data Mining
First Normal Form
Hierarchical Database
34. Groups of database commands which are to be treated as a single atomic event.
Transaction
Triggers
Query
Entities
35. A record as seen in the data sheet view.
Database
One-To-Many Relationship
Foreign Key
Row
36. A graphical representation of entities and their relationship to each other - typically used in computing in regard to the organization of data within databases or information systems
Entities
Data Model
Many-to-many Relationship
E-R diagram
37. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Criteria
Many-to-Many Relationships
Numeric Data Type
Action Query
38. A function such as sum - count or average that you use to include summary data in a report.
Flat File
Normalization
Multi-valued Dependency
Aggregate Function
39. A primary key that is comprised of more than one field.
Primary Key
Data Model
View
Composite Key
40. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Compound Key
Object-Oriented Database
Entity Relationship Diagram
Secondary Key
41. To modify a database - or the files associated with the database.
Compound Key
E-R diagram
Transact
Table Window
42. In an access databse - a window in which you work with tables in design view or datasheet view.
Design Vie
Table Window
Database Management System (DBMS)
Determinant
43. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Multi-valued Dependency
Trigger
Query
Comparison Operator
44. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Compound Key
First Normal Form
Referential Integrity
Candidate Key
45. A way of looking at a database object - usually looking at the design or at the contents/results
Self-Join
Field
Action Query
View
46. 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.
SQL
Many-to-Many Relationships
Database
Data Model
47. The part of an SQL statement that specifies which record to retrieve.
Data Integrity Rules
Best Normal Form
Data Model
Where clause
48. A graphical representation of any portion of a database scheme.
Key
Entities
Database Diagram
Select Query
49. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Select
Recursive Dependency
Boyce-Codd Normal Form
Index
50. 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
SQL
Boyce-Codd Normal Form
Primary Key