Oracle Oracle Certifications 1Z0-034 Questions & Answers

• Question 81:

  Examine the following command for RMAN backup:

  RMAN> 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 'ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement is true regarding the approach in the command?

  A. The RMAN multiplexing level is 4.

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

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

  D. It is an implementation of a multisection backup.

  Correct Answer: C

• Question 82:

  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

  Correct Answer: B

• Question 83:

  You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database

  .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery

  catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes

  the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN

  executables:

  RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1; Then you issue the following

  commands:

  RMAN> CONNECT CATALOG vpc1/oracle@catdb;

  RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"

  What is the outcome of the above commands?

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

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

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

  D. They produce an error because you need to connect to the target database to execute this packaged procedure.

  Correct Answer: A

• Question 84:

  Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

  A. DICTIONARY

  B. DBA_TABLESPACES

  C. DBA_DIRECTORIES

  D. DBA_STORED_SETTINGS

  E. DATABASE_PROPERTIES

  F. DBA_TABLESPACE_GROUPS

  Correct Answer: E

• Question 85:

  You issued the following commands to configure settings in RMAN:

  RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE

  ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE

  BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

  Then you issued the following command to take the backup:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which statement is true about the execution of the above command?

  A. The backup will terminate because the FORMAT clause was not configured for the channel

  B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

  C. It backs up the data files and archived log files to disk, making two copies of each data file and archived logfile

  D. It backs up the data files and archived log files to tape, making two copies of each data file and archived logfile

  Correct Answer: D

• Question 86:

  Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?

  A. Perform Export before TSPITR and Import after TSPITR

  B. Move objects to another schema that has the same tablespace assigned

  C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

  D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

  Correct Answer: A

• Question 87:

  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.

  Correct Answer: B

• Question 88:

  You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.

  What action must you take to achieve this?

  A. Run Segment Advisor.

  B. Run the SQL Tuning Advisor (STA).

  C. Run the Automatic Workload Repository (AWR) report.

  D. Run the SQL Access Advisor with a hypothetical workload.

  Correct Answer: D

• Question 89:

  Which two statements are true about encrypting RMAN backups?

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

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

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

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

  Correct Answer: AC

• Question 90:

  You executed the following commands:

  SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE

  DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');

  SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');

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

  above session?

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

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

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

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

  Correct Answer: A