🎴 Flashcard Mode
Oracle Database SQL Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is syntax to unlock the table statastics?
AnswerClick to flip back
A
exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');
💡 Explanation:
DBMS_STATS.UNLOCK_TABLE_STATS takes two parameters: schema name first, then table name. Options A and B incorrectly use UNLOCK_SCHEMA_STATS which locks/unlocks all tables in a schema. Option C uses UNLOCK_DB_STATS which doesn't exist. Option D has the parameter order reversed.