Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 371:

  Which two statements are true about a job chain? (Choose two.)

  A. A job chain can contain a nested chain of jobs.
  B. The jobs in a job chain cannot have more than one dependency.
  C. A job of the CHAIN type can be run using event-based or time-based schedules.
  D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
  A. A job chain can contain a nested chain of jobs.
  C. A job of the CHAIN type can be run using event-based or time-based schedules.

• Question 372:

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

  To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?

  A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
  B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
  C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
  D. Either B or C.
  A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

• Question 374:

  As DBA for the Rebalance, you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately).

  Which of the following commands would create a disk group that would offer the maximum in data redundancy?

  

  A. B. C. D.
  C

• Question 375:

  When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk groups?

  A. TRANSACTIONAL
  B. IMMEDIATE
  C. ABORT
  D. NORMAL
  C. ABORT

• Question 376:

  You are managing Oracle Database 11g 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. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
  C. It drops all disk paths from the dga disk group.
  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 377:

  In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this:

  1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy

  Which two options illustrate the correct sequence of steps that you could follow? (Choose two.)

  A. 2, 6, 4, 5, 3
  B. 1, 2, 4, 5, 3, 6
  C. 1, 2, 4, 6, 3
  D. 1, 2, 7, 5, 3, 6
  B. 1, 2, 4, 5, 3, 6
  D. 1, 2, 7, 5, 3, 6

• Question 378:

  Which two statements are true about the compressed backups in RMAN? (Choose two.)

  A. Compressed backups can only be taken on the tape drives.
  B. The binary compression creates some performance overhead during backup operation.
  C. The ZLIB compression algorithm can be used only if the COMPATIBLE initialization parameter is set to 11.1.0.
  D. The media manager compression for the tape drive should be enabled for taking compressed backups on the tape.
  B. The binary compression creates some performance overhead during backup operation.
  D. The media manager compression for the tape drive should be enabled for taking compressed backups on the tape.

• Question 379:

  Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  A. failures because a data file is renamed by error
  B. failures when no standby database is configured
  C. failures that require no archive logs to be applied for recovery
  D. failures due to loss of connectivity-for example, an unplugged disk cable
  A. failures because a data file is renamed by error
  D. failures due to loss of connectivity-for example, an unplugged disk cable

• Question 380:

  You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8

  A. m. backup?
  B. Create a manual incremental online database backup.
  C. Back up all the archived redo logs generated since the 8 a.m. backup.
  D. Create a brand-new backup after all the changes have been applied.
  E. There is no way to make the changes recoverable based on the 8 a.m. backup.
  F. Perform an online backup of the tablespace(s) that contained changed data.
  B. Create a manual incremental online database backup.