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 normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Boyce-Codd Normal Form
Data Type
Tuple
Domain/Key Normal Form
2. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.
Data Mining
Data Warehouse
Expression Builder
Database Object
3. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.
Column Selector
Third Normal Form
Many-to-many Relationship
Compound Key
4. No multiple multi-valued dependencies.
Database Diagram
Fourth Normal Form
Object-Oriented Database
Aggregate Function
5. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Relation
Object-Oriented Database
Functional Dependency
Row
6. 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.
Candidate Key
Transitive Dependency
Fourth Normal Form
Access
7. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Candidate Key
SQL
Attribute
Compound Key
8. A database object on which you place controls for entering - displaying and editing records in a table.
Design Vie
Key
Database Object
Form
9. The persons or things that a database table is about.
Design Vie
Compound Key
Entities
Column Selector
10. 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.
Field
Metadata
Secondary Key
Composite Key
11. A programming language designed for managing & obtaining data in relational database management systems (RDBMS)
Comparison Operator
Data Integrity Rules
Database Window
SQL
12. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Database Object
Database Diagram
Alternate Key
Currency Data Type
13. To modify a database - or the files associated with the database.
SQL
Transact
Make Table Query
Best Normal Form
14. Functional dependency involving only non-key attributes.
Transitive Dependency
Best Normal Form
Where clause
Database Window
15. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Row
Numeric Data Type
Entity Relationship Diagram
Boyce-Codd Normal Form
16. Data from a table - form - query which is displayed in a row-and-column format.
Data Sheet
Super key
Primary Key
Make Table Query
17. A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows of a table.
SQL
Self-Join
Index
Flat File
18. A data type that is used for fields and calculations involving money
Currency Data Type
Key
Flat File
Domain/Key Normal Form
19. A characteristic of the items in a database i.e. a field
Attribute
Access 2007
Data Model
Join
20. 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.
Normalization
Referential Integrity Constraint
Data Sheet
Third Normal Form
21. Refers to the number of associations that can exist between two record types.
Hierarchical Database
Transaction
Where clause
Cardinality
22. A window that shows the design or structure of the database objects: tables - queries - forms - reports - macros and data access pages.
Entities
Design Vie
Compound Key
Expression Builder
23. A Key composed of more than one attribute.
Select Query
Compound Key
Alternate Key
Relational Database Model
24. Relations which allow you to retrieve related records from the same table.
Normalization
Boyce-Codd Normal Form
Attribute
Self-Join
25. No partial functional-dependencies.
Data Manipulation Language
Numeric Data Type
Second Normal Form
Delete Query
26. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Fourth Normal Form
Select
Referential Integrity Constraint
Many-to-Many Relationships
27. A primary key that is comprised of more than one field.
Many-to-Many Relationships
Transaction
Composite Key
Primary Key
28. Knowing the value of one attribute you can determine the value of another attribute.
Functional Dependency
Best Normal Form
Select
E-R diagram
29. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Default Value
Data Warehouse
Database Object
Trigger
30. A type of computer file system that stores all data in a single file.
Delete Query
Foreign Key
Flat File
Many-to-many Relationship
31. A function such as sum - count or average that you use to include summary data in a report.
Aggregate Function
Transitive Dependency
Report
Select
32. 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.
Fourth Normal Form
Group
View
Database
33. 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.
Relational Database Model
Referential Integrity Constraint
View
Primary Key
34. Groups of database commands which are to be treated as a single atomic event.
Group
Calculated Field
Transaction
Expression Builder
35. A way of looking at a database object - usually looking at the design or at the contents/results
Fourth Normal Form
Table
View
Entity Relationship Diagram
36. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Second Normal Form
Delete Query
Database Management System (DBMS)
Data Manipulation Language
37. Knowingly violates one or more rules of normalization.
Functional Dependency
Select Query
Totals Query
Best Normal Form
38. One or more fields whose values uniquely identify each record in a table.
Transitive Dependency
Null
Comparison Operator
Primary Key
39. No Transitive Dependencies.
Third Normal Form
Criteria
Select
Default Value
40. The process of examining and analyzing data with a view to extracting patterns from it. It is usually done on data warehouses
Data Mining
Boyce-Codd Normal Form
Column Selector
Secondary Key
41. A graphical representation of all entity relationships (Data Model)
Schema
Entity Relationship Diagram
Database
Entities
42. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Compound Key
View
Second Normal Form
Referential Integrity Constraint
43. A characteristic of a field that determines what kind of data it can store and what type of operations can be performed on it.
Data Type
Database Object
View
Fourth Normal Form
44. 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
Object-Oriented Database
Data Integrity Rules
Column Selector
45. The actual pieces of facts that are stored in the fields in a database table.
Data
Table
Comparison Operator
Make Table Query
46. 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.
Select Query
Calculated Field
Relational Database Model
Tuple
47. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.
Database
Third Normal Form
Database Object
Schema
48. Guidelines set in place to ensure the trustworthiness of data over its entire life cycle.
Secondary Key
Trigger
Data Integrity Rules
Relational Database Model
49. A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.
Group
Best Normal Form
Triggers
Null
50. 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.
Null
Report
SQL
One-To-Many Relationship