Oracle Database SQL Quiz

Casual Mode - Take your time!

1 / 20

✓

Correct

0

✗

Incorrect

0

★

Score

0%

Multiple Choice

What is syntax to unlock the table statastics?

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