Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 51:

  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;

  Correct Answer: B

• Question 52:

  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

  Correct Answer: D

• Question 53:

  Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

  

  A. Implement RMAN multiplexing

  B. Set the DEBUG ON in the RMAN script

  C. Specify the command ID in the RMAN script

  D. Use a tag with the RMAN BACKUP command

  Correct Answer: C

• Question 54:

  Which two statements are true regarding hot patching? (Choose two.)

  A. It requires relinking of the Oracle binary.

  B. It does not require database instance shutdown.

  C. It can detect conflicts between two online patches.

  D. It is available for installing all patches on all platforms.

  E. It works only in a single database instance environment.

  Correct Answer: BC

• Question 55:

  In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. 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 data file by using the image copy.

  Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?

  A. using only the RMAN SWITCH command to set the new location for the data file

  B. placing the database in the MOUNT state for the restore and recovery operations.

  C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

  D. configuring two channels: one for the restore operation and the other for the recovery operation

  Correct Answer: C

• Question 56:

  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.

  Correct Answer: D

• Question 57:

  In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

  

  Which statement is true about the outcome?

  A. Only one channel is allocated and the backup is created in the flash recovery area

  B. Only one channel is allocated and the backup is created in the destination specified for channel

  C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

  D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

  Correct Answer: A

• Question 58:

  You want to track and store all transactional changes to a table over its lifetime. To accomplish this task,

  you enabled Flashback Data Archive with the retention of 5 years. After some time, the business

  requirement changed and you were asked to change the retention from 5 years to 3 years.

  To accomplish this, you issued the following command:

  ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR; What is the implication of this

  command?

  A. The command produces an error because the retention time cannot be reduced.

  B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

  C. All historical data is purged and the new flashback data archives are maintained for three years.

  D. All historical data older than three years is purged from the flashback archive FLA1.

  Correct Answer: D

• Question 59:

  Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

  Which two actions will permit the TSPITR to work? (Choose two.)

  A. Taking the MASTERTBS tablespace offline

  B. Dropping the relationship between the tables

  C. Adding the MASTERTBS tablespace to the recovery set

  D. Putting the MASTERTBS tablespace in read-only mode

  Correct Answer: BC

• Question 60:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data.

  Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations.

  B. The data remains encrypted when it is read into memory.

  C. The data remains encrypted when it is stored in the redo logs.

  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

  Correct Answer: C