Free Download 1z0-034 Examp Dump: Oracle.1z0-034.PracticeTest.2018-02-12.148q.vcex

File Info

Exam	Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Number	1z0-034
File Name	Oracle.1z0-034.PracticeTest.2018-02-12.148q.vcex
Size	4 MB
Posted	Feb 12, 2018
Download	Oracle.1z0-034.PracticeTest.2018-02-12.148q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%

Demo Questions

Question 1

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

The MTTR advisor will be disabled.
Automatic checkpoint tuning will be enabled.
The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.

Correct answer: BC

Question 2

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

DATE
TIMESTAMP
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
TIMESTAMP WITH LOCAL TIME ZONE

Correct answer: BE

Question 3

Which two statements are true regarding the functionality of the remap command in ASMCMD?

It repairs blocks that have read disk I/O errors.
It checks whether the alias metadata directory and the file directory are linked correctly.
It repairs blocks by always reading them from the mirror copy and writing them to the original location.
It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

Correct answer: AD

Question 4

What happens when you run the SQL Tuning Advisor with limited scope?

Access path analysis is not performed for SQL statements.
SQL structure analysis is not performed for SQL statements.
SQL Profile recommendations are not generated for SQL statements.
Staleness and absence of statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

Correct answer: C

Question 5

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)

setting the FAST_START_MTTR_TARGET to set the mean time to recover
setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.

Correct answer: CD

Question 6

Examine the following RMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which perquisite must be met before accomplishing the backup?

Provide a password for the encryption.
Set up an Oracle wallet for the encryption.
No setup is required as it is a default encryption method.
Both Oracle wallet and password must be set up for the encryption.

Correct answer: B

Explanation:

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmconfa.htmTo configure the environment so that all RMAN backups are encrypted:Set up the Oracle wallet as explained in Oracle Database Advanced Security Administrator’s Guide. Issue the following RMAN command:CONFIGURE ENCRYPTION FOR DATABASE ON; At this stage, all RMAN backup sets created by this database will use transparent encryption by default

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmconfa.htm

To configure the environment so that all RMAN backups are encrypted:

Set up the Oracle wallet as explained in Oracle Database Advanced Security Administrator’s Guide.

Issue the following RMAN command:

CONFIGURE ENCRYPTION FOR DATABASE ON;

At this stage, all RMAN backup sets created by this database will use transparent encryption by default

Question 7

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.

S expdp system/manager

Schemas =hr,oe

directory =EXP_ DIR

include = table

$ impdp system/manager

Schemas = hr1,oe1

Directory = EXP_DIR

Dumpfile = export.dat

Remap_schema =hr:hr1,oe :oe1

What would be achieved by running the above commands?

expdp will fail because no path has been defined for the dumpfile.
expdp will succeed but Impdp will fail because users do not exist.
impdp will create two users called hrl and oe1 and import all objects to the new schemas
impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.

Correct answer: B

Question 8

The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?

Control files
Password file
Inactive online redo log file
Archived log files required to perform recovery
Newly created tablespace which is not backed up

Correct answer: AD

Explanation:

The RESETLOGS options is required in:Imcomplete Recovery Change of control file So that, the control file and archived redo logs are required.

The RESETLOGS options is required in:

Imcomplete Recovery
Change of control file

So that, the control file and archived redo logs are required.

Question 9

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?

ALTER DATABASE FLASHBACK ON;
GRANT SELECT ANY TRANSACTION TO scott;
GRANT EXECUTE ON dbms_flashback TO scott;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER TABLESPACE undots1 RETENTION GUARANTEE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Correct answer: BCDF

Question 10

The DB_BLOCK_CHECKING parameter is set to FULL.

What checks occur each time the DBWnprocess(es) writes?

The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.
The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

Correct answer: A