NANDHOO
.
Learning Paths
Dashboard
Sign In
Home
Dashboard
SQL Engineering Mastery
SQL Foundations & DDL (Data Definition Language)
Quiz
Chapter Quiz: SQL Foundations & DDL (Data Definition Language)
SQL Foundations & DDL
Complete this assessment with 100% score to master this chapter.
01
Which DDL operation is technically an O(1) metadata operation that deallocates data pages without logging individual row deletions?
DELETE
DROP
TRUNCATE
ALTER
02
In a B+ Tree storage engine, what is the primary physical effect of defining a PRIMARY KEY constraint?
Creation of a Hash Index
Creation of a Clustered Index
Automatic Normalization
Creation of a Sparse Index
03
Why is using DECIMAL(p, s) preferred over FLOAT for financial data in SQL?
Storage space efficiency
Rounding precision
Sorting speed
Index compatibility
04
What is the primary difference between CHAR(n) and VARCHAR(n) at the storage layer?
CHAR is faster for sorting
VARCHAR is always larger on disk
CHAR pads strings with spaces to reach a fixed length
VARCHAR does not support indexing
05
Which lock type is typically acquired by an ALTER TABLE operation that requires a full table rewrite, blocking all other operations?
Row-level Lock
Shared Lock
Access Exclusive Lock
Intent Lock
Submit Answers
Back to Lesson
Next Chapter