[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-034 Dumps with VCE and PDF Download 61-70

Latesttests 2018 Jan Oracle Official New Released 1z0-034
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-034.html

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

Question No: 61

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?

  1. Run Segment Advisor.

  2. Run the SQL Tuning Advisor (STA).

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

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

Answer: D

Question No: 62

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?

  1. Perform Export before TSPITR and Import after TSPITR

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

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

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

Answer: A

Question No: 63

View the following SQL statements: Transaction T1

SQLgt; INSERT INTO hr.regions 2 VALUES (5,#39;Pole#39;);

3 COMMIT;

Transaction T2

SQLgt; UPDATE hr.regions 2 SET region_name=#39;Poles#39;

  1. WHERE region_id = 5;

  2. COMMIT;

Transaction T3

SQLgt; UPDATE hr.regions

2 SET region_name=#39;North and South Poles#39; 3 WHERE region_id = 5;

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

  1. It is possible, but transaction T3 also backs out.

  2. It is possible with the NOCASCADE_FORCE option.

  3. It is possible with the NONCONFLICT_ONLY option.

  4. It is not possible because it has conflicts with transaction T3.

Answer: B Explanation:

Table 12-2 Flashback TRANSACTION_BACKOUT Options

CASCADE

Backs out specified transactions and all dependent transactions in a post-order fashion (that is, children arebacked out before parents are backed out).

Without CASCADE, if any dependent transaction is not specified, an error occurs.

NOCASCADE

Default. Backs out specified transactions, which are expected to have no dependent transactions. Firstdependent transactions causes an error and appears in

*_FLASHBACK_TXN_REPORT.

NOCASCADE_FORCE

Backs out specified transactions, ignoring dependent transactions. Server runs undo SQL statements forspecified transactions in reverse order of commit times.If no constraints break and you are satisfied with the result, you can commit the changes; otherwise, you canroll them back.

NONCONFLICT_ONLY

Backs out changes to nonconflicting rows of the specified transactions. Database remains consistent, buttransaction atomicity is lost.

Question No: 64

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

  1. DICTIONARY

  2. DBA_TABLESPACES

  3. DBA_DIRECTORIES

  4. DBA_STORED_SETTINGS

  5. DATABASE_PROPERTIES

  6. DBA_TABLESPACE_GROUPS

Answer: E

Explanation: SQL*Plus: Release 10.2.0.1.0 – Production on Sat Feb 4 20:31:26 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQLgt; conn / as sysdba Connected.

SQLgt;desc DATABASE_PROPERTIES

Name Null? Type

——- — —- PROPERTY_NAME NOT NULL VARCHAR2(30)

PROPERTY_VALUE VARCHAR2(4000) DESCRIPTION VARCHAR2(4000)

SQLgt; SELECT PROPERTY_NAME, PROPERTY_VALUE 2 FROM DATABASE_PROPERTIES

3WHERE PROPERTY_NAME=’DEFAULT_PERMANENT_TABLESPACE; PROPERTY_NAME PROPERTY_VALUE

— —– DEFAULT_PERMANENT_TABLESPACE USERS

Question No: 65

You issued the following commands to configure settings in RMAN:

RMANgt; CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMANgt; CONFIGURE DEFAULT DEVICE TYPE TO Sbt;

RMANgt; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMANgt; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMANgt; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Then you issued the following command to take the backup: RMANgt; BACKUP DATABASE PLUS ARCHIVELOG;

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

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

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

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

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

Answer: D

Question No: 66

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?

  1. Opening the database in RESTRICTED mode

  2. Opening the database with the RESETLOGS option

  3. Setting a new DBID for the newly restored database

  4. Restoring the server parameter file (SPFILE) to the new host

Answer: B

Question No: 67

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:

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 packaged procedure.

Answer: A

Question No: 68

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 multisection backup.

Answer: C

Question No: 69

Which two statements are true about the duplexing of the backups taken by RMAN?

  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: 70

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

100% Free Download!
Download Free Demo:1z0-034 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-034 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE