Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 531:

  How many different calendars does Oracle 11g support?

  A. 22
  B. 7
  C. 6
  D. 15
  E. 2
  B. 7

• Question 532:

  Which of the following is not a valid calendaring syntax element?

  A. FREQ
  B. BYHOUR
  C. RUNDATE
  D. INTERVAL
  E. BYMINUTE
  C. RUNDATE

• Question 533:

  Note the following parameters settings in your database:

  

  You issued the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

  What would happen?

  A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
  B. It will be successful only if the memory is available from the auto tuned components
  C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
  D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
  D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

• Question 534:

  Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?

  A. CREATE_MAPPING_PRIORITY
  B. SET_MAPPING_PRIORITY
  C. SET_MAPPING_ORDER
  D. PRIORITIZE_MAPPING_ORDER
  E. This functionality is not available through the DBMS_RESOURCE_MANAGER package.
  B. SET_MAPPING_PRIORITY

• Question 535:

  You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

  A. the SQL text
  B. the execution plan
  C. the execution context
  D. the execution frequency
  E. the system change number (SCN)
  A. the SQL text
  C. the execution context
  D. the execution frequency

• Question 536:

  You need to create a partitioned table to store historical data and you issued the following command:

  CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005', 'dd-mm-yyyy')), PARTITION p2 VALUES LESS THAN(TO_DATE('1-1- 2007', 'dd-mm-yyyy')) ) AS SELECT * FROM purchases WHERE time_id < TO_DATE('1-1-2007','dd-mm-yyyy');

  What is the outcome of the above command?

  A. It returns an error because the range partitions P1 and P2 should be of the same range.
  B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
  C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.
  D. It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.
  C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.

• Question 537:

  Which statements are true regarding table compression? (Choose all that apply.)

  A. It saves disk space and reduces memory usage.
  B. It saves disk space but has no effect on memory usage.
  C. It incurs extra CPU overhead during DML as well as direct loading operations.
  D. It incurs extra CPU overhead during DML but not direct loading operations.
  E. It requires uncompress operation during I/O.
  A. It saves disk space and reduces memory usage.
  C. It incurs extra CPU overhead during DML as well as direct loading operations.

• Question 538:

  Which three functions are performed by the SQL Tuning Advisor? (Choose three.)

  A. Building the SQL profile
  B. Recommending optimization of materialized views
  C. Checking query objects for missing and stale statistics
  D. Recommending bitmap, function-based, and B-tree indexes
  E. Recommending restructuring SQL queries that are using bad plans
  A. Building the SQL profile
  C. Checking query objects for missing and stale statistics
  E. Recommending restructuring SQL queries that are using bad plans

• Question 539:

  AUM (Automatic UNDO Management) has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo.

  What is the problem? (Choose the best answer.)

  A. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
  B. You need to increase the size of the undo tablespace.
  C. The undo tablespace is not set to auto-extend.
  D. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
  C. The undo tablespace is not set to auto-extend.

• Question 540:

  You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

  A. You are backing up to tape and your tape device performs its own compression.
  B. You are making image copies, and you have not enabled tablespace compression.
  C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk- based backup destinations are limited.
  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
  C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk- based backup destinations are limited.
  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.