Practice Test: Question Set - 02
1. What name is given to the collection of facts, items of information or data which are related in some way?
- (A) Database
- (B) Directory
information
- (C) Information
tree
- (D) Information
provider
2. A database management system
- (A) Allows
simultaneous access to multiple files
- (B) Can do more
than a record management system
- (C) Is a
collection of programs for managing data in a single file
- (D) None of the
above
3. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
- (A) ALTER
TRIGGERS
- (B) ALTER TABLE
- (C) MODIFY
TRIGGERS IN TABLE
- (D) All of the
above
4. A report form
- (A) Appears on
the computer monitor during data entry
- (B) Is used
during report generation to format data
- (C) Both (a) and
(b)
- (D) None of the
above
5. 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 fits into the allocated
6. When you have finished entering information into a form
- (A) The template
is written to the data file
- (B) The contents
of the form are written to the data file
- (C) The contents
of the form can be printed
- (D) None of the
above
7. Primitive operations common to all record management systems include
- (A) Print
- (B) Sort
- (C) Look-up
- (D) None of the above
8. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
- (A) Forecasting
report
- (B) Exception
report
- (C) Regularly
scheduled report
- (D) On
demand report
9. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
- (A) Report
writer
- (B) Query
language
- (C) Data
manipulation language
- (D) Transaction
log
10. The modify operation is likely to be done after
- (A) Delete
- (B) Look-up
- (C) Insert
- (D) All of the
above
11. In SQL, which command is used to changes data in a table?
- (A) UPDATE
- (B) INSERT
- (C) BROWSE
- (D) APPEND
12. Which of the following is a serious problem of file management systems?
- (A) Difficult to
update
- (B) Lack of data
independence
- (C) Data
redundancy
- (D) All of the
above
13. Which of the following is not true of the traditional approach to information processing?
- (A) There is
common sharing of data among the various applications
- (B) It is
file-oriented
- (C) Programs are
dependent on the files
- (D) It is
inflexible
14. An indexing operation
- (A) Sorts a file
using a single key
- (B) Sorts file
using two keys
- (C) Establishes
an index for a file
- (D) Both (b) and
(c)
15. Which command is used to remove a table from the database in SQL?
- (A) DELETE TABLE
- (B) DROP TABLE
- (C) ERASE TABLE
- (D) UNATTACH
TABLE
Next Tests: