Ch 34: Physical Database Design

Covers translating logical relations into physical disk files, optimizing query access times, selectively denormalizing tables, and minimizing disk I/O.

22 Questions22 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 1 – 10 of 22 Questions

Page 1 of 3

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.2. Index Construction and Unique IndexesMedium🔁⭐💡🌟📄🎓VU🏛️VU

In a SQL-based database management system, what is the correct syntax to create a UNIQUE composite index named 'Emp_Dept_Idx' on the 'TeacherID' (descending) and 'Office' (ascending) columns of the 'Teacher' table to optimize search performance?

💻 sql Snippet

CREATE UNIQUE INDEX Emp_Dept_Idx ON Teacher (TeacherID DESC, Office ASC);

A.CREATE UNIQUE INDEX Emp_Dept_Idx ON Teacher (TeacherID DESC, Office ASC);
B.CREATE INDEX UNIQUE Emp_Dept_Idx ON Teacher (TeacherID DESC, Office ASC);
C.CREATE COMPOSITE UNIQUE INDEX Emp_Dept_Idx ON Teacher (TeacherID, Office) ORDER BY DESC, ASC;
D.ADD UNIQUE INDEX Emp_Dept_Idx ON Teacher (TeacherID DESC, Office ASC);

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaEasy🔁⭐💡📄🎓VU🏛️VU

Computer storage is categorized based on its power dependency. What classification describes computer storage that loses its stored data immediately when the electrical power is turned off?

💻 text Snippet

Volatile Storage: RAM, Cache buffers
Non-Volatile Storage: Magnetic Disk, SSD, ROM

A.Volatile storage
B.Non-volatile storage
C.Optical storage
D.Magnetic secondary storage

📝 Short Q📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaMedium🔁⭐💡📄🎓VU🏛️VU

Explain the forms of caching normally used in personal desktop computers to improve system performance.

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following physical storage devices records data by burning microscopic holes (pits) in the reflective surface of rotating disk platters using a highly focused laser beam?

A.Hard disk
B.RAM
C.Optical disk
D.Floppy disk

📝 Short Q📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaMedium🔁⭐💡📄🎓VU🏛️VU

What are the forms of cache normally used in desktop computers?

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.2. Index Construction and Unique IndexesMedium🔁⭐💡🌟📄🎓VU🏛️VU

To optimize search operations in a hospital clinical database, which of the following represents the correct standard SQL command to create a UNIQUE composite index named 'Patient_Idx' on the 'PatientID' column (in descending order) and 'AdmissionDate' column (in ascending order) within the 'Patients' table?

💻 sql Snippet

CREATE UNIQUE INDEX Patient_Idx 
ON Patients (PatientID DESC, AdmissionDate ASC);

A.CREATE UNIQUE INDEX Patient_Idx ON Patients (PatientID DESC, AdmissionDate ASC);
B.CREATE INDEX UNIQUE Patient_Idx ON Patients (PatientID ASC, AdmissionDate DESC);
C.ADD UNIQUE INDEX Patient_Idx ON Patients (PatientID DESC, AdmissionDate ASC);
D.CREATE UNIQUE INDEX ON Patients (PatientID, AdmissionDate) ORDER BY DESC, ASC;

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.3. RAID (Redundant Array of Independent Disks) LevelsMedium🔁⭐💡📄🎓VU🏛️VU

True or False: RAID models represent a software development methodology based on producing working system deliverables frequently and repetitively.

A.True
B.False

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaEasy🔁⭐💡📄🎓VU🏛️VU

Under physical storage media classifications, which of the following is NOT classified as a form of optical disk storage technology?

A.CD-ROM
B.WORM (Write Once Read Many)
C.Erasable Optical
D.EEPROM (Electrically Erasable Programmable Read-Only Memory)

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaMedium🔁⭐💡📄🎓VU🏛️VU

True or False: Automated (electronic) data are less susceptible to destruction and misuse than paper-based data.

A.True
B.False

Q10

❓ MCQ📘 CS403📑 Lec 34🏷️ 34.1. Physical Storage MediaMedium🔁⭐💡📄🎓VU🏛️VU

Which of the following is the correct description of a 'cache hit' in physical database storage and memory management?

A.When the requested data is found in the memory cache, avoiding a slow access to the physical disk
B.When data is forcibly evicted or removed from the cache to allocate space for new sectors
C.The total number of times the cache is accessed directly by the processor during transactional cycles
D.When requested data is not present in the cache, requiring a slow disk seek operation

Ch 34: Physical Database Design

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units