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. 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
Composite Key
Column Selector
2. 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.
Data Manipulation Language
Relation
SQL View
Composite Key
3. A location within a database table that stores one particular type of data i.e. a field
Form
Column
Attribute
Database Window
4. A value that is automatically entered in a field or control when you add a new record.
Compound Key
Default Value
Transaction
Calculated Field
5. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.
Compound Key
Entities
Many-to-many Relationship
Join
6. Arrange the records in a view set in order according to a particular field
Access
Sort
Where clause
Database Window
7. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
Foreign Key
Database Object
Fourth Normal Form
Secondary Key
8. 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.
Transitive Dependency
Text Box
Database Diagram
Aggregate Function
9. A graphical representation of any portion of a database scheme.
Database Diagram
Secondary Key
Transact
Entity Relationship Diagram
10. A record as seen in the data sheet view.
Referential Integrity
View
Row
Table
11. The program which is used to organize - access and manage the data in a database - Creates - processes - and administers databases.
Normalization
Record
Database Management System (DBMS)
Second Normal Form
12. A data type that is used for fields and calculations involving money
SQL
Metadata
Currency Data Type
Hierarchical Database
13. 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.
Database Window
Data Sheet
Row
Referential Integrity
14. 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.
Super key
Query
Data Mining
Criteria
15. Dependency where determinant determines a list of values.
Action Query
Multi-valued Dependency
Field
Determinant
16. 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
Triggers
Data
Null
17. The persons or things that a database table is about.
Group
Text Box
Data Warehouse
Entities
18. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Data Integrity Rules
Expression Builder
Make Table Query
Fourth Normal Form
19. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Field
Compound Key
Flat File
Database
20. No Transitive Dependencies.
Third Normal Form
Column
Self-Join
One-To-Many Relationship
21. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Access 2007
Database
Data Model
SQL
22. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Transitive Dependency
Boyce-Codd Normal Form
Fourth Normal Form
Default Value
23. A database object that prints information formatted and organised according to your specifications.
Calculated Field
Cardinality
Transaction
Report
24. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Functional Dependency
Group
Many-to-Many Relationships
Field
25. A type of computer file system that stores all data in a single file.
Flat File
Record
Many-to-many Relationship
Data Definiton Language
26. Knowingly violates one or more rules of normalization.
Cardinality
Select Query
Best Normal Form
Numeric Data Type
27. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Data Definiton Language
Autonumber
Select
Criteria
28. 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.
Query
Text Box
Database Diagram
Database Window
29. 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
E-R diagram
Second Normal Form
Index
Transact
30. The dominant database model
Design Vie
First Normal Form
Relational Database Model
Schema
31. 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.
Design Vie
Calculated Field
Key
First Normal Form
32. A database object that stores data in records and fields. The data is usually about a particular category of things.
Table
Primary Key
Database Object
Index
33. 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.
Totals Query
Data Model
SQL
Domain/Key Normal Form
34. A function such as sum - count or average that you use to include summary data in a report.
Compound Key
One-To-One Relationship
Aggregate Function
Database
35. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Key
Flat File
Fourth Normal Form
Alternate Key
36. 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.
Schema
Flat File
Referential Integrity Constraint
Comparison Operator
37. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Key
Comparison Operator
Best Normal Form
Data Model
38. All key attributes defined - attributes depend on key and no repeating groups.
First Normal Form
Table
Database Diagram
Form
39. a.k.a record
Data Type
Tuple
Select
Database
40. A central repository for databases across an entire enterprise.
Data
Field
Data Warehouse
Query
41. 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
Primary Key
Select Query
Referential Integrity Constraint
42. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.
One-To-One Relationship
Column
Many-to-Many Relationships
Autonumber
43. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Numeric Data Type
Transaction
SQL
Domain/Key Normal Form
44. A database object on which you place controls for entering - displaying and editing records in a table.
Key
Form
Primary Key
Recursive Dependency
45. A characteristic of the items in a database i.e. a field
Data Model
Attribute
Delete Query
Hierarchical Database
46. 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.
Append Query
Fourth Normal Form
Schema
SQL
47. Functional dependency involving only non-key attributes.
Transitive Dependency
Action Query
Referential Integrity
Join
48. A Key composed of more than one attribute.
Compound Key
Relation
Entity Relationship Diagram
Schema
49. No multiple multi-valued dependencies.
Multi-valued Dependency
Fourth Normal Form
One-To-One Relationship
Database
50. A query that removes records which match the criteria you specify from one or more tables
Delete Query
Make Table Query
Triggers
Table