MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In physical ordered record files, the non key field for which the records does not have distinct values is classified as |
| A. | Clustering field |
| B. | Linear field |
| C. | Dense field |
| D. | Non dense field |
| Answer» B. Linear field | |
| 2. |
The kind of index in which the records have fixed length with only two fields is classified as |
| A. | Anchor index |
| B. | Cluster index |
| C. | Primary index |
| D. | Secondary index |
| Answer» D. Secondary index | |
| 3. |
In tree structure diagrams, the non leaf node is called |
| A. | Search node |
| B. | Descendant nodes |
| C. | External node |
| D. | Internal node |
| Answer» E. | |
| 4. |
Statement 1: Insertion of record might require the change in position of the initial nodes.Statement 2: Deletion of records might require the change in position of the initial nodes. |
| A. | Both the statements are true |
| B. | Statement 1 is true but statement 2 is false |
| C. | Statement 2 is true but statement 1 is false |
| D. | Both the statements are false |
| Answer» B. Statement 1 is true but statement 2 is false | |
| 5. |
___________ are the indices that store the values of some attributes along with the pointers to the record. |
| A. | Binary indices |
| B. | Covering indices |
| C. | Key indices |
| D. | Static indices |
| Answer» C. Key indices | |
| 6. |
The file which has secondary index for its every field is classified as |
| A. | Fully inverted file |
| B. | Fully indexed file |
| C. | Secondary indexed file |
| D. | Primary indexed file |
| Answer» B. Fully indexed file | |