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.
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
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
HUGO2024
4 months, 4 weeks agoRIDA_007
8 months, 2 weeks agobillysunday1
9 months, 4 weeks agojm9999
1 year, 4 months agojm9999
1 year, 3 months agozouve
1 year, 7 months agoCMjer
1 year, 8 months agoDarnun
1 year, 10 months agoSathitest071
1 year, 10 months agoDarnun
1 year, 10 months agoalic_alex
1 year, 10 months ago