Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 41:

  Identify two operations for which the bkup_api utility can be used. (Choose two.)

  A. to define the retention period for backups

  B. to define which system files are backed up

  C. to define which database configuration files are backed up

  D. to define the cycle period for backups

  E. to define the frequency of automatic backups

  Correct Answer: AD

  Reference: https://docs.oracle.com/en/cloud/cloud-at-customer/exadata-cloud-at-customer/exacc/ customize-backup-configuration-using-bkup_api.html

• Question 42:

  You receive complaints about poor performance in an Oracle 12c database while long running queries execute. You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution. How would you achieve this?

  A. by viewing Active Reports for that time period

  B. by enabling SQL trace for each query

  C. by running the Automatic Workload Repository (AWR) report for that time period

  D. by running the Active Session History (ASH) report for that time period

  E. by enabling tracing for sessions that run these queries

  Correct Answer: E

  Reference: https://docs.oracle.com/database/121/TDPPT/tdppt_realtime.htm#TDPPT034

• Question 43:

  In which situation can the optimizer choose a hash join?

  A. when a non-equijoin is used and the join column in at least one of the tables is a primary key

  B. when a non-equijoin is used and the join column for both tables is a primary key

  C. when a non-equijoin is used between a table and a sorted hash cluster

  D. when an equality operator is used

  E. when any self-join is done

  Correct Answer: D

• Question 44:

  Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

  A. It changes Oracle kernel parameters if required

  B. It creates a restore point to restore the database if the upgrade fails

  C. It drops all the invalid objects

  D. It calls the catctl.pl script to perform the upgrade process in parallel

  E. It automatically resets the COMPATIBLE parameter value to 12.0.0

  F. It modifies or creates new tablespaces as required

  Correct Answer: BCD

• Question 45:

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

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

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

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

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

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

  Correct Answer: D

• Question 46:

  Examine this command:

  

  Which statement is true?

  A. Up to four worker processes are allocated to export data and metadata

  B. Four worker processes are allocated to export only data

  C. Four worker processes are active to export only metadata

  D. Four worker processes are allocated to export data and metadata

  E. Four worker processes are allocated when there is sufficient CPU available

  Correct Answer: D

  Reference: https://oracle-base.com/articles/10g/oracle-data-pump-10g

• Question 47:

  In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?

  A. when a user creates a new user

  B. when a user performs a GRANT or REVOKE operation

  C. when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure

  D. when a user runs a procedure created with invoker's right

  E. when a user runs a procedure created with definer's right

  Correct Answer: CD

  Reference: https://docs.oracle.com/database/121/DBSEG/dr_ir.htm#DBSEG661

• Question 48:

  Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

  A. The COMPATIBLE parameter must be set to 12.0 or greater.

  B. The database must be in ARCHIVELOG mode.

  C. FLASHBACK DATABASE must be enabled.

  D. RMAN must use a recovery catalog.

  E. The database must be in the READ WRITE state.

  F. RMAN can recover the table only from a backupset.

  G. An export dump file of the table must be available.

  H. There must be sufficient space to start the auxiliary instance.

  Correct Answer: ABEF

  Reference: https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV697

• Question 49:

  Identify a situation where performance profiles can be used for application containers.

  A. to specify the total number of parallel execution servers available

  B. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

  C. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

  D. to enforce a limit on the number of I/OS issued per second

  E. to enforce a limit on I/O throughput per second

  Correct Answer: A

• Question 50:

  In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.

  You recreate the password file:

  $ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5

  Examine the command and result:

  $ sqlplus u1/Oracle_4U@testdb as sysdba

  ERROR:

  ORA-01017: invalid username/password; logon denied

  What can you do to fix this error?

  A. Recreate the password file with the password set to Oracle_4U.

  B. Change the password of U1 to Oracle_123.

  C. Set the REMOTE_LOGIN_PASSWORDFILE parameter value to NONE.

  D. Regrant SYSDBA to U1.

  E. Restart the database instance.

  Correct Answer: A

  Reference: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:670117794561