wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Database

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

It refers to database applications that look for patterns in already created databases.

a)

Data Mining

b)

Data Warehouse

c)

Data Mart

d)

Database

2.

It is refers to a collection of data designed to support decision making.

a)

Data Mining

b)

Data Warehouse

c)

Data Mart

d)

Database

3.

A subset or smaller focus databases designed to help managers make strategic decisions is a data mart.

a)

Data Mining

b)

Data Warehouse

c)

Data Mart

d)

Database

4.

This refers to selecting the fields for displaying in the search results

a)

Exact Match

b)

Pattern

c)

Range

d)

Selecting Fields

5.

Search finds only entries that are an exact match for a specified word.

a)

Exact Match

b)

Pattern

c)

Range

d)

Selecting Fields

6.

It permits the use of wildcards in place of character

a)

Pattern

b)

Exact Match

c)

Range

d)

Selecting Fields

7.

It provides records that include both terms on either side of the AND.

a)

AND

b)

OR

c)

NOT

d)

NEAR

8.

It provides records that have either term.

a)

NOT

b)

AND

c)

OR

d)

ADJACENT

9.

IT provides records that exclude the term following NOT.

a)

OR

b)

AND

c)

NEAR and ADJACENT

d)

NOT

10.

Is a collection of files and is like a file cabinet and it holds related drawers of records.

a)

Data

b)

Data Types

c)

Database

d)

Database Management System

11.

Raw facts consisting of numbers, letters, characters and dates are data. They are contents of fields.

a)

Data

b)

Data Types

c)

Field

d)

Record

12.

It refers to the description of what data to expect in a field.

a)

Data

b)

Data Types

c)

Field

d)

Record

13.

Is a space within a file with a predefined location and length (Attribute).

a)

Field

b)

Record

c)

File

d)

Database

14.

A collection of fields related or associated with a focal point.

a)

Field

b)

Record

c)

File

d)

Database

15.

Are collections of related records.

a)

File

b)

Database

c)

Database Management System

d)

Record

16.

It is a relationship means that each record in Table A relates to one, and only one, record in Table B, and each record in Table B relates to one, and only one, record in Table A.

a)

One to One

b)

One to Many

c)

Many to Many

17.

It is a relationship means a record in Table A can relate to zero, one, or many records in Table B.

a)

One to One

b)

One to Many

c)

Many to Many

18.

This is a complex relationship in which many records in a table can link to many records in another table.

a)

One to One

b)

One to Many

c)

Many to Many

19.

Is a logical association between tables based on the values in corresponding fields.

a)

Link

b)

Key Field

c)

Table

d)

Database

20.

Is the structure that is used to store the data.

a)

Table

b)

Link

c)

Key Field

d)

File