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 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
Relational Database Model
Expression Builder
Delete Query
Super key
2. Functional dependency involving only non-key attributes.
Key
Third Normal Form
Transitive Dependency
Referential Integrity
3. No partial functional-dependencies.
Row
Access
Second Normal Form
Table Window
4. 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.
Flat File
Compound Key
Record
Query
5. 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.
Normalization
Compound Key
Hierarchical Database
Access
6. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.
Data Integrity Rules
Boyce-Codd Normal Form
Many-to-Many Relationships
Compound Key
7. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Entity Relationship Diagram
Normalization
Second Normal Form
Criteria
8. Attribute that determines the value of another attribute.
Self-Join
SQL
Determinant
Column
9. A function such as sum - count or average that you use to include summary data in a report.
Select Query
E-R diagram
Aggregate Function
Sort
10. 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
Report
Table
Sort
11. The persons or things that a database table is about.
Data
Compound Key
Entities
Trigger
12. A way of looking at a database object - usually looking at the design or at the contents/results
Query
Transaction
Action Query
View
13. A graphical representation of any portion of a database scheme.
Access
Database Diagram
Boyce-Codd Normal Form
Alternate Key
14. A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.
Null
Third Normal Form
Table
Database Management System (DBMS)
15. Table has no anomalies.
Cardinality
Database Management System (DBMS)
Domain/Key Normal Form
Second Normal Form
16. An operator used to compare two values or expressions; For example - < (less than) - > (greater than) - = (equal to)
Cardinality
Tuple
Form
Comparison Operator
17. An action query that adds the records in a query's result set to the end of an existing table.
Aggregate Function
Append Query
Transact
Text Box
18. A primary key that is comprised of more than one field.
Second Normal Form
Composite Key
Table Window
Check Box
19. A database object that stores data in records and fields. The data is usually about a particular category of things.
Table
Select Query
Determinant
Data Model
20. A database object on which you place controls for entering - displaying and editing records in a table.
Join
Compound Key
Relational Database Model
Form
21. A graphical representation of all entity relationships (Data Model)
Access 2007
Cardinality
Entity Relationship Diagram
Normalization
22. A link between two or more tables.
Transact
Determinant
Autonumber
Join
23. A database object that prints information formatted and organised according to your specifications.
Report
Self-Join
Compound Key
Primary Key
24. The part of an SQL statement that specifies which record to retrieve.
Database Diagram
Transitive Dependency
Null
Where clause
25. A collection of fields that together describe one entity.
Record
First Normal Form
Aggregate Function
SQL View
26. The actual pieces of facts that are stored in the fields in a database table.
Hierarchical Database
Data Mining
Data
Entities
27. 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
Currency Data Type
E-R diagram
Many-to-Many Relationships
Foreign Key
28. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Relational Database Model
Metadata
Group
Make Table Query
29. A query that displays a summary calculation - such as an average or a sum - for values in a table or tables. A totals query is not a seperate kind of query; rather it extends the flexibility of select queries.
Foreign Key
Column Selector
Totals Query
Self-Join
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.
Key
Third Normal Form
Where clause
Join
31. A value that is automatically entered in a field or control when you add a new record.
Default Value
Metadata
Super key
Query
32. 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.
Database
Third Normal Form
Candidate Key
Text Box
33. Knowingly violates one or more rules of normalization.
Best Normal Form
Referential Integrity Constraint
Index
Attribute
34. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.
Entities
Where clause
Database Object
Multi-valued Dependency
35. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.
Database Diagram
Select
Table Window
Data Definiton Language
36. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Row
SQL
Expression Builder
Aggregate Function
37. Relations which allow you to retrieve related records from the same table.
Functional Dependency
Self-Join
Tuple
Currency Data Type
38. Dependency where determinant determines a list of values.
Candidate Key
Multi-valued Dependency
Many-to-Many Relationships
Autonumber
39. No Transitive Dependencies.
Compound Key
Third Normal Form
Form
Secondary Key
40. A data type that is used for fields and calculations involving money
Primary Key
Relation
Best Normal Form
Currency Data Type
41. A candidate key that coud have been the primary key but was not selected as such ; OR a field that is not the primary key but has been used for indexing nevertheless.
Schema
Cardinality
Column
Secondary Key
42. 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.
Relation
Database Diagram
Referential Integrity
Multi-valued Dependency
43. 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.
Table Window
One-To-One Relationship
Database
Numeric Data Type
44. A record as seen in the data sheet view.
Normalization
Data Sheet
Row
Comparison Operator
45. A Key composed of more than one attribute.
Referential Integrity
Entity Relationship Diagram
Data Model
Compound Key
46. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Fourth Normal Form
Alternate Key
Criteria
Data
47. A central repository for databases across an entire enterprise.
Select
Third Normal Form
Data Warehouse
Database Management System (DBMS)
48. Refers to the number of associations that can exist between two record types.
Autonumber
Table
Cardinality
Schema
49. 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
Record
Index
Null
50. A characteristic of the items in a database i.e. a field
Make Table Query
Select
Attribute
Join