Ch 38: Query Processing & Optimization

Examines cost-based query optimization, pushing selections and projections down the query tree to minimize intermediate relation sizes before joins.

5 Questions5 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 – 5 of 5 Questions

Page 1 of 1

❓ MCQ📘 CS403📑 Lec 38🏷️ 38.2. Clustered vs Un-clustered IndexesMedium🔁⭐💡🌟📄🎓VU🏛️VU

Relational databases use indexes to speed up data retrieval. Which of the following lists the correct classification categories for database indexes based on physical record ordering and index density?

💻 text Snippet

-- Index Classifications:
-- Clustered (Determines physical data block layout on disk)
-- Dense (Index entry for every key value)
-- Sparse (Index entry for only some key values, e.g. per page)

A.Clustered vs. Un-clustered Indexes, and Dense vs. Sparse Indexes
B.Sequential vs. Hashed Indexes, and Primary vs. Alternate Key Indexes
C.DML vs. DDL Indexes, and Single vs. Composite Key Indexes
D.Volatile vs. Non-volatile Indexes, and Relational vs. Binary Indexes

❓ MCQ📘 CS403📑 Lec 38🏷️ 38.2. Clustered vs Un-clustered IndexesEasy🔁⭐💡📄🎓VU🏛️VU

What is the maximum number of clustered indexes that can be created and maintained on a single relational database table?

💻 sql Snippet

-- A primary key constraint automatically creates a clustered index by default:
ALTER TABLE STUDENT ADD CONSTRAINT PK_STUDENT PRIMARY KEY (stId);

❓ MCQ📘 CS403📑 Lec 38🏷️ 38.2. Clustered vs Un-clustered IndexesHard🔁⭐💡📄🎓VU🏛️VU

In relational database indexing theory, which type of physical index structure determines and physically organizes the actual storage order of data records (rows) on the hard disk platters?

💻 sql Snippet

-- In SQL Server, a PRIMARY KEY constraint automatically establishes:
-- a CLUSTERED INDEX on that column.

A.Secondary index
B.Clustered index
C.Dense index
D.Unclustered index

🧠 Long Problem📘 CS403📑 Lec 38🏷️ 38.2. Clustered vs Un-clustered IndexesHard🔁⭐💡🌟📄🎓VU🏛️VU

Perform a detailed structural and functional comparison of the following indexing classifications: 1. Clustered vs. Un-clustered Indexes 2. Single Key vs. Composite Indexes

💻 sql Snippet

CREATE CLUSTERED INDEX idx_stud_id ON STUDENT (stId);
CREATE NONCLUSTERED INDEX idx_stud_name ON STUDENT (stName);

📝 Short Q📘 CS403📑 Lec 38🏷️ 38.2. Clustered vs Un-clustered IndexesMedium🔁⭐💡🌟📄🎓VU🏛️VU

What is the operational difference between a Primary Key and a Unique Key with reference to Clustered and Non-Clustered indexes?

💻 sql Snippet

-- Primary Key automatically creates Clustered Index:
ALTER TABLE Persons ADD CONSTRAINT PK_ID PRIMARY KEY (PersonID);

-- Unique Key automatically creates Non-Clustered Index:
ALTER TABLE Persons ADD CONSTRAINT UQ_Email UNIQUE (Email);

Ch 38: Query Processing & Optimization

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