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. Data from a table - form - query which is displayed in a row-and-column format.
Data Sheet
Many-to-many Relationship
Secondary Key
Transact
2. The part of an SQL statement that specifies which record to retrieve.
Numeric Data Type
Where clause
Aggregate Function
Referential Integrity
3. A function such as sum - count or average that you use to include summary data in a report.
Aggregate Function
Referential Integrity Constraint
Default Value
Trigger
4. A relation that contains no multivalued attributes.
Field
First Normal Form
Alternate Key
Data Integrity Rules
5. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Default Value
Database Diagram
Make Table Query
Functional Dependency
6. No Transitive Dependencies.
Metadata
Third Normal Form
Currency Data Type
Transact
7. 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.
Join
Access
Hierarchical Database
Database Window
8. No multiple multi-valued dependencies.
Text Box
Fourth Normal Form
One-To-Many Relationship
Normalization
9. The dominant database model
Flat File
Where clause
Object-Oriented Database
Relational Database Model
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
Secondary Key
Schema
Index
Super key
11. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Composite Key
Data Mining
Access 2007
Second Normal Form
12. 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.
Recursive Dependency
SQL View
Database Management System (DBMS)
Cardinality
13. A record as seen in the data sheet view.
Row
Report
Referential Integrity Constraint
Sort
14. Data about data.
Default Value
Form
Foreign Key
Metadata
15. 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.
Join
Index
Text Box
Schema
16. A field data type that automatically stores a unique number for each record as it is added to a table.
First Normal Form
Query
Multi-valued Dependency
Autonumber
17. Relations which allow you to retrieve related records from the same table.
Relational Database Model
Database Management System (DBMS)
Self-Join
Table
18. 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
Sort
Second Normal Form
Database Management System (DBMS)
19. A Key composed of more than one attribute.
Transaction
Fourth Normal Form
Compound Key
E-R diagram
20. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Normalization
Database
Key
Data Type
21. 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.
Many-to-many Relationship
Totals Query
Recursive Dependency
Query
22. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Default Value
Row
Compound Key
Entities
23. 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 Manipulation Language
Data Model
Tuple
Transitive Dependency
24. 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.
Query
Entities
Text Box
Self-Join
25. Candidate key selected for use.
Primary Key
Join
Row
Select Query
26. All key attributes defined - attributes depend on key and no repeating groups.
Cardinality
Record
Text Box
First Normal Form
27. 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
Referential Integrity
Database
Data Type
Referential Integrity Constraint
28. 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.
Database Diagram
Table
Calculated Field
Totals Query
29. To modify a database - or the files associated with the database.
Database Management System (DBMS)
Tuple
Transact
Select Query
30. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Calculated Field
Action Query
Data
Self-Join
31. A self-describing collection of integrated tables. The tables are called integrated because they store data about the relationships between the rows of data.
SQL
Database
Record
Recursive Dependency
32. 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
SQL
Expression Builder
Data Type
33. 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.
Hierarchical Database
Referential Integrity
Candidate Key
Aggregate Function
34. A collection of fields that together describe one entity.
Candidate Key
Key
Compound Key
Record
35. The actual pieces of facts that are stored in the fields in a database table.
Join
Data
Flat File
Transaction
36. A primary key that is comprised of more than one field.
Report
Composite Key
Transact
Triggers
37. Arrange the records in a view set in order according to a particular field
Candidate Key
Sort
Database Diagram
Comparison Operator
38. a.k.a record
Fourth Normal Form
Primary Key
Tuple
Data Integrity Rules
39. 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.
Record
Query
Group
Expression Builder
40. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Field
Join
Expression Builder
Tuple
41. A graphical representation of any portion of a database scheme.
Numeric Data Type
Data Sheet
Data Model
Database Diagram
42. 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.
Currency Data Type
Candidate Key
Data Definiton Language
Calculated Field
43. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Relational Database Model
Null
Trigger
Column Selector
44. 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.
Relation
Determinant
Composite Key
First Normal Form
45. Knowing the value of one attribute you can determine the value of another attribute.
Flat File
Functional Dependency
Second Normal Form
Design Vie
46. 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.
Database Management System (DBMS)
Trigger
Secondary Key
Cardinality
47. 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.
Database Object
SQL
Third Normal Form
Fourth Normal Form
48. A field in a table with unique values that although it is not the primary key - it could have been used as such.
E-R diagram
Alternate Key
Text Box
Field
49. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
Third Normal Form
First Normal Form
Fourth Normal Form
First Normal Form
50. A database object that prints information formatted and organised according to your specifications.
Column
Report
Foreign Key
Sort