Advanced Database - Physical Storage Media Quiz

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the maximum capacity of disk storage as of 2021?

  • 1TB
  • 4.7 to 17 GB
  • 640 MB
  • 112TB (correct)

What is the key characteristic of optical storage media?

  • Volatile and loses data during power failures
  • Requires a spinning disk and laser to read/write data (correct)
  • Provides faster read and write speeds than magnetic disk
  • Can only be written to once and then read-only

What is the main difference between fixed-length and variable-length records?

  • Fixed-length records are stored in blocks, while variable-length records are stored individually
  • Fixed-length records are easier to implement, while variable-length records are more complex
  • Fixed-length records have a predefined size, while variable-length records can be of any size (correct)
  • Fixed-length records require more disk space, while variable-length records are more efficient

What is the purpose of the file descriptor or file header?

<p>To provide information about the file, such as field names and data types (A)</p> Signup and view all the answers

What is the main purpose of blocking when storing records on disk?

<p>To improve read/write performance by storing multiple records in a single disk block (C)</p> Signup and view all the answers

Which type of storage media is the fastest and most costly?

<p>Cache (B)</p> Signup and view all the answers

Which of the following is a characteristic of main memory?

<p>Fast access, but limited capacity (B)</p> Signup and view all the answers

What is a key advantage of flash memory over main memory?

<p>Data survives power failure (A)</p> Signup and view all the answers

Which of the following statements about magnetic disks is true?

<p>Data can be read in any order (B)</p> Signup and view all the answers

What is the primary medium for long-term storage of data in a database system?

<p>Magnetic disk (D)</p> Signup and view all the answers

Flashcards are hidden until you start studying

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser