Database Management Concepts Quiz! Test
(120).jpg "Database Management Concepts Quiz! Test")
How strong is your knowledge of database management concepts? A database is a collection of data with the same characteristics. The database management system a firm uses is expected to use the ability to transfer data and retrieval of the same. By taking this quiz, you will see just how good you are at using a database management system in the application. Test yourself and see what you need to work more on.
- 1.If you have a database containing information about students, then all the information about one student would be referred to as a _____.
- A.
Table
- B.
Field
- C.
Record
- D.
File
- 2.If you have a database containing information about students, then the student's last name would be an example of a _____.
- A.
Table
- B.
Field
- C.
Record
- D.
File
- 3.Within an Access table, each record is represented by one _____.
- A.
Row
- B.
Column
- C.
Datasheet
- D.
File
- 4.Within an Access table, each field is represented by one _____.
- A.
Row
- B.
Column
- C.
Datasheet
- D.
File
- 5.Each database must contain at least one _____.
- A.
Table
- B.
Form
- C.
Report
- D.
Module
- 6.Use this view to display a table in columns and rows.
- A.
Form view
- B.
Design view
- C.
Table view
- D.
Datasheet view
- 7.The first step in designing a new database is _____.
- A.
Entering data
- B.
Building queries
- C.
Planning the tables
- D.
Printing reports
- 8._____ is a field, or combination of fields, that uniquely identifies each record in a table.
- A.
Data type
- B.
Form
- C.
Relationship
- D.
Primary key
- 9.Which of the following is NOT a part of the Query Design window?
- A.
Criteria
- B.
Field
- C.
Or
- D.
Data type
- 10._____ is a column in a table that contains a category of information.
- A.
Field
- B.
Table
- C.
Query
- D.
Label
- 11.Which Data Type would you use for the field "First Name"?
- A.
Text
- B.
Memo
- C.
Number
- D.
Currency
- E.
Yes/No
- 12.All of the following are Data Types in Access EXCEPT _____.
- A.
Sort
- B.
Date/Time
- C.
Yes/No
- D.
OLE Object
- E.
Attachment
- 13.Which Data Type would you use for the field "Basic Salary"?
- A.
Text
- B.
Memo
- C.
Number
- D.
Currency
- E.
Yes/No
- 14.A report is an effective way of presenting your data in an organized format.
- A.
True
- B.
False
- 15.A _____ is a unit of information in a _____.
- A.
Record, field
- B.
Data source, field
- C.
Record, data source
- D.
Field, record
- 16.An organized collection of logically related data is known as _____.
- A.
Meta data
- B.
Data
- C.
Database
- D.
Information
- 17.Which type of field is incremented automatically?
- A.
Auto Elevate
- B.
AutoNumber
- C.
Auto Increment
- D.
Auto Value
- 18.Which of the following is NOT a view for interacting with a form object?
- A.
Layout view
- B.
Datasheet view
- C.
Design view
- D.
Form view
- 19.Which Data Type is better to use for storing a phone number in the following format: 304-555-5555?
- A.
Text
- B.
Currency
- C.
AutoNumber
- D.
Number
- 20.Which of the following is a valid Data Type in Access?
- A.
Hyperlink
- B.
Currency
- C.
Memo
- D.
OLE Object
- E.
Attachment
- F.
All are valid Data Types
- G.
All except Attachment
- 21.What is the intersection of a row and a column?
- A.
Cursor
- B.
Form
- C.
Record
- D.
Cell
- 22.What determines a table's sort order?
- A.
AutoNumber field
- B.
Field order
- C.
Primary key
- D.
Index field
- 23.Which tool do you use to create a query object?
- A.
Simple filter wizard
- B.
Table query wizard
- C.
Database wizard
- D.
Simple query wizard
- 24.Which object(s) can be used to create a form?
- A.
Queries and reports
- B.
Tables only
- C.
Tables and queries
- D.
Tables and reports
- 25.What is the purpose of indexing?
- A.
To reduce table size
- B.
To speed up data search
- C.
Both A and B
- D.
Neither A nor B
Back to top