Free Oracle 1z0-074 Exam Dumps Questions & Answers

You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?

• A.It is not audited because audit records are stored only when unified auditing is enabled in the database.
• B.It is audited because, by default, all user activities in the database are audited.
• C.It is not audited because the table belongs to another schema.
• D.It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
• E.It is audited because unified auditing is disabled be default.

Which three types of database objects can have their columns stored in the In-Memory column store? (Choose two.)

• A.heap tables with dependent materialized views
• B.sys-owned objects stored in sysaux-defined tablespaces
• C.heap tables with composite primary key constraints
• D.index-organized tables stored in system-defined tablespaces
• E.clustered tables with dependent materialized views

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE.
You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

• A.A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.
• B.A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.
• C.A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.
• D.Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.
• E.Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?

• A.They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.
• B.They are collected for all segments and are stored in the SYSTEM tablespace.
• C.They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.
• D.They are collected only for the ORDERS table if it has an associated ADO policy.
• E.They are collected for all segments and are stored in the SYSAUX tablespace.

Examine these statements:

Which statement is true?

• A.Statement 1 will return an error
• B.Statements 2 and 3 will validate the conversion
• C.Only statement 3 will validate the conversion
• D.Only statement 1 will validate the conversion
• E.All the statements will validate the conversion