GAT Subject
Engineering
Computer Science Civil Engineering Chemical Engineering Agricultural Engineering Mechanical Engineering Electronics and Communication
Database Systems - Section 7 Multiple Questions and Answers.
| 36. | A logical schema | ||
| A. | is the entire database | ||
| B. | is a standard way of organizing information into accessible parts | ||
| C. | describes how data is actually stored on disk | ||
| D. | All of the above | ||
| 37. | Queries to a database | ||
| A. | are written in English | ||
| B. | can use aggregate functions like SUM and COUNT | ||
| C. | both (a) and (b) | ||
| D. | All of the above | ||
| 39. | In SQL, which command is used to select only one copy of each set of duplicable rows | ||
| A. | SELECT DISTINCT | ||
| B. | SELECT UNIQUE | ||
| C. | SELECT DIFFERENT | ||
| D. | All of the above | ||
| 40. | The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in | ||
| A. | a tree file | ||
| B. | an indexed file | ||
| C. | a hashed file | ||
| D. | a sequential file | ||
Quick Links
GAT Subject
Computer Science English Mcqs Agriculture
Engineering
Computer Science Civil Engineering
Technical
Networking Electronics Database
Past Papers
Model Papers FPSC Papers