Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 11:

  Consider the following scenario for your database:

  Backup optimization is enabled in RMAN.

  The recovery window is set to 7 days in RMAN.

  The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.

  The TOOLS tablespace is read-only since November 4, 2007.

  On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

  A. The RMAN backup fails because the TOOLS tablespace is read-only
  B. The RMAN skips the backup of the tablespace because backup optimization is enabled
  C. The RMAN makes backup because optimization can be enabled only for backups to disk
  D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window
  D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

• Question 12:

  View the following SQL statements: Transaction T1

  SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;

  Transaction T2

  SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;

  Transaction T3

  SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;

  You want to back out transaction T2. Which option would you use?

  A. It is possible, but transaction T3 also backs out.
  B. It is possible with the NOCASCADE_FORCE option.
  C. It is possible with the NONCONFLICT_ONLY option.
  D. It is not possible because it has conflicts with transaction T3.
  B. It is possible with the NOCASCADE_FORCE option.

• Question 13:

  You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 14:

  You executed the following command In Recovery Manager {RMAN):

  RMAN>REPORTNEEDBACKUPdays 3;

  What is the output of this command?

  A. a list of files that require a backup within three days
  B. a list of files requiring more than 3 days of archive logs to apply
  C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
  D. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them
  B. a list of files requiring more than 3 days of archive logs to apply

• Question 15:

  Examine the following set of RMAN commands:

  RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*; RKAN>RUN {

  ALLOCATECHANNELchlDEVICETYPEDISK;

  EXECUTESCRIPTfull_backup;

  }

  Which statement is true when the RMAN run block is executed?

  A. The execution of the script fails because multiple channels cannot coexist.
  B. The script is executed and both the channels are used for the script execution.
  C. The new channel, CH1, is ignored because a channel has been configured already.
  D. The persistent configuration parameter DC1 is overridden because a new channel is allocated in the RMAN run block.
  D. The persistent configuration parameter DC1 is overridden because a new channel is allocated in the RMAN run block.

• Question 16:

  Identify two correct statements about the Active Session History (ASH) data.

  A. A part of SGA memory is used to store ASH data as rolling buffer.
  B. The ASH data can be analyzed between any two small time intervals.
  C. All ASH data in memory are flushed to disk by MMON in every 3 seconds.
  D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
  A. A part of SGA memory is used to store ASH data as rolling buffer.
  B. The ASH data can be analyzed between any two small time intervals.

• Question 17:

  View the Exhibit.

  

  You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files using the External Table Population method.

  You execute the command shown on the exhibit, but only two files have been created.

  Which parameter must be changed so that four files are created?

  A. TYPE
  B. LOCATION
  C. PARALLEL
  D. DEFAULT DIRECTORY
  E. ORGANIZATION EXTERNAL
  C. PARALLEL

• Question 18:

  In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.

  Which method must you use to recover the lost data?

  A. Complete Recovery with online redo log
  B. Complete Recovery with archived redo log
  C. Tablespace Point-in-Time Recovery (TSPITR)
  D. Incomplete Recovery with system change number (SCN)
  C. Tablespace Point-in-Time Recovery (TSPITR)

• Question 19:

  You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.

  From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

  A. The EVEN parameter was not set.
  B. The SQL_TRACE parameter is set to FALSE.
  C. Enterprise Manager is not used.
  D. The STATISTICS_LEVEL parameter is set to BASIC.
  E. The TIMED_STATISTICS parameter is set to FALSE.
  D. The STATISTICS_LEVEL parameter is set to BASIC.

• Question 20:

  After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?

  A. Opening the database in RESTRICTED mode
  B. Opening the database with the RESETLOGS option
  C. Setting a new DBID for the newly restored database
  D. Restoring the server parameter file (SPFILE) to the new host
  B. Opening the database with the RESETLOGS option