Oracle OCP 1Z0-050（71-80题）解析

Oracle OCP 1Z0-050（71-80题）解析

QUESTION 71:

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

A. SQL Tuning Set

B. Cursor cache

C. Stored outline

D. Automatic Workload Repository (AWR) snapshots

Answer: A,B

https://docs.oracle.com/cd/E18283_01/server.112/e16638/optplanmgmt.htm#insertedID1

 

QUESTION 72:

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A. You can add or remove the trace files to the package.

B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

C. You can add SQL test cases to the incident package.

D. You cannot create an incremental incident package when the physical files are purged from the ADR.

Answer: A,B,C

 

QUESTION 73:

Exhibit:

View the Exhibit to examine the error during the database startup.

You open an RMAN session for the database instance. To repair the failure, you executed

the following as the first command in the RMAN session:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of the command?

A. The command performs the recovery and closes the failures.

B. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

C. The command only displays the advice and the RMAN script required for repair.

D. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

Answer: D

 

QUESTION 74:

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

A. ADR diagnostic files

B. PL/SQL functions, procedures, and packages

C. the table and index definitions and actual data

D. all the optimizer statistics

E. initialization parameter settings

Answer: C,D,E

 

QUESTION 75:

Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

A. Diagnose and repair failures on a standby database.

B. Recover from failures in the Real Application Cluster (RAC) environment.

C. Diagnose and repair a data file corruption online.

D. Diagnose and repair a data file corruption offline.

Answer: A,B

 

QUESTION 76:

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.

After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

A. The command produces an error because the retention time cannot be reduced.

B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data older than three years is purged from the flashback archive FLA1.

Answer: D

 

QUESTION 77:

Exhibit:

View the Exhibit to examine the replay settings for replay parameters.

What is the implication for setting the values for replay parameters? (Choose all that apply.)

A. The COMMIT order in the captured workload is preserved during replay.

B. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.

D. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.

Answer: A,B,C

 

QUESTION 78:

You issued the following command on the temporary tablespace LMTEMP in your database:

SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;

Which requirement must be fulfilled for this command to succeed?

A. The tablespace can remain as the default but must have no active sort operations.

B. The tablespace must be locally managed.

C. The tablespace must have only one temp file.

D. The tablespace must be made nondefault and offline.

Answer: B

 

QUESTION 79:

Which statement is true regarding the VALIDATE DATABASE command?

A. It checks the database for intrablock corruptions only.

B. It checks for block corruption in the valid backups of the database.

C. It checks the database for both intrablock and interblock corruptions.

D. It checks for only those corrupted blocks that are associated with data files.

Answer: A

 

QUESTION 80:

Exhibit:

View the Exhibit that sets the threshold for the Current Open Cursors Count metric.

Why is the Significance Level threshold type not available in the threshold setting?

A. because the STATISTICS_LEVEL parameter is set to BASIC

B. because the AWR baseline is a system-defined moving window baseline

C. because AWR baseline is not enabled

D. because Current Open Cursors Count is not a basic metric

Answer: D