Which two statements cause changes to the data dictionary? (Choose two.)
Which two statements cause changes to the data dictionary? (Choose two.)
GRANT UPDATE ON scott.emp TO fin manager modifies the data dictionary by updating information about privileges in the database. TRUNCATE TABLE emp is a Data Definition Language (DDL) statement that affects the data dictionary by resetting the table's storage. Both actions lead to changes in the metadata that the data dictionary maintains about the database schema and its objects.
B,C correct. https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm
C, E are correct. Truncate is DDL and it modifies the data dictionary. https://forums.oracle.com/ords/apexds/post/why-is-truncate-ddl-and-not-dml-7859 https://forums.oracle.com/ords/apexds/post/does-truncate-table-generate-undo-4231
I believe CE are correct answers as both are DDL. "ALTER SESSION is not counted as a DDL statements statement although it starts with ALTER" https://renenyffenegger.ch/notes/development/databases/Oracle/SQL/statement/nouns/session/index
CE in my opinion
C and E are correct
CE are correct
C, E correct, GRANT and TRUNCATE are DDL, ALTER SESSION is not.
B modifies the parameter setting in NLS_SESSION_PARAMETERS. C modifies ALL_TAB_PRIVS_RECD and ALL_TAB_PRIVS_MADE. For E, I tried truncating a table with 55000 rows but the truncate had no impact on space related columns in ALL_TABLES.
The link below suggests that nls_session_parameters is part of the data dictionary https://docs.oracle.com/en/database/oracle/oracle-database/18/nlspg/setting-up-globalization-support-environment.html#GUID-8C591C64-EAAF-42F2-A00F-F03E33E26ABF
Based on the documentation https://docs.oracle.com/en/database/oracle/oracle-database/21/cncpt/data-dictionary-and-dynamic-performance-views.html#GUID-497B355D-E8D6-4403-B83B-B94A8AE6934D The data dictionary contains metadata describing the contents of the database. For example, the data dictionary contains information such as the following: The definitions of every schema object in the database, including default values for columns and integrity constraint information The amount of space allocated for and currently used by the schema objects The names of Oracle Database users, privileges and roles granted to users, and auditing information related to users doesn't mention anything about truncate.