What is syntax to unlock the table statastics?

technology databases

  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');

Show answer
Correct Option: E

Find more quizzes: