GAT Subject
Engineering
Computer Science Civil Engineering Chemical Engineering Agricultural Engineering Mechanical Engineering Electronics and Communication
Database Systems - Section 8 Multiple Questions and Answers.
| 6. | In order to use a DBMS, it is important to understand | ||
| A. | the physical schema | ||
| B. | all sub-schemas that the system supports | ||
| C. | one subschema | ||
| D. | both (a) and (b) | ||
| 7. | In SQL, which command(s) is(are) used to recompile a stored function? | ||
| A. | SET FUNCTION | ||
| B. | SET STORED FUNCTION | ||
| C. | ALTER FUNCTION | ||
| D. | All of the above | ||
| 8. | Report generators are used to | ||
| A. | store data input by a user | ||
| B. | retrieve information from files | ||
| C. | answer queries | ||
| D. | both (b) and (c) | ||
| 9. | Administrate supervision of database activities is the responsibility of the | ||
| A. | Database administrator | ||
| B. | DP Manager | ||
| C. | DB Manager | ||
| D. | DP administration | ||
| 10. | Goals for the design of the logical schema include | ||
| A. | avoiding data inconsistency | ||
| B. | being able to construct queries easily | ||
| C. | being able to access data efficiently | ||
| D. | All of the above | ||
Quick Links
GAT Subject
Computer Science English Mcqs Agriculture
Engineering
Computer Science Civil Engineering
Technical
Networking Electronics Database
Past Papers
Model Papers FPSC Papers