adplus-dvertising
frame-decoration

Question

Which command is used to remove an index from the database in SQL?

a.

DELETE INDEX

b.

DROP INDEX

c.

REMOVE INDEX

d.

ROLL BACK INDEX

Posted under DBMS

Answer: (b).DROP INDEX

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which command is used to remove an index from the database in SQL?

Similar Questions

Discover Related MCQs

Q. Which command is used to remove a table from the database in SQL?

Q. In SQL, GRANT command is used to

Q. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

Q. In SQL, which command is used to add new rows to a table?

Q. An operation that will increase the length of a list is

Q. In SQL, which command is used to add a column/integrity constraint to a table

Q. In SQL, which command is used to changes data in a table?

Q. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

Q. Which command(s) is(are) used to redefine a column of the table in SQL ?

Q. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

Q. In SQL, the ALTER TABLESPACE command is used

Q. In SQL, which command(s) is(are) used to create a synonym for a schema object?

Q. In SQL, which of the following is not a data Manipulation Language Commands?

Q. In SQL, the CREATE VIEW command is used

Q. In SQL, which command is used to create a database user?

Q. In SQL, which command(s) is(are) used to redefine an index's future storage allocation

Q. In SQL, which command is used to select data in rows and column from one or more tables?

Q. The _____ command is used to allocates an extent for the table in SQL

Q. In SQL, the _____ command is used to recompile a view

Q. Which language has recently become the de-facto standard for interfacing application programs with relational database system?