Database MCQS - QUESTION DETAILS
Which Oracle clause is used to add an index to an existing table?
A. ADD INDEX
B. CREATE INDEX
C. INDEX TABLE
D. ALTER INDEX

'CREATE INDEX' is used to add an index to an existing table in Oracle.

Similar Questions

In Oracle, what is the purpose of the GROUP BY clause?





In SQL Server, what is the purpose of the GROUP BY clause?





What is the purpose of the SQL LEFT JOIN clause?





Which SQL statement is used to grant specific privileges to a user in MySQL?





In MySQL, what does the term "ACID" stand for in the context of transactions?





Which SQL statement is used to change the value of an existing record in a table?





What is the purpose of the Oracle UNION operator?





What is the purpose of the SQL Server SELECT TOP clause?





Which statement is used to delete records from a table in SQL Server?





What is the purpose of the SQL LIMIT clause?