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 asks a question about the data stored in your tables and returns a results set in the form of a data sheet without changing the actual data in the table(s).
Normalization
Select Query
Compound Key
First Normal Form
2. Dependency where determinant determines a list of values.
Multi-valued Dependency
Schema
Group
Form
3. No Transitive Dependencies.
One-To-Many Relationship
Key
Multi-valued Dependency
Third Normal Form
4. a.k.a record
Tuple
Composite Key
Entities
Data Mining
5. The part of an SQL statement that specifies which record to retrieve.
Where clause
Report
Sort
Domain/Key Normal Form
6. 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
Boyce-Codd Normal Form
Access 2007
Compound Key
7. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Field
Relation
Group
Flat File
8. A function such as sum - count or average that you use to include summary data in a report.
Form
Aggregate Function
Data Warehouse
Trigger
9. A primary key that is comprised of more than one field.
SQL
Entity Relationship Diagram
Composite Key
Self-Join
10. The program which is used to organize - access and manage the data in a database - Creates - processes - and administers databases.
Database Management System (DBMS)
Relational Database Model
SQL View
Best Normal Form
11. 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.
Aggregate Function
Make Table Query
Referential Integrity Constraint
Second Normal Form
12. An organised pool of related data files which can be easily accessed and managed and that may be used by a number of different application programs
Entities
Composite Key
Database
Data Model
13. 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.
Normalization
Calculated Field
Expression Builder
Data Model
14. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Calculated Field
One-To-One Relationship
Null
Make Table Query
15. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Expression Builder
Primary Key
Criteria
Multi-valued Dependency
16. In an access databse - a window in which you work with tables in design view or datasheet view.
Foreign Key
Aggregate Function
Table Window
Triggers
17. One (or more fields) in a table that refer to the primary key in another table.
Make Table Query
Foreign Key
Multi-valued Dependency
Comparison Operator
18. A characteristic of the items in a database i.e. a field
Boyce-Codd Normal Form
Attribute
Third Normal Form
Alternate Key
19. To modify a database - or the files associated with the database.
Report
Transact
Composite Key
Record
20. 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.
Numeric Data Type
Relation
Database Diagram
First Normal Form
21. 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.
Relational Database Model
Candidate Key
Third Normal Form
Data
22. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Expression Builder
Database Window
Compound Key
Key
23. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Column
Cardinality
Alternate Key
Key
24. Guidelines set in place to ensure the trustworthiness of data over its entire life cycle.
Data Integrity Rules
Determinant
Table
Form
25. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Select
Trigger
Schema
First Normal Form
26. A Key composed of more than one attribute.
Candidate Key
Compound Key
Tuple
Functional Dependency
27. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Record
Aggregate Function
Normalization
Second Normal Form
28. A location within a database table that stores one particular type of data i.e. a field
Database Object
Column
Compound Key
E-R diagram
29. A self-describing collection of integrated tables. The tables are called integrated because they store data about the relationships between the rows of data.
Default Value
Database
Compound Key
Third Normal Form
30. A way of looking at a database object - usually looking at the design or at the contents/results
Second Normal Form
Data Warehouse
View
SQL
31. Relations which allow you to retrieve related records from the same table.
Data Manipulation Language
Column
Record
Self-Join
32. 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
Second Normal Form
Totals Query
Index
33. 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.
Query
SQL View
Trigger
Totals Query
34. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Referential Integrity
Object-Oriented Database
Check Box
Data Integrity Rules
35. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.
Many-to-Many Relationships
Second Normal Form
Currency Data Type
SQL View
36. All key attributes defined - attributes depend on key and no repeating groups.
Data Sheet
First Normal Form
Cardinality
Text Box
37. A characteristic of a field that determines what kind of data it can store and what type of operations can be performed on it.
Database Object
Third Normal Form
Fourth Normal Form
Data Type
38. A database object that prints information formatted and organised according to your specifications.
Referential Integrity Constraint
Report
Super key
Entity Relationship Diagram
39. A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.
Append Query
Null
Expression Builder
Referential Integrity
40. A type of computer file system that stores all data in a single file.
One-To-Many Relationship
Key
Flat File
Hierarchical Database
41. The persons or things that a database table is about.
Database Object
Criteria
Entities
Determinant
42. A graphical representation of any portion of a database scheme.
Determinant
Transitive Dependency
Recursive Dependency
Database Diagram
43. Knowing the value of one attribute you can determine the value of another attribute.
Select Query
Compound Key
Null
Functional Dependency
44. 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
Referential Integrity Constraint
Super key
Object-Oriented Database
Column Selector
45. No partial functional-dependencies.
Database
Database Object
Second Normal Form
Best Normal Form
46. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.
Database Object
First Normal Form
Check Box
Recursive Dependency
47. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Currency Data Type
Data Manipulation Language
Boyce-Codd Normal Form
Access 2007
48. All determinants are candidate keys.
Secondary Key
Transact
Data Definiton Language
Boyce-Codd Normal Form
49. An operator used to compare two values or expressions; For example - < (less than) - > (greater than) - = (equal to)
Comparison Operator
Secondary Key
SQL View
Data Integrity Rules
50. DOC MADE UP
Recursive Dependency
Column
Access 2007
Database Object