DBMS-Physical Data Organization

DBMS-Physical Data Organization
41. 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.
  • TRUE
  • FALSE
Show Answer
42. B+-tree index is a balanced tree in which the internal nodes direct the search operation and the leaf nodes contain the data entries.
  • TRUE
  • FALSE
Show Answer
43. If data are stored sequentially on a magnteic tape, they are ideal for:
  • on-line applications
  • batch processing applications
  • spreadsheet applications
  • decision-making applications.
Show Answer
44. Compared to the main memory, secondary memory is:
  • costly
  • volatile
  • faster
  • none of these
Show Answer
45. Secondary storage devices are used for:
  • backup of data
  • permanent data storage
Show Answer
46. Which of the following is direct access processing method?
  • relative addressing
  • indexing
  • hashing
  • all of these
Show Answer
47. Compared to the main memory, secondary memory is:
  • costly
  • volatile
  • faster
  • none of these
Show Answer
48. A file contains the following that is needed for information processing:
  • Knowledge
  • Instructions
  • data
  • none of these
Show Answer
49. Which of the following is a valid file type?
  • master file
  • report file
  • transaction file
  • none of these
Show Answer
50. Which of the following stores data that is permanent in nature?
  • transaction file
  • master file
  • report file
  • none of these
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test