CE for me.
A. does not affect data dictionary
B. It is local change if you would connect again this won't be permanent
C. Here you affect permision, therefor Data dictionary
D. Affects nothing because it is just select
E. Affects Data dictionary
As for post in https://forums.oracle.com/ords/apexds/post/does-truncate-table-generate-undo-4231
Since TABLE TRUNCATE modifies metadata in the Data Dictionary and resets the High Water Mark of the object...
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
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
wojtekb
1 month agoHUGO2024
8 months agoRIDA_007
11 months, 2 weeks agobillysunday1
1 year agojm9999
1 year, 7 months agojm9999
1 year, 6 months agozouve
1 year, 10 months agoCMjer
1 year, 11 months agoDarnun
2 years agoSathitest071
2 years, 1 month agoDarnun
2 years agoalic_alex
2 years, 1 month ago