Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 451:

  In which cases is reference partitioning effective in enhancing performance?

  A. It is effective only in partition pruning.
  B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
  C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
  D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
  D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

• Question 452:

  View the Exhibit to examine the metrics with a threshold.

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

  Exhibit:

  

  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 453:

  Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th.

  A. Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
  B. Tell them that their request cannot be met with the current backup strategy.
  C. Restore the 19ths backup, apply the online redo logs, and open the database.
  D. Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
  E. Use the recover database command to roll back the database from today to the 19th of the month.
  B. Tell them that their request cannot be met with the current backup strategy.

• Question 454:

  A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following Error message:

  

  Which is the recommended sequence of operations you need to perform for the query successfully?

  A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
  B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
  C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
  D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
  C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

• Question 455:

  You want to use RMAN to create compressed backups.

  Which statement is true about the compression algorithms that RMAN can use?

  A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
  B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
  C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
  D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
  A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.

• Question 456:

  For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory management features?

  A. Automatic PGA Memory Management
  B. Automatic SGA Memory Management
  C. Automatic Shared Memory Management
  D. Automatic Memory Management
  E. Manual SGA Memory Management
  F. None of the above
  D. Automatic Memory Management

• Question 457:

  You want to disable resumable space allocation for all sessions.

  Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

  B. 10
  C. 100
  D. NULL
  A

• Question 458:

  Which statement about Automatic Memory Management with Oracle 11g is true?

  A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
  B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
  C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
  D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
  B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

• Question 459:

  On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

  A. fixed tables
  B. heap tables
  C. external tables
  D. temporary tables
  E. Index-Organized Tables (IOTs)
  F. views
  B. heap tables
  E. Index-Organized Tables (IOTs)

• Question 460:

  Which NLS parameter directly governs linguistic searches?

  A. NLS_SEARCH_L
  B. NLS_SORT
  C. NLS_SEARCH
  D. NLS_SORT_L
  E. None of the above
  B. NLS_SORT