Database Management Concepts Quiz! Test

44 Questions | By Angievance | Last updated: Mar 20, 2022 | Total Attempts: 440

Questions

Settings

Create your own Quiz

Database Management Concepts Quiz! Test - Quiz

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.

Questions and Answers

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