Database Management System (DBMS)

121. Which contain information about a file needed by system programs for accessing file records:

  1. File blocks
  2. File operations
  3. File headers
  4. None of these

Correct answer: (C)
File headers

122. The file operations can be divided into how many categories:

  1. 1
  2. 2
  3. 3
  4. 4

Correct answer: (B)
2

123. ___________ take into account only such records that are valid:

  1. Algorithm
  2. Searching algorithm
  3. Flow chart
  4. All of these

Correct answer: (B)
Searching algorithm

124. ___________ file organization is vital for ensuring the most efficient access of files and records:

  1. File blocks
  2. File operations
  3. File headers
  4. File organization

Correct answer: (D)
File organization

125. New records are placed at the end of the file it is referred to as ___________:

  1. Heap file
  2. Pile file
  3. Both
  4. None

Correct answer: (C)
Both

126. The field which is used to order the file is referred to as ___________:

  1. Sorted field
  2. Ordering field
  3. Both
  4. None

Correct answer: (B)
Ordering field

127. Binary search accesses ___________ blocks:

  1. Log(b)
  2. Log2(b)
  3. 2log(b)
  4. Log(2b)

Correct answer: (B)
Log2(b)

128. Which provides precise partition between abstract characteristics of the data type and its implementation specifications:

  1. Data
  2. Data item
  3. File
  4. Data abstraction

Correct answer: (D)
Data abstraction

129. ODBS stands for:

  1. Off data base connection
  2. Open data base connection
  3. Oriented data base connection
  4. All of these

Correct answer: (B)
Open data base connection

130. DDL stands for:

  1. Decode data languages
  2. Data define languages
  3. Database define languages
  4. Define data languages

Correct answer: (B)
Data define languages

Previous
Page 13 of 45
Next
Copyright © EngineeringMCQ.com