[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-034 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-034
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-034.html

Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Question No: 51

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grantprivileges to a new user VPC1 using Oracle Database 11g RMAN executables:

RMANgt; GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;

Then you issue the following commands:

RMANgt; CONNECT CATALOG vpc1/oracle@catdb;

RMANgt; SQL quot;EXEC catowner.dbms_rcvcat.create_virtual_catalog;quot; What is the outcome of the above commands?

  1. They execute and create a virtual catalog for pre-Oracle 11g clients.

  2. They produce an error because PROD1 and PROD2 databases belong to the older version.

  3. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

  4. They produce an error because you need to connect to the target database to execute this packagedprocedure.

Answer: A

Question No: 52

Examine the following command for RMAN backup:

RMANgt; RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP

INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3);

SQL #39;ALTER SYSTEM ARCHIVE LOG CURRENT#39;;

}

Which statement is true regarding the approach in the command?

  1. The RMAN multiplexing level is 4.

  2. It is the use of asynchronous I/O by RMAN.

  3. It is a case of parallelization of the backup set.

  4. It is an implementation of a multi section backup.

Answer: C

Question No: 53

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

  1. It#39;s only supported for the backups performed on the tape

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

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

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

Answer: B,D

Question No: 54

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

  1. Multiple change tracking files can be created for a database.

  2. The change tracking file must be created after the first level 0 backup.

  3. RMAN does not support backup and recovery of the change tracking file.

  4. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Answer: C,D

Question No: 55

For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?

  1. fixed tables

  2. heap tables

  3. external tables

  4. temporary tables

  5. Index-Organized Tables (IOTs)

  6. views

Answer: B,E

Question No: 56

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.

Which statement is true while performing a tape backup in an RMAN session?

  1. The tape I/O performed is asynchronous

  2. The tape buffer is allocated from the System Global Area (SGA)

  3. The tape buffer is allocated from the Program Global Area (PGA)

  4. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Answer: C Explanation: Tape I/O Slaves

RMAN allocates the tape buffers in the System Global Area (SGA) or the Program Global Area (PGA),depending on whether I/O slaves are used. If you set the initialization parameter

BACKUP_TAPE_IO_SLAVES=true, then RMAN allocates tape buffers from the SGA. Tape devices can only beaccessed by one process at a time, so RMAN starts as many slaves as necessary for the number of tapedevices. If the LARGE_POOL_SIZE initialization parameter is also set, then RMAN allocates buffers from thelarge pool. If you set BACKUP_TAPE_IO_SLAVES=false, then RMAN allocates the buffers from the PGA.

If you use I/O slaves, then set the LARGE_POOL_SIZE initialization parameter to dedicate SGA memory toholding these large memory allocations. This parameter prevents RMAN I/O buffers from competing with thelibrary cache for SGA memory. If I/O slaves for tape I/O were requested but there is not enough space in theSGA for them, slaves are not used, and a message appears in the alert log.

The parameter BACKUP_TAPE_IO_SLAVES specifies whether RMAN uses slave processes rather than thenumber of slave processes. Tape devices can only be accessed by one process at a time, and RMAN uses thenumber of slaves necessary for the number of tape devices.

Question No: 57

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

  1. An upper limit on how far you can flash back the database, depending on the information in the redo logs

  2. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

  3. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

  4. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space

Answer: C

Question No: 58

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

  1. The backup as copy can only be taken to disk

  2. The backup as copy can only be taken to tape

  3. Backup can be performed only when the instance is shutdown

  4. Backup will constitute all used and unused blocks in the database

Answer: A,D

Question No: 59

You executed the following commands:

SQLgt; ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;

SQLgt; EXECUTE DBMS_STATS. SET_TABLE_PREFS(#39;SH#39;, #39;CUSTOMERS#39;, #39;PUBLISH#39;,

#39;false#39;);

SQLgt; EXECUTE DBMS_STATS. GATHER_TABLE_STATS (#39;SH#39; , #39;CUSTOMERS#39;);

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  1. The statistics are stored in the pending statistics table in the data dictionary.

  2. The statistics are treated as the current statistics by the optimizer for all sessions.

  3. The statistics are treated as the current statistics by the optimizer for the current sessions only.

  4. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A

Question No: 60

Which two statements are true about encrypting RMAN backups?

  1. The transparent encryption of backups uses the encryption wallet.

  2. The database uses the same encryption key for every encrypted backup.

  3. The password encryption of backups only uses the password while creating and restoring backups.

  4. If transparent encryption is configured, you cannot use the set encryption by password command to make password-protected backups.

Answer: A,C

100% Ensurepass Free Download!
Download Free Demo:1z0-034 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-034 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.