[Solved] Which statements are correct regarding indexes?

McqMate

Q.	Which statements are correct regarding indexes?
A.	when a table is dropped, the corresponding indexes are automatically dropped
B.	for each dml operation performed, the corresponding indexes are automatically updated
C.	a non-deferrable primary key or unique key constraint in a table automatically creates a unique index
D.	all of the mentioned
Answer» D. all of the mentioned

2.1k

0

Do you find this helpful?

22

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Which server can join the indexes when only multiple indexes combined can cover the query:
Which command creates database objects like tables, views and indexes:
Which of the following is not true about indexes?
A is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
How many types of indexes are there in sql server?
What is true about indexes?
A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.
Which of the following is correct regarding Aggregate functions?
Which of the following is correct regarding Aggregate functions?
dump, writes out SQL DDL statements and SQL insert statements to a ﬁle, which can then be reexecuted to re- create the database.