1Z1-050 試験問題を無料オンラインアクセス

Which statements are true regarding the Query Result Cache? (Choose all that apply.)

• A.It is used only across statements in the same session.
• B.It can store the results from normal as well as flashback queries.
• C.It can be set at the system, session, or table level.
• D.It can store the results of queries based on normal, temporary, and dictionary tables.

Which two statements about workload capture and replay operations are true? (Choose two.)

• A.The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
• B.Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
• C.The clients must be created manually on the test machines to perform more realistic testing.
• D.Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

View the Exhibit to examine the metrics with a threshold.

Which statement is true regarding the Number of Transactions (per second) metric?

• A.The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
• B.Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
• C.The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
• D.Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.

You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

• A.The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
• B.The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
• C.The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
• D.The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1 /archive1
LOG_ARCHIVE_DEST_2 = 'SERVICE = Stdb1
DB_RECOVERY_FILE_DEST = 7u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;
Which statement is true regarding what this command accomplishes?

• A.All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
• B.All archived redo log files backed up at least once to tape are eligible for deletion.
• C.All archived redo log files backed up at least twice to tape are deleted.
• D.All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.