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 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.
Third Normal Form
Access
Table
Boyce-Codd Normal Form
2. 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
Database
Relation
Column Selector
Totals Query
3. The part of an SQL statement that specifies which record to retrieve.
Select
Boyce-Codd Normal Form
Where clause
Domain/Key Normal Form
4. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
Autonumber
Foreign Key
Flat File
Fourth Normal Form
5. A database object on which you place controls for entering - displaying and editing records in a table.
Form
Currency Data Type
Referential Integrity Constraint
Normalization
6. A query that removes records which match the criteria you specify from one or more tables
SQL
Determinant
One-To-One Relationship
Delete Query
7. 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
Expression Builder
Data
Best Normal Form
8. A location within a database table that stores one particular type of data i.e. a field
Column
One-To-One Relationship
Secondary Key
Select Query
9. Knowing the value of one attribute you can determine the value of another attribute.
Currency Data Type
Best Normal Form
Functional Dependency
Referential Integrity Constraint
10. 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
Primary Key
Column
Super key
Key
11. 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.
Data
Database Object
Database
SQL View
12. The persons or things that a database table is about.
Primary Key
Where clause
Entities
Attribute
13. An action query that adds the records in a query's result set to the end of an existing table.
Numeric Data Type
Primary Key
Append Query
Boyce-Codd Normal Form
14. 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.
Text Box
Form
Database Management System (DBMS)
Sort
15. A control that indicates whether an option is selected or not. A tick mark appears in the box when the option is selected.
Transitive Dependency
Check Box
SQL
Functional Dependency
16. No partial functional-dependencies.
Second Normal Form
First Normal Form
One-To-One Relationship
Multi-valued Dependency
17. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.
Where clause
Alternate Key
Many-to-many Relationship
Transact
18. 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.
Make Table Query
Referential Integrity Constraint
Append Query
Database
19. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Data Manipulation Language
Entity Relationship Diagram
Append Query
Make Table Query
20. A graphical representation of all entity relationships (Data Model)
Cardinality
Entity Relationship Diagram
Expression Builder
Append Query
21. Attribute that determines the value of another attribute.
Key
Determinant
Index
Trigger
22. Knowingly violates one or more rules of normalization.
Best Normal Form
SQL View
Form
SQL
23. Relations which allow you to retrieve related records from the same table.
Expression Builder
Self-Join
Data Type
Group
24. A value that is automatically entered in a field or control when you add a new record.
Default Value
Access
Second Normal Form
Access 2007
25. A database object that prints information formatted and organised according to your specifications.
Field
Report
Metadata
Transaction
26. 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
Multi-valued Dependency
Data
Hierarchical Database
Tuple
27. 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.
Candidate Key
SQL View
Report
Query
28. One (or more fields) in a table that refer to the primary key in another table.
Database Management System (DBMS)
Table Window
Normalization
Foreign Key
29. A graphical representation of any portion of a database scheme.
Object-Oriented Database
Database Diagram
Second Normal Form
Where clause
30. A data type that is used for fields and calculations involving money
Currency Data Type
Compound Key
Multi-valued Dependency
Best Normal Form
31. 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.
Data Model
Triggers
Compound Key
Currency Data Type
32. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.
Alternate Key
Database Window
Object-Oriented Database
Schema
33. 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.
Check Box
Relational Database Model
Relation
Expression Builder
34. No multiple multi-valued dependencies.
Transaction
Join
Make Table Query
Fourth Normal Form
35. The conditional expession that is to be used to select particular data records from a larger set of records.
Delete Query
Criteria
Numeric Data Type
Null
36. A type of computer file system that stores all data in a single file.
Self-Join
Flat File
Determinant
Column
37. A programming language designed for managing & obtaining data in relational database management systems (RDBMS)
Data Type
SQL
Join
Third Normal Form
38. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.
Data Definiton Language
Entity Relationship Diagram
Trigger
Secondary Key
39. The process of organizing data to minimize redundancy and produce smaller - well-structured relations/tables.
Access
Numeric Data Type
Normalization
One-To-Many Relationship
40. Functional dependency involving only non-key attributes.
Data Definiton Language
SQL
Second Normal Form
Transitive Dependency
41. 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.
First Normal Form
Database Window
Domain/Key Normal Form
Primary Key
42. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Data Manipulation Language
Data Sheet
Alternate Key
Hierarchical Database
43. a.k.a record
Comparison Operator
Access 2007
Tuple
Database Diagram
44. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Row
One-To-Many Relationship
Column Selector
Key
45. Groups of database commands which are to be treated as a single atomic event.
Transaction
Data Integrity Rules
Data Manipulation Language
Access 2007
46. All determinants are candidate keys.
Compound Key
Data
Boyce-Codd Normal Form
Entities
47. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Alternate Key
Boyce-Codd Normal Form
Functional Dependency
Query
48. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Self-Join
Transact
Select
Row
49. All key attributes defined - attributes depend on key and no repeating groups.
Secondary Key
Transact
First Normal Form
Expression Builder
50. Refers to the number of associations that can exist between two record types.
Cardinality
Calculated Field
Referential Integrity Constraint
Relation