DBMS MCQs Test 6

This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.

Q. Sort Report generators __________.
Q. Which of the following is true for a Report Form?
Q. A form defines __________.
Q. The designer of a form includes __________.

Q. If calculation is embedded in a form then the __________.
Q. A multiple form file management system allows __________.
Q. The physical locations of a record is determined by a mathematical formula that transforms file key into a record location in a/an __________.
Q. Two files may be joined into a third file if they have __________.
Q. The main ideas behind computer files is that it is convenient to __________.

Q. Minimum number of record movements required to merge five files A(with 10 records), B(with 20 records), C(with 15 records), D(with 5 records) and E(with 25 records) is __________.
Q. A command that lets you change one or more fields in a record is __________.
Q. Which command closes text file which has been created using the below statement :
Q. GO BOTTOM and SKIP-3 commands given one after another, in a database file of 30 records, shift the control to __________.
Q. Which of the following statements is true when structure of database file with 20 records is modified?
Q. Which command is fastest among the following?