Oracle Database SQL — Question 102

Which two statements cause changes to the data dictionary? (Choose two.)

Answer options

• A. DELETE FROM scott.emp;
• B. ALTER SESSION SET NLS_DATE_FORMAT = ‘DD/MM/YYYY’;
• C. GRANT UPDATE ON scott.emp TO fin manager;
• D. SELECT * FROM user_tab_prive;
• E. TRUNCATE TABLE emp;

Correct answer: C, E

Explanation

The correct answers are C and E because both operations alter the data dictionary: C updates privileges and E modifies table structure. Options A and D do not change the data dictionary, while B only adjusts a session parameter without affecting the dictionary.