Free 1z1-074 Questions for Oracle 1z1-074 Exam

Question #1

A CDB, CDB1, has a LOCATIONS application container.
NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.
Both application PDBs are synchronized with the application installed in the LOCATIONS root...
In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.
You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.
How can you do this?

A. by creating a proxy PDB in CDB1 root, referencing LOC_R

B. by creating a proxy PDB in CDB2 root, referencing LOC_R

C. by using public database links created in CDB1 and CDB2

D. by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R

E. by using private database links created in CDB1 and CDB2

Discussion 0

Correct Answer: B Vote an answer

Question #2

You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.
Which statement is true?

A. The tfact1 command fails because it can be set only by the Oracle software owner.

B. TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 G

C. TFA collects new diagnostic data but logs a warning message.

D. TFA does not collect new diagnostic data when the maximum repository size is reached.

E. TFA collects new diagnostic data while the repository directory's file system has free space.

Discussion 0

Correct Answer: A Vote an answer

Question #3

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks.
Which statement is true about limiting PGA usage for those users' sessions?

A. You cannot limit PGA for a set of database user sessions.

B. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

C. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

D. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

E. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

Discussion 0

Correct Answer: B Vote an answer

Question #4

Which statement is true about Trace File Analyzer (TFA) Collector?

A. In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.

B. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.

C. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.

D. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

E. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.

Discussion 0

Correct Answer: A Vote an answer

Question #5

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 and are stored in the SYSTEM tablespace.

B. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

C. They are collected for all segments and are stored in the SYSAUX tablespace.

D. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

E. They are collected only for the ORDERS table if it has an associated ADO policy.

Discussion 0

Correct Answer: A Vote an answer

Question #6

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It generates execution plans for each SQL statement in an STS.

B. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

C. It always executes triggers that are fired recursively in FULLDML mode.

D. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

E. It recommends the creation of indexes for regressed SQL statements.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #7

QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED are set to TRUSTED and TRUE respectively in an Oracle 12c Release 2 database.
You create the SALES_EVAL real-time materialized view (MV) on the SALES, CUSTOMERS, and PRODUCTS tables, which supports COMPLETE REFRESH by executing these statements.

There is a constraint on the PRODUCTS table with ENABLE, NOVALIDATE, and RELY attributes.
No updates have been done to SALES, CUSTOMERS, or PRODUCTS since the MV was created.
From where are rows returned and why?

A. from the SALES_EVAL MV because the WHERE clause in the query and in the SALES_EVAL definition are the same

B. from the SALES, CUSTOMERS, and PRODUCTS tables because QUERY_REWRITE_INTEGRITY is set to TRUSTED

C. from the SALES, CUSTOMERS, and PRODUCTS tables because the columns used in the SELECT list are different from the SALES_EVAL MV definition

D. from the SALES, CUSTOMERS, and PRODUCTS tables because the column in the GROUP BY clause is different from the SALES_EVAL MV definition

E. from the SALES_EVAL MV because the QUERY_REWRITE_ENABLED setting permits rewrites on unverified constraints if the table is not stale

Discussion 0

Correct Answer: A Vote an answer

Question #8

In which three situations would you recommend DB Replay to be used? (Choose three.)

A. to check the impact of partitioning a table

B. to check the impact of upgrading and patching databases

C. to check the impact of changing the storage system or the network

D. to check the impact of schema changes such as adding new indexes or materialized views

E. to check the impact of database migration to the cloud

F. to check the impact of new optimizer statistics

Discussion 0

Correct Answer: B,C,E Vote an answer

Free 1z1-074 Questions for Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 1z1-074 Exam as PDF & Practice Test Engine

Download Free Oracle 1z1-074 Demo