Topic: 1z0-071 topic 1 question 202

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

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;

Re: 1z0-071 topic 1 question 202

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.

Re: 1z0-071 topic 1 question 202

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.

Re: 1z0-071 topic 1 question 202

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

  • zouve
  • New member
  • Offline

Re: 1z0-071 topic 1 question 202

CE in my opinion

  • CMjer
  • New member
  • Offline

Re: 1z0-071 topic 1 question 202

C, E correct, GRANT and TRUNCATE are DDL, ALTER SESSION is not.

Re: 1z0-071 topic 1 question 202

CE are correct

Re: 1z0-071 topic 1 question 202

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

Re: 1z0-071 topic 1 question 202

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

Re: 1z0-071 topic 1 question 202

B,C correct.

https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm