Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 511:

  You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database.

  The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:

  1.

  Restore an autobackup of the server parameter file.

  2.

  Restore the control file

  3.

  Start the target database instance

  4.

  Mount the database

  5.

  Restore the data files

  6.

  Open the database with RESETLOGS option

  7.

  Recover the data files

  8.

  Set DBID for the target database

  Which option illustrates the correct sequence that you must use?

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

• Question 512:

  Which of the following methods can be used to detect block corruption?

  A. ANALYZE operations
  B. dbv
  C. SQL queries that access the potentially corrupt block
  D. RMAN
  E. All of the above
  E. All of the above

• Question 513:

  You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.

  SQL> startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes

  Redo Buffers 2514944 bytes

  Database mounted.

  ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3

  ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02.log' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3

  SQL> alter database clear logfile group 2;

  alter database clear logfile group 2 * ERROR at line 1:

  ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1:

  '/oracle01/oradata/orcl/redo02.log' ORA-00312: online log 2 thread 1: '/oracle01/oradata/orcl/redo02a.log'

  What steps must you take to resolve the error?

  a: Issue the recover database redo logs command.

  b: Issue the Startup Mount command to mount the database.

  c: Restore the last full database backup.

  d: Perform a point-in-time recovery, applying all archived redo logs that are available.

  e: Restore all archived redo logs generated during and after the last full database backup.

  f: Open the database using the alter database open resetlogs command.

  g:

  Issue the alter database open command.

  A. b, a, f
  B. e, b, a, f
  C. e, b, a, g
  D. b, a, g
  E. c, e, b, d, f
  E. c, e, b, d, f

• Question 514:

  Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)

  A. multiplexing of the control file
  B. adding the redo log member to the database
  C. database and operating system upgrades
  D. changing the database storage to ASM-managed storage
  C. database and operating system upgrades
  D. changing the database storage to ASM-managed storage

• Question 515:

  Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?

  A. Configure backup optimization
  B. Configure the channel to increase MAXOPENFILES
  C. Configure the channel to increase the capacity with the RATE parameter
  D. Configure the channel to adjust the tape buffer size with the BLKSIZE option
  C. Configure the channel to increase the capacity with the RATE parameter

• Question 516:

  When you are performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)

  A. The SYSTEM tablespace.
  B. The UNDO tablespace.
  C. All tablespaces with tables.
  D. All tablespaces with indexes.
  E. No tablespaces are automatically restored.
  A. The SYSTEM tablespace.
  B. The UNDO tablespace.

• Question 517:

  An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:

  SQL>CREATE INDEX ord_custname_ix ON orders (custname);

  The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to

  perform this test.

  Which is the most efficient method of performing this task?

  A. disabling the index
  B. making the index invisible
  C. making the index unusable
  D. using the MONITORING USAGE clause for the index
  B. making the index invisible

• Question 518:

  Note the following parameter settings: Which setting is NOT allowed?

  

  A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
  B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
  C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
  D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
  B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

• Question 519:

  Archived redo logs can be copied to more than one destination by Oracle.

  A. True
  B. False
  A. True

• Question 520:

  Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?

  A. NLS_SORT = BINARY
  B. NLS_SORT = BINARY_AI
  C. NLS_SORT = BINARY_CI
  D. NLS_SORT = BINARY_AI_CI
  E. Binary sorts are case insensitive and accent insensitive by default.
  B. NLS_SORT = BINARY_AI