wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Database Management System

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

Which statement best describes a database?

a)

a A collection of tables.

b)

Tables that are in sequence.

c)

Tables of related information.

d)

A collection of related tables.

2.

What does the acronym DBMS stands for?

a)

Data Bypass Management System

b)

Database Management System

c)

Digital Base Management System

d)

All of the above

3.

All of the following are data type except?

a)

Name

b)

Memo

c)

Short text

d)

Number

4.

Which of the following is a database object?

a)

Record

b)

Field

c)

Report

d)

Query wizard

5.

_____________is a type of database that stores data physically.

a)

Object database

b)

Electronic Database

c)

Manual Database

d)

Hybrid Database

6.

In what view is the table being displayed?

a)

Design view

b)

Datasheet view

c)

Normal view

d)

Print Preview

7.

What is the program that enables you to create, access and manage electronic database called?

a)

Database

b)

Data Structure

c)

Operating system

d)

Database Management System.

8.

What is another name for the Secondary key field?

a)

Foreign key

b)

Primary key

c)

Alternate key

d)

Candidate key.

9.

Which field in a database table is an automatic field?

a)

ID

b)

Name

c)

Address

d)

Date of Birth

10.

All of the following are examples of Database Management System software except?

a)

Microsoft Access

b)

MySQL

c)

Oracle

d)

FaxBass

11.

______________ is a collection of related fields.

a)

Table

b)

Record

c)

Field

d)

Form

12.

Which key ensure that data in a field must only appear once in the whole table.

a)

Candidate key field

b)

Foreign key

c)

Primary key field

d)

Alternate key field

13.

____________ is where information is stored in a database.

a)

Query

b)

Report

c)

Tables

d)

Microsoft Access

14.

____________allow you to enter, store, analyze, and compile your data however you want.

a)

DBMS

b)

Forms

c)

DBMS Objects

d)

Tables

15.

A table is a collection of records, made of a set of columns called records and a set of rows called fields.

a)

True

b)

False

16.

The linking of tables and files to share records is known as a______________.

a)

Form

b)

Relationship

c)

Foreign key

d)

None of the above

17.

____________are used for entering, modifying, and viewing records.

a)

Tables

b)

Forms

c)

Database objects

d)

View

18.

The image above is an example of generating which database object?

a)

Form

b)

Report

c)

Query

d)

Table

19.

______________offer you the ability to present your data in print.

a)

Report

b)

MS Word

c)

Form

d)

MS Access

20.

Each of these objects interacts with the records stored in your database's ___________________.

a)

Table, Form, Query, Report

b)

Table, Query, Form

c)

Form, Report, Query

d)

Report, Query, Table

21.

__________is the individual properties of an entity. An __________ is represented by a field in a database.

a)

Tuple

b)

Field

c)

Record

d)

Attributes

22.

A ___________ describes what is in the field. This description is displayed in the status bar when you select this field on the form.

a)

Field type

b)

Field size

c)

Field Description

d)

All of the above

23.

The details about a particular entity are called a _________ . A ____________ is represented by a record in a database.

a)

Field Description

b)

Tuple

c)

Field type

d)

Attribute

24.

An ____________is an item in the real world that is represented in a database.

a)

Manual Database

b)

Field name

c)

Entity

d)

Records

25.

The image above is a representation of which database object?

a)

Query

b)

Report

c)

Form

d)

Table in design view