MCQ | SQL – Index

by karimhani25
78
13

Sql programming

questions

Title
SQL Indexes slows the execution time of which statement(s)? SQL Indexes slows the execution time of which statement(s)? UPDATE INSERT SELECT Both A and B discuss The answer is: D. Both A and B
SQL indexes speed up the execution time of which statement(s)? SQL indexes speed up the execution time of which statement(s)? SELECT WHERE Both A and B None of the above discuss The answer is: C. Both A and B
Why index is important in SQL? Why index is important in SQL? The large database can be searched quickly with SQL Indexes. The concept below is a quick way to include different values in those columns. A smaller table may not recognize the performance of an index when used with an index. All of the above discuss The answer is: D. All of the above
In order to create the Index, we need to use which command? In order to create the Index, we need to use which command? ALTER UPDATE CREATE ADD discuss The answer is: C. CREATE
Unique Index is similar to – Unique Index is similar to – Primary Key Foreign Key Composite Key Alternate Key discuss The answer is: A. Primary Key
To rename the Index, we need to use which command? To rename the Index, we need to use which command? RENAME ALTER UPDATE ADD discuss The answer is: B. ALTER
In order to remove an index, we need to use which command? In order to remove an index, we need to use which command? REMOVE DELETE DROP DEL discuss The answer is: C. DROP
Which statement is correct to remove an Index from MySQL Database? Which statement is correct to remove an Index from MySQL Database? DROP INDEX Index_Name; ALTER TABLE Table_Name DROP INDEX Index_Name; DROP INDEX Index_Name ON Table_Name; DROP INDEX Table_Name.Index_Name; discuss The answer is: B. ALTER TABLE Table_Name DROP INDEX Index_Name;
In the relational database, in order to modify index, we need to use which command? In the relational database, in order to modify index, we need to use which command? ALTER MODIFY UPDATE ADD discuss The answer is: A. ALTER
What is TRUE about SQL EXCEPT clause? What is TRUE about SQL EXCEPT clause? The result is purged of duplicates Duplicate records are not removed Only one column can be compared by a clause None of the above discuss The answer is: A. The result is purged of duplicates
What is TRUE about NOT IN clause? What is TRUE about NOT IN clause? The result is purged of duplicates Duplicate records are not removed Performs column-by-column comparisons None of the above discuss The answer is: B. Duplicate records are not removed
Which of the following states the correct situation in which Indexes should not be used in SQL? Which of the following states the correct situation in which Indexes should not be used in SQL? When the table is small, it is possible to avoid using SQL indexes. Updates need to be made frequently to the table. When there are a lot of NULL values in a column, indexed should not be used. All of the above discuss The answer is: D. All of the above

total MCQs: 13

MCQs

13

Views

78

Best Answers

299

Points

5