Oracle Database SQL Quiz

Time: 00:00:00

Attempted

Not Attempted

Marked For Review

Attempted & Reviewed

Question 1 of 20

What is syntax to unlock the table statastics?

Select Your Answer:

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

Mark for Review

Attempted

Not Attempted

Marked for Review

Attempted & Reviewed

Current