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.k.a record
Tuple
Metadata
Database
Relational Database Model
2. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.
Referential Integrity Constraint
Query
Data Model
Schema
3. Data from a table - form - query which is displayed in a row-and-column format.
Many-to-Many Relationships
Best Normal Form
Totals Query
Data Sheet
4. A primary key that is comprised of more than one field.
Select
Access
Composite Key
Database Management System (DBMS)
5. A function such as sum - count or average that you use to include summary data in a report.
Aggregate Function
Foreign Key
Index
Database Diagram
6. A way of looking at a database object - usually looking at the design or at the contents/results
Database Window
Action Query
Data Warehouse
View
7. All determinants are candidate keys.
Boyce-Codd Normal Form
Group
Table
Row
8. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.
Many-to-Many Relationships
Data Definiton Language
Fourth Normal Form
Relational Database Model
9. DOC MADE UP
Relational Database Model
Recursive Dependency
Row
Sort
10. 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
Autonumber
Aggregate Function
Data
11. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Field
Sort
Criteria
Transact
12. No multiple multi-valued dependencies.
Autonumber
Table Window
Functional Dependency
Fourth Normal Form
13. 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.
Action Query
One-To-One Relationship
Referential Integrity Constraint
Many-to-Many Relationships
14. A value that is automatically entered in a field or control when you add a new record.
Transaction
Third Normal Form
Default Value
Super key
15. A programming language designed for managing & obtaining data in relational database management systems (RDBMS)
SQL
Data Sheet
Super key
Comparison Operator
16. A central repository for databases across an entire enterprise.
Data Warehouse
Text Box
Currency Data Type
Data Integrity Rules
17. A relation that contains no multivalued attributes.
Compound Key
Record
Metadata
First Normal Form
18. A query that removes records which match the criteria you specify from one or more tables
Database Management System (DBMS)
Delete Query
Normalization
Select Query
19. 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.
One-To-One Relationship
Second Normal Form
Best Normal Form
Query
20. Refers to the number of associations that can exist between two record types.
Entities
Cardinality
Numeric Data Type
Functional Dependency
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.
Delete Query
Totals Query
Database Management System (DBMS)
Data Sheet
22. The actual pieces of facts that are stored in the fields in a database table.
Data Integrity Rules
Data
Second Normal Form
Multi-valued Dependency
23. No partial functional-dependencies.
Second Normal Form
Fourth Normal Form
Database Management System (DBMS)
Entity Relationship Diagram
24. 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.
Default Value
Access
Third Normal Form
Data Warehouse
25. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.
View
Fourth Normal Form
SQL View
Comparison Operator
26. 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
Key
Data Integrity Rules
27. The dominant database model
Database Object
Relational Database Model
Secondary Key
Join
28. In an access databse - a window in which you work with tables in design view or datasheet view.
Many-to-Many Relationships
Table Window
Select Query
Append Query
29. Guidelines set in place to ensure the trustworthiness of data over its entire life cycle.
Multi-valued Dependency
Text Box
SQL View
Data Integrity Rules
30. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Referential Integrity Constraint
Many-to-many Relationship
Composite Key
Boyce-Codd Normal Form
31. A database object that prints information formatted and organised according to your specifications.
Report
Default Value
Super key
Criteria
32. 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.
Third Normal Form
Index
Access 2007
Record
33. A field data type that automatically stores a unique number for each record as it is added to a table.
Autonumber
Aggregate Function
Self-Join
Expression Builder
34. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Third Normal Form
Data Model
Access 2007
Row
35. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Transaction
Third Normal Form
Compound Key
Boyce-Codd Normal Form
36. Stored procedures that may be configured to automatically execute (fire) when certain events take place.
Trigger
Referential Integrity Constraint
Self-Join
Where clause
37. Relations which allow you to retrieve related records from the same table.
Foreign Key
Referential Integrity Constraint
Self-Join
First Normal Form
38. No Transitive Dependencies.
One-To-Many Relationship
Referential Integrity
Metadata
Third Normal Form
39. A data type that is used for fields and calculations involving money
Append Query
SQL View
Currency Data Type
Metadata
40. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.
Cardinality
Referential Integrity
Functional Dependency
Expression Builder
41. The persons or things that a database table is about.
Entities
Normalization
SQL
Candidate Key
42. One (or more fields) in a table that refer to the primary key in another table.
Foreign Key
Flat File
Fourth Normal Form
Database Window
43. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Normalization
Object-Oriented Database
Functional Dependency
Third Normal Form
44. 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.
Fourth Normal Form
SQL View
Design Vie
SQL
45. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Third Normal Form
Database Object
Data Manipulation Language
Primary Key
46. Knowingly violates one or more rules of normalization.
Many-to-many Relationship
Select
Best Normal Form
Foreign Key
47. 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
Super key
Compound Key
Tuple
Many-to-Many Relationships
48. The part of an SQL statement that specifies which record to retrieve.
Functional Dependency
Access 2007
Relation
Where clause
49. 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.
SQL
Primary Key
Third Normal Form
Select
50. A Key composed of more than one attribute.
Primary Key
Compound Key
SQL
Many-to-Many Relationships