Multiple choice technology databases

What is syntax to unlock the table statastics?

  1. exec DBMS_STATS.UNLOCK_SCHEMA_STATS('TABLE_NAME','OWNER');

  2. exec DBMS_STATS.UNLOCK_SCHEMA_STATS('OWNER','TABLE_NAME');

  3. exec DBMS_STATS.UNLOCK_DB_STATS('DB_NAME','OWNER','TABLE_NAME');

  4. exec DBMS_STATS.UNLOCK_TABLE_STATS('TABLE_NAME','OWNER');

  5. exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');
Reveal answer Fill a bubble to check yourself
E Correct answer
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.

Keep practicing — related questions