data storage and querying

mcqspedia.com has 5 Question/Answers about Topic data storage and querying

Component that provides interface between low-level data stored and application programs and queries submitted to system, is known as

Component that provides interface between low-level data stored and application programs and queries submitted to system, is known as
  • A. Storage manager
  • B. Storage processor
  • C. Query processor
  • D. Query manager
  • Correct Answer: Option A

Data is moved between disk storage and main memory as needed, because of the

Data is moved between disk storage and main memory as needed, because of the
  • A. Efficiency
  • B. Storage space
  • C. Processing speed
  • D. Normalization
  • Correct Answer: Option B

Component of storage manager, which ensures that database remains in a consistent state despite of system failures, is known as

Component of storage manager, which ensures that database remains in a consistent state despite of system failures, is known as
  • A. File manager
  • B. Authorization and integrity manager
  • C. Buffer manager
  • D. Transaction manager
  • Correct Answer: Option D

Translation of various DML statements into low-level file-system commands, is done by

Translation of various DML statements into low-level file-system commands, is done by
  • A. Query processor
  • B. Storage manager
  • C. Query manager
  • D. Storage processor
  • Correct Answer: Option B

Functional components of a database system can be broadly divided into

Functional components of a database system can be broadly divided into
  • A. 2 components
  • B. 3 components
  • C. 4 components
  • D. 5 components
  • Correct Answer: Option A