📚 Practice Mode

Oracle Database SQL Quiz

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Choice

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