Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 251:

  Which command creates an image copy?

  A. backup as copy
  B. backup copy
  C. copy as backup D. copy back
  A. backup as copy

• Question 252:

  You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:

  LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 =

  'LOCATION=/disk2/arch'

  LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch

  LOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch'

  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2

  While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.

  What happens in an event of log switch?

  A. The online redo log file is not allowed to be overwritten.
  B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
  C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
  D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
  D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

• Question 253:

  A database is running In ARCHIVELOG mode. It has two online redo log groups and each group has one member.

  A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the

  random order are as follow.

  1) Restore the corrupted redo log group.

  2) Restore from a whole database backup.

  3) Perform incomplete recovery.

  4) Relocate by renaming the member of the damaged online redo log group to a new location.

  5) Open the database with the RESETLOGS option.

  6) Restart the database instance.

  7) Issue a checkpoint and clear the log.

  Identify the option with the correct sequential steps to accomplish the task efficiently.

  A. 1, 3, 4, and 5
  B. 7, 3, 4. and 5
  C. 2, 3, 4, and 5
  D. 7, 4, 3. and 5
  E. Only 6 is required
  C. 2, 3, 4, and 5

• Question 254:

  Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

  A. It bypasses the OS file system cache.
  B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
  C. It uses the operating system kernel NFS layer for user tasks and network communication modules.
  D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
  A. It bypasses the OS file system cache.
  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

• Question 255:

  Which statement is true regarding virtual private catalogs?

  A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
  B. The virtual private catalog owner cannot create and modify the stored scripts.
  C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
  D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
  D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

• Question 256:

  A user receives the following error while performing a large volume of inserts into a table:

  ERROR at line 1:

  ORA-01536: space quota exceeded for tablespace 'USERS'

  The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user may perform such transaction in the future. You want to ensure that the command waits rather than produce an error when such an

  event occurs the next time.

  What can you do to achieve this before running the command in the future?

  A. Set RESUMABLE_TIMEOUT for the instance.
  B. Set the RESOURCE_LIMIT Parameter to TRUE.
  C. Enable the database instance to use asynchronous commit.
  D. Set the LOG_CHECKPOINT_TIMEOUT parameter to a nonzero value for the database instance.
  A. Set RESUMABLE_TIMEOUT for the instance.

• Question 257:

  The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application.

  Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?

  A. 20% SGA, 80% PGA
  B. 25% SGA, 75% PGA
  C. 50% SGA, 50% PGA
  D. 75% SGA, 25% PGA
  E. 80% SGA, 20% PGA
  E. 80% SGA, 20% PGA

• Question 258:

  Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

  A. Alert log file
  B. Archived redo log files
  C. Control file autobackups
  D. Server Parameter file (SPFILE)
  E. Recovery Manager (RMAN) backup piece
  B. Archived redo log files
  C. Control file autobackups
  E. Recovery Manager (RMAN) backup piece

• Question 259:

  You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline.

  The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile.

  Which statement is true when you accept the suggested SQL profile?

  A. The tuned plan is not added to the SQL plan baseline.
  B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
  C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
  D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
  C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

• Question 260:

  Which components are needed for successful and most efficient recovery.

  A. The backup RB3 and the current online redo log files
  B. the backup RB2 and the archived redo log files after the log sequence number 15622
  C. Backup R81 and the archived redo log hies after the log sequence number 12871
  D. The backup RB3 and the archived redo log files after the log sequence number 16721
  A. The backup RB3 and the current online redo log files