Correct Answer: ALTER INDEX index_name REBUILD
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle Database Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle Database MCQ Questions
Which of the following statements is true about rebuilding indexes?
How many columns are there in a Dual table?
A rollback segment can be specified as either PUBLIC or PRIVATE. The value of PCTINCREASE of a rollback segment is always set to:
Which of these is not a language element of SQL?
DBMS_SCHEDULER, along with the power of PL/SQL, provides a mechanism for automating some of the daily tasks. Which of the following is an advantage of using DBMS_SCHEDULER?
Which of the following statements are true about deleting or updating a statement?
The only users recognized by the password file are:
In Forms, what keyboard shortcut will access the shortcut menu?
The basic units that make up a PL/SQL are called:
In an Oracle RAC environment, a physical standby database will be registered with the clusterware. When creating the clusterware resource for the standby database, which of the following commands do you use to perform this registration?