Quiz for Creating and Dropping Indexes

Q1: Which SQL command is used to remove an index from a table?

A. REMOVE INDEX B. DROP INDEX C. DELETE INDEX D. UNINDEX

Q2: Which SQL command is used to create an index?

A. CREATE INDEX B. MAKE INDEX C. NEW INDEX D. INSERT INDEX

Q3: Which SQL command removes an existing index?

A. DELETE INDEX B. REMOVE INDEX C. DROP INDEX D. CUT INDEX

Q4: What does an index improve in a database?

A. Data accuracy B. Data redundancy C. Query performance D. Storage size

Q5: Which type of index allows duplicate values?

A. Unique index B. Composite index C. Non-unique index D. Clustered index

Q6: What happens if you drop a primary key constraint?

A. Associated index is removed B. All rows are deleted C. Table is dropped D. Index remains

Q7: Which clause specifies the table for index creation?

A. ON B. USING C. INTO D. WITH

Q8: What is the correct syntax to create a simple index?

A. CREATE INDEX idx ON table; B. CREATE INDEX idx ON table(col); C. MAKE INDEX ON table(col); D. NEW INDEX idx FOR table(col);

Q9: Can an index be created on multiple columns?

A. No B. Only on one column C. Yes, called a composite index D. Only on numeric columns

Q10: How do indexes affect INSERT and UPDATE operations?

A. They speed them up B. No effect C. They slow them down D. They prevent changes

Q11: Which is true about clustered indexes?

A. They store data separately from index B. They are slower than non-clustered indexes C. They sort the table physically D. They don’t affect performance

Q12: Which index prevents duplicate values in a column?

A. Full-text index B. Unique index C. Hash index D. Filtered index

Q13: What is a disadvantage of having too many indexes?

A. Increased query time B. Data loss C. Slower data modifications D. Lower security

Q14: Which type of index is best for full-text search?

A. Unique index B. Clustered index C. Full-text index D. B-tree index

Q15: Which storage structure do B-tree indexes use?

A. Binary heap B. Balanced tree C. Hash table D. Linked list

Q16: What happens when you drop a non-clustered index?

A. The table is dropped B. Only the index is removed C. All data is lost D. Primary key is deleted

Q17: How can you check existing indexes on a table in MySQL?

A. SHOW INDEXES FROM table_name; B. SELECT * FROM INDEXES; C. DESC INDEX table_name; D. LIST INDEXES;

Q18: Which statement creates a unique index?

A. CREATE UNIQUE INDEX idx ON table(col); B. NEW UNIQUE INDEX idx; C. MAKE UNIQUE INDEX ON table(col); D. INDEX UNIQUE ON table(col);

Q19: What happens if a unique index condition is violated?

A. Row is inserted anyway B. Error is thrown C. Constraint is disabled D. Row is ignored

Q20: What is a filtered index?

A. Index on entire table B. Index on selected rows C. Full-text index D. Clustered index

Q21: Which index type is faster for exact match lookups?

A. B-tree index B. Bitmap index C. Hash index D. Full-text index