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. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.
Transact
Design Vie
Row
Many-to-many Relationship
2. A characteristic of the items in a database i.e. a field
Object-Oriented Database
Secondary Key
Attribute
First Normal Form
3. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Index
Alternate Key
First Normal Form
Criteria
4. Contents of a Database: Tables of user data - Metadata - Indexes - Stored Procedures - _______ - Security Data - Backup/Recovery Data
Comparison Operator
Third Normal Form
Triggers
Append Query
5. 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.
Data Type
Totals Query
Foreign Key
Check Box
6. 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.
Query
SQL View
One-To-One Relationship
Autonumber
7. In an access databse - a window in which you work with tables in design view or datasheet view.
Database
Join
Criteria
Table Window
8. 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
Flat File
One-To-Many Relationship
Database
Primary Key
9. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Sort
Table
Numeric Data Type
Calculated Field
10. A function such as sum - count or average that you use to include summary data in a report.
View
Aggregate Function
Append Query
Null
11. A table which is not only in 2NF but whose non-primary key fields are dependent only on the primary key and therefore have no dependence on (relationship to) any other non-primary key field in the table.
Data Definiton Language
Numeric Data Type
Design Vie
Third Normal Form
12. Candidate key selected for use.
Fourth Normal Form
Database
Primary Key
Entities
13. Knowing the value of one attribute you can determine the value of another attribute.
Functional Dependency
Attribute
Determinant
Record
14. Attribute that determines the value of another attribute.
Cardinality
Data Manipulation Language
Determinant
Text Box
15. A database object that stores data in records and fields. The data is usually about a particular category of things.
Alternate Key
Table
Where clause
Database Object
16. The process of examining and analyzing data with a view to extracting patterns from it. It is usually done on data warehouses
Third Normal Form
Data Mining
Normalization
Table
17. The process of organizing data to minimize redundancy and produce smaller - well-structured relations/tables.
Normalization
Numeric Data Type
Best Normal Form
Schema
18. A type of computer file system that stores all data in a single file.
Cardinality
Many-to-Many Relationships
Determinant
Flat File
19. Data from a table - form - query which is displayed in a row-and-column format.
Data Sheet
Database Window
Compound Key
Secondary Key
20. A value that is automatically entered in a field or control when you add a new record.
Expression Builder
Default Value
Text Box
Check Box
21. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.
Database Object
Attribute
Super key
Object-Oriented Database
22. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.
Database Object
Primary Key
Default Value
Data Definiton Language
23. Relations which allow you to retrieve related records from the same table.
Currency Data Type
Self-Join
Second Normal Form
Attribute
24. An operator used to compare two values or expressions; For example - < (less than) - > (greater than) - = (equal to)
Comparison Operator
Boyce-Codd Normal Form
SQL
Criteria
25. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Database
Sort
Expression Builder
Many-to-many Relationship
26. A database object on which you place controls for entering - displaying and editing records in a table.
Form
One-To-One Relationship
Data Mining
Database Management System (DBMS)
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.
Second Normal Form
Delete Query
Query
Best Normal Form
28. Arrange the records in a view set in order according to a particular field
First Normal Form
Numeric Data Type
Entities
Sort
29. 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
Make Table Query
Entities
Hierarchical Database
Default Value
30. 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.
Index
Default Value
Calculated Field
Schema
31. One or more fields whose values uniquely identify each record in a table.
Access 2007
Tuple
Primary Key
Database Window
32. One (or more fields) in a table that refer to the primary key in another table.
Data Sheet
Referential Integrity Constraint
Foreign Key
Design Vie
33. A graphical representation of any portion of a database scheme.
Default Value
Transitive Dependency
Database Diagram
Relational Database Model
34. A record as seen in the data sheet view.
Default Value
Row
Access
Transact
35. A graphical representation of all entity relationships (Data Model)
Entity Relationship Diagram
Tuple
Transact
First Normal Form
36. 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.
Index
Entity Relationship Diagram
Database Diagram
Join
37. A link between two or more tables.
Super key
Candidate Key
Column Selector
Join
38. No multiple multi-valued dependencies.
Data Model
Record
Fourth Normal Form
Data Integrity Rules
39. 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.
Database Window
Data Sheet
Foreign Key
Action Query
40. The part of an SQL statement that specifies which record to retrieve.
Record
Column
Where clause
Third Normal Form
41. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Row
SQL View
Second Normal Form
Compound Key
42. The actual pieces of facts that are stored in the fields in a database table.
Schema
Secondary Key
Criteria
Data
43. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Sort
Field
Third Normal Form
Database Management System (DBMS)
44. Dependency where determinant determines a list of values.
Delete Query
Multi-valued Dependency
Functional Dependency
Boyce-Codd Normal Form
45. 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.
Relation
Group
First Normal Form
Composite Key
46. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Best Normal Form
Relational Database Model
Third Normal Form
Trigger
47. No Transitive Dependencies.
Data Manipulation Language
Third Normal Form
Database
Database Diagram
48. A primary key that is comprised of more than one field.
One-To-One Relationship
Record
Primary Key
Composite Key
49. 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.
Join
Boyce-Codd Normal Form
Field
Relation
50. A programming language designed for managing & obtaining data in relational database management systems (RDBMS)
Transact
Design Vie
SQL
Index