Database Management System MCQ Online Test - Set 02 - ObjectiveBooks

Database Management System MCQ Online Test - Set 02

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?
    (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?

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: