Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 41:

  View the Exhibit to examine the details for an incident.

  

  Which statement is true regarding the status of the incident?

  A. The DBA is working on the incident and prefers that the incident be kept in the ADR.
  B. The incident is now in the Done state and the ADR can select the incident to be purged.
  C. The incident has been newly created and is in the process of collecting diagnostic information.
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.

• Question 42:

  View the Exhibit exhibit1 to observe the maintenance window property.

  

  View the Exhibit exhibits to examine the output of the query. Which two statements describe the conclusions? (Choose two.)

  A. The window duration should be increased.
  B. RESOURCE_PERCENTAGE should be increased.
  C. RESOURCE_PERCENTAGE should be decreased.
  D. The repeat time for the window should be decreased.
  A. The window duration should be increased.
  B. RESOURCE_PERCENTAGE should be increased.

• Question 43:

  While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

  A. The plan baselines can be evolved over time to produce better performance
  B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
  C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
  D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
  A. The plan baselines can be evolved over time to produce better performance
  C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

• Question 44:

  You are managing Oracle Database 11 g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:

  ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;

  Which statement is true in this scenario?

  A. It starts the ASM fast mirror resync.
  B. It drops all disk paths from the dga disk group.
  C. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
  D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
  D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

• Question 45:

  View the Exhibit to examine the metrics with a threshold.

  

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

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

• Question 46:

  Which setting enables the baselines by default in Oracle Database 11g?

  A. setting the STATISTICS_LEVEL parameter to TYPICAL
  B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
  C. enabling Automated Maintenance Task using Oracle Enterprise Manager
  D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
  A. setting the STATISTICS_LEVEL parameter to TYPICAL

• Question 47:

  Which steps are mandatory to enable Direct NFS?

  1.

  Mount all required file systems using the kernel NFS driver.

  2.

  Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.

  3.

  Replace the ODM library libodm11 .so_stub with libodm11 .so.

  A. 2 and 3
  B. 1 and 3
  C. 1 and 2
  D. 1, 2 and 3
  B. 1 and 3

• Question 48:

  Which statement about the enabling of table compression in Oracle Database 11g is true?

  A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
  B. Compression can be enabled only at the table level for both direct loads and conventional DML.
  C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
  D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
  D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

• Question 49:

  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 value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.
  C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

• Question 50:

  View the Exhibit and examine the output.

  

  You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

  ALTER TABLE exchange_rate FLASHBACK ARCHIVE;

  What is the outcome of this command?

  A. The table uses the default Flashback Archive.
  B. The Flashback Archive is created on the SYSAUXtablespace.
  C. The Flashback Archive is created on the same tablespace where the tables are stored.
  D. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive-
  D. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive-