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. The conditional expession that is to be used to select particular data records from a larger set of records.
Criteria
Compound Key
View
Group
2. All determinants are candidate keys.
Boyce-Codd Normal Form
Second Normal Form
Database Object
Normalization
3. A field in a table with unique values that although it is not the primary key - it could have been used as such.
SQL
Alternate Key
View
Database
4. Attribute that determines the value of another attribute.
Determinant
Index
Table Window
Cardinality
5. DOC MADE UP
Table
Record
First Normal Form
Recursive Dependency
6. One (or more fields) in a table that refer to the primary key in another table.
Tuple
Primary Key
Foreign Key
Transact
7. 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.
Object-Oriented Database
SQL
Third Normal Form
Normalization
8. 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.
Candidate Key
Data Warehouse
SQL View
Secondary Key
9. 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
Entity Relationship Diagram
Data Definiton Language
Access
Column Selector
10. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.
SQL
Domain/Key Normal Form
Default Value
Data Definiton Language
11. Arrange the records in a view set in order according to a particular field
Normalization
Data Sheet
Sort
Select Query
12. No multiple multi-valued dependencies.
Super key
Cardinality
Data Sheet
Fourth Normal Form
13. A database object that stores data in records and fields. The data is usually about a particular category of things.
Attribute
Fourth Normal Form
Table
First Normal Form
14. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Record
Table Window
Self-Join
Compound Key
15. 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).
Select Query
Group
Best Normal Form
Record
16. A type of computer file system that stores all data in a single file.
Flat File
Primary Key
Best Normal Form
Secondary Key
17. 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.
Secondary Key
Query
Transact
Text Box
18. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Fourth Normal Form
Database Window
Numeric Data Type
Autonumber
19. A characteristic of the items in a database i.e. a field
Determinant
Attribute
Normalization
Table Window
20. 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.
Best Normal Form
Totals Query
SQL
Index
21. Dependency where determinant determines a list of values.
Aggregate Function
Null
Multi-valued Dependency
Many-to-many Relationship
22. 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.
Compound Key
Access
Many-to-Many Relationships
Transact
23. 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 of0 - 1 - or many records in the related table.
One-To-Many Relationship
Data Sheet
Check Box
Record
24. a.k.a record
Tuple
Data Definiton Language
Super key
Metadata
25. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Transact
Entity Relationship Diagram
Candidate Key
Boyce-Codd Normal Form
26. An action query that adds the records in a query's result set to the end of an existing table.
Candidate Key
Append Query
Transitive Dependency
Group
27. A field data type that automatically stores a unique number for each record as it is added to a table.
Database
Report
Where clause
Autonumber
28. A link between two or more tables.
Join
Compound Key
Numeric Data Type
Expression Builder
29. 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.
Text Box
Entities
Transact
Group
30. 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
Transitive Dependency
Super key
Database Window
Access
31. 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
Boyce-Codd Normal Form
Hierarchical Database
Fourth Normal Form
Schema
32. A programming language designed for managing & obtaining data in relational database management systems (RDBMS)
Attribute
Hierarchical Database
Totals Query
SQL
33. A location within a database table that stores one particular type of data i.e. a field
Fourth Normal Form
Column
Compound Key
Database Diagram
34. The process of organizing data to minimize redundancy and produce smaller - well-structured relations/tables.
Null
Normalization
Expression Builder
Metadata
35. 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.
Action Query
Schema
SQL
Transaction
36. Knowing the value of one attribute you can determine the value of another attribute.
Null
Functional Dependency
SQL
Join
37. Candidate key selected for use.
Primary Key
Referential Integrity Constraint
Field
Alternate Key
38. In an access databse - a window in which you work with tables in design view or datasheet view.
Table Window
Database Management System (DBMS)
Append Query
Normalization
39. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Text Box
Data Manipulation Language
Where clause
Calculated Field
40. Data about data.
Third Normal Form
Alternate Key
Metadata
First Normal Form
41. The process of examining and analyzing data with a view to extracting patterns from it. It is usually done on data warehouses
Second Normal Form
Numeric Data Type
Best Normal Form
Data Mining
42. Knowingly violates one or more rules of normalization.
Database Object
Best Normal Form
Compound Key
Many-to-many Relationship
43. A record as seen in the data sheet view.
Select
Many-to-Many Relationships
Second Normal Form
Row
44. One or more fields whose values uniquely identify each record in a table.
Database Object
Second Normal Form
Numeric Data Type
Primary Key
45. To modify a database - or the files associated with the database.
Transact
Cardinality
Sort
Data
46. 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.
Second Normal Form
Totals Query
Attribute
SQL
47. A value that is automatically entered in a field or control when you add a new record.
Relation
Database Object
Default Value
Delete Query
48. 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
Default Value
Form
Column Selector
49. A characteristic of a field that determines what kind of data it can store and what type of operations can be performed on it.
Composite Key
Data Type
Column
Group
50. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Select Query
Database
Object-Oriented Database
Determinant