1z0-034 | Far out Oracle 1z0-034 examcollection


Q41. View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session: 

RMAN> BACKUP DATABASE FILESPERSET 2; 

The database has seven data files. Why is the value of %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77? 

A. Because the progress is reported for each data file 

B. Because the progress is reported for each backup set 

C. Because other RMAN sessions have issued the same BACKUP command 

D. Because new data files have been added to the database while the RMAN backup is in progress 

Answer:

Q42. During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation? 

A. The installation terminates with an error. 

B. The installation proceeds with the default value without warnings and errors. 

C. The installation proceeds with the default value but it would not be an OFA-compliant database. 

D. The installation proceeds with the default value but a message would be generated in the alert log file. 

Answer:

Q43. You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery? 

A. Mount the database 

B. Open the database in NORMAL mode 

C. Open the database in RESTRICTED mode 

D. Open the database with the RESETLOGS option 

Answer:

After restoring the control file, it is time to load the restored control file onto the database instance, to issue STARTUP MOUNT command to load it. 

Q44. You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk. 

Proactively, which two options could you use to make more space available in the flash recovery [Choose two] 

A. Change the RMAN archived log deletion policy. 

B. Use the RMAN CROSSCHECK command to reclaim the archived log space. 

C. Change the RMAN retention policy to retain backups for a shorter period of time. 

D. Use OS command to move files from the flash recovery area to some other location 

Answer: B,D 

Q45. 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; 

Answer:

Q46. View the Exhibit to observe the error. 

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance. 

What can you do to reduce the chance of this error in the future? 

A. Increase the value of SGA_MAX_SIZE 

B. Enable automatic memory management 

C. Set the PRE_PAGE_SGA parameter to true 

D. Lock the System Global Area (SGA) in memory 

Answer:

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string") Cause: More shared memory is needed than was allocated in the shared pool or Streams pool. Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin largepackages, reduce your use of shared memory, or increase the amount of available shared memory byincreasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE andSHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameterLARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase theinitialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE. 

Q47. Given below is a list of scenarios: 

1) A user terminates his session abnormally. 

2) The connection between the server and the client application terminates because of a network failure. 

3) A schema is accidentally dropped. 

4) The tablespace is accidentally dropped from the database. 

5) The hard disk gets corrupted and the data files in the disk are lost. 

6) The database instance abnormally shuts down because of power failure. 

Which scenarios require DBA intervention to perform recovery? 

A. 1, 3, and 6 

B. 4, 5, and 6 

C. 3, 4, and 5 

D. 1, 2, and 6 

Answer:

Q48. You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): 

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3; 

Identify the statement that correctly describes the implications of this command. 

A. when there are already three backups, for the fourth backup RMAN removes the oldest backup. 

B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete. 

C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups. 

D. when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup. 

Answer:

Configuring a Redundancy-Based Retention Policy The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command specifies how many full or level 0 backups of each data file and control file that RMAN should keep. If the number of full or level 0backups for a specific data file or control file exceeds the REDUNDANCY setting, then RMAN considers the extra backups as obsolete. The default retention policy is REDUNDANCY 1. As you produce more backups, RMAN keeps track of which ones to retain and which are obsolete. RMAN retains all archived logs and incremental backups that are needed to recover the non obsolete backups. Assume that you make a full backup of data file 7 on Monday, Tuesday, Wednesday, and Thursday. You now have four full backups of this data file. If REDUNDANCY is 2, then the Monday and Tuesday backups are obsolete. If you make another backup on Friday, then the Wednesday backup of data file 7 becomes obsolete. Assume a different case in which REDUNDANCY is 1. You run a level 0 database backup at noon on Monday, a level 1 cumulative backup at noon on Tuesday and Wednesday, and a level 0 backup at noon on Thursday. Immediately after each daily backup you run the command DELETE OBSOLETE. The Wednesday DELETE command does not remove the Tuesday level 1 backup because this backup is not redundant: the Tuesday level 1 backup could be used to recover the Monday level 0 backup to a time between noon on Tuesday and noon on Wednesday. However, the DELETE command on Thursday removes the previous level 0 and level 1backups. Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the following example: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; 

Q49. The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal 

FROM emp 

AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) 

WHERE ename = 'ALLEN' 

What are the minimum requirements for the statement to execute successfully? (Choose all that apply) 

A. ARCHIVELOG mode must be enabled 

B. Row Movement must be enabled for the table 

C. FLASHBACK must be set to ON for the database 

D. The UNDO_MANAGEMENT parameter must be set to AUTO 

E. The UNDO_RETENTION parameter must be set appropriately 

Answer: D,E 

Q50. Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.) 

A. It's only supported for the backups performed on the tape 

B. It is not supported for backup operations that produce image copies 

C. Duplex backups need a parallelism for the device to be equal to number of copies 

D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously 

Answer: B,D