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
Flat File
Transaction
Delete Query
SQL
2. A graphical representation of any portion of a database scheme.
Compound Key
Cardinality
One-To-Many Relationship
Database Diagram
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.
Many-to-many Relationship
Transact
Default Value
SQL View
4. A Key composed of more than one attribute.
Select
Flat File
Compound Key
Data
5. Knowingly violates one or more rules of normalization.
Numeric Data Type
Alternate Key
Null
Best Normal Form
6. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.
Form
Database Object
Key
Transact
7. A central repository for databases across an entire enterprise.
Data Warehouse
Database Management System (DBMS)
Secondary Key
Check Box
8. The process of organizing data to minimize redundancy and produce smaller - well-structured relations/tables.
Normalization
Make Table Query
Text Box
Metadata
9. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Action Query
Triggers
Key
Object-Oriented Database
10. Table has no anomalies.
Best Normal Form
Determinant
Check Box
Domain/Key Normal Form
11. The program which is used to organize - access and manage the data in a database - Creates - processes - and administers databases.
Normalization
Database Management System (DBMS)
Field
Numeric Data Type
12. Arrange the records in a view set in order according to a particular field
Compound Key
Tuple
Sort
Action Query
13. 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.
Secondary Key
Database Management System (DBMS)
Totals Query
Best Normal Form
14. 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
Triggers
E-R diagram
Data Warehouse
Self-Join
15. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Compound Key
One-To-Many Relationship
Database
Schema
16. An operator used to compare two values or expressions; For example - < (less than) - > (greater than) - = (equal to)
Comparison Operator
SQL
Expression Builder
Query
17. 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.
One-To-One Relationship
Database
Aggregate Function
First Normal Form
18. A database computer language designed for the retrieval and management of data in relational database management systems (RDBMS) - database schema creation and modification - and database object access control management.
Alternate Key
Recursive Dependency
SQL
Hierarchical Database
19. The process of examining and analyzing data with a view to extracting patterns from it. It is usually done on data warehouses
Data Mining
Recursive Dependency
Multi-valued Dependency
Column Selector
20. To modify a database - or the files associated with the database.
Alternate Key
Transact
E-R diagram
Index
21. One (or more fields) in a table that refer to the primary key in another table.
Data Manipulation Language
Database Window
Second Normal Form
Foreign Key
22. Functional dependency involving only non-key attributes.
Action Query
Foreign Key
Hierarchical Database
Transitive Dependency
23. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Triggers
Index
Expression Builder
Recursive Dependency
24. Contents of a Database: Tables of user data - Metadata - Indexes - Stored Procedures - _______ - Security Data - Backup/Recovery Data
Triggers
Where clause
Delete Query
E-R diagram
25. 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.
Data Warehouse
Self-Join
Candidate Key
Referential Integrity Constraint
26. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Table Window
Second Normal Form
Field
Data Sheet
27. A database object on which you place controls for entering - displaying and editing records in a table.
Form
Multi-valued Dependency
Flat File
Query
28. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Column
Aggregate Function
Default Value
Select
29. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
Referential Integrity Constraint
Fourth Normal Form
Design Vie
Boyce-Codd Normal Form
30. 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
Fourth Normal Form
Many-to-many Relationship
Data Manipulation Language
31. In an access databse - a window in which you work with tables in design view or datasheet view.
Attribute
Determinant
Table
Table Window
32. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Action Query
Hierarchical Database
Database
First Normal Form
33. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Database Management System (DBMS)
Key
Object-Oriented Database
Determinant
34. 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
Check Box
SQL
Alternate Key
35. 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.
Query
Append Query
One-To-Many Relationship
Table
36. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Domain/Key Normal Form
E-R diagram
Flat File
Data Manipulation Language
37. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Third Normal Form
Alternate Key
Where clause
Table
38. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Trigger
Data
Null
Database
39. A way of looking at a database object - usually looking at the design or at the contents/results
Make Table Query
View
Many-to-many Relationship
Form
40. One or more fields whose values uniquely identify each record in a table.
Third Normal Form
Primary Key
Third Normal Form
E-R diagram
41. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.
E-R diagram
Key
Many-to-Many Relationships
Primary Key
42. An action query that adds the records in a query's result set to the end of an existing table.
Field
Append Query
Multi-valued Dependency
Numeric Data Type
43. Knowing the value of one attribute you can determine the value of another attribute.
Secondary Key
Functional Dependency
Candidate Key
Data
44. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Referential Integrity
Record
Table
Numeric Data Type
45. A field data type that automatically stores a unique number for each record as it is added to a table.
Autonumber
Text Box
Row
Where clause
46. 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.
Transact
Database Window
Action Query
Tuple
47. 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
Entity Relationship Diagram
Column Selector
Field
Sort
48. The actual pieces of facts that are stored in the fields in a database table.
Data
Domain/Key Normal Form
Database
Comparison Operator
49. A function such as sum - count or average that you use to include summary data in a report.
Criteria
Aggregate Function
Second Normal Form
Fourth Normal Form
50. All determinants are candidate keys.
Boyce-Codd Normal Form
Numeric Data Type
Transitive Dependency
Data Warehouse