DBMS-Physical Data Organization Questions and Answers

Practice Mode
Showing 10 of 72 questions
Q41
In a block-level stripping, splitting of blocks is done across multiple disks and it treats the array of disks as a single large disk.
  • A TRUE
  • B FALSE
Answer: Option A
Q42
B+-tree index is a balanced tree in which the internal nodes direct the search operation and the leaf nodes contain the data entries.
  • A TRUE
  • B FALSE
Answer: Option A
Q43
If data are stored sequentially on a magnteic tape, they are ideal for:
  • A on-line applications
  • B batch processing applications
  • C spreadsheet applications
  • D decision-making applications.
Answer: Option B
Q44
Compared to the main memory, secondary memory is:
  • A costly
  • B volatile
  • C faster
  • D none of these
Answer: Option D
Q45
Secondary storage devices are used for:
  • A backup of data
  • B permanent data storage
Answer: Option D
Q46
Which of the following is direct access processing method?
  • A relative addressing
  • B indexing
  • C hashing
  • D all of these
Answer: Option D
Q47
Compared to the main memory, secondary memory is:
  • A costly
  • B volatile
  • C faster
  • D none of these
Answer: Option D
Q48
A file contains the following that is needed for information processing:
  • A Knowledge
  • B Instructions
  • C data
  • D none of these
Answer: Option C
Q49
Which of the following is a valid file type?
  • A master file
  • B report file
  • C transaction file
  • D none of these
Answer: Option D
Q50
Which of the following stores data that is permanent in nature?
  • A transaction file
  • B master file
  • C report file
  • D none of these
Answer: Option D
Database
Back to Database
Questions and Answers for Competitive Exams Various Entrance Test