Deck 2: Database Management and Terminology

Question 1

COUNT command is used to

A)Count the number of data fields in an active database file
B)Count the number of data files which are active
C)Count the records which are updated
D)Count the number of records in an active database file

Answer 1

Count the number of records in an active database file

Question 2

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

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

Answer 2

Sort

Question 3

The raw facts are called

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

Answer 3

Data

Question 4

The term refers to a collection of related information

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

Question 5

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

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

Question 6

The following command is used for inserting records

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

Question 7

The Query is a statement requesting for

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

Question 8

The activity of a file

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

Question 9

The following statement is not valid about indexing

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 10

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

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

Question 11

The following command is used for sorting

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

Question 12

List command is used to get

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

Question 13

Corrupted index file is corrected using

A)Modifyindex
B)Recreateindex
C)Reindex
D)None of the above

Question 14

The navigation buttons enable you to

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 15

Different levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by

A)Password
B)User id's
C)Status
D)None of the above

Question 16

The table wizard

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

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

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

Question 21

What is a stored question about information in a database?

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

Question 22

RDBMS stands for

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

Question 23

Pack command is used to

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