Question 1

The activity of a file

Accepted Answer

A)  Is a low percentages of number of records added or deleted from a file
B)  If high, reduces processing efficiency for sequential and non sequential files
C)  Is a measure of the percentage of existing records updated during a run
D)  Refers to how closely the files fit into the allocated A

Question 2

The table wizard

Accepted Answer

A)  Quickly creates a default report
B)  Displays a subset of the data in a database
C)  Contains sample tables and fields you can use to create a table
D)  Automatically edits your data as you enter it D

Question 3

What is the term to ask the computer to pt information in order numerically or alphabetically ?

Accepted Answer

A)  Crop
B)  Report
C)  Sort
D)  Organize C

Question 4

The following devices can be used to input data into a database

Accepted Answer

A)  Keyboard, fax roller ball
B)  Mouse, keyboard, monitor
C)  Mouse, keyboard, touch screen
D)  None of the above

Question 5

Pack command is used to

Accepted Answer

A)  Remove records permanently
B)  Remove records temporarily
C)  Restore records permanently
D)  Restore records temporarily

Question 6

What is part of database that holds all of the information about one item or subject?

Accepted Answer

A)  Record
B)  File
C)  Query
D)  Chart

Question 7

RDBMS stands for

Accepted Answer

A)  Relational Database Management System
B)  Relation Data Module System
C)  Right Data Base Management System
D)  None of the above

Question 8

What is a stored question about information in a database?

Accepted Answer

A)  Record
B)  Field
C)  Report
D)  Query

Question 9

The following command is used for sorting

Accepted Answer

A)  list
B)  browse
C)  index
D)  sort

Question 10

The names, address, and account balance of all of your customers, select the best fit for answer

Accepted Answer

A)  record
B)  file
C)  database
D)  key field

Question 11

A form that is used to collect data in a structured manner for entry to a database is called a

Accepted Answer

A)  Database deign form
B)  Systems flowchart
C)  Data capture form
D)  None of above

Question 12

The following statement is not valid about indexing

Accepted Answer

A)  it stores the index fields
B)  it stores the corresponding record number
C)  it maintains the alphabetically order
D)  it duplicate the database file

Question 13

An integrated collection of all of the data about your customers. Select the best fit for answer

Accepted Answer

A)  Record
B)  File
C)  Database
D)  Key field

Question 14

An identification field in a record. Select the best fit for answer

Accepted Answer

A)  Record
B)  File
C)  Database
D)  Key field

Question 15

The following command is used for inserting records

Accepted Answer

A)  INSERT
B)  ADD
C)  Both of the above
D)  None of the above

Question 16

The navigation buttons enable you to

Accepted Answer

A)  move from record to record in a table or form
B)  move from page to page in report
C)  (
A)   and (
B)   both
D)  None of the above

Question 17

The raw facts are called

Accepted Answer

A)  Data
B)  Programs
C)  Commands
D)  Responses

Question 18

List command is used to get

Accepted Answer

A)  List of database contents
B)  List of database contents.
C)  List of variables used in database file
D)  None of the above

Question 19

The Query is a statement requesting for

Accepted Answer

A)  Insertion of information
B)  Deletion of information
C)  Update of information
D)  Retrieval of information

Question 20

The term refers to a collection of related information

Accepted Answer

A)  Database
B)  List
C)  Outline
D)  Record

Exam 2: Database Management and Terminology