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

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

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

Ensurepass 2018 PDF and VCE

Which statement is true about the outcome?

  1. Only one channel is allocated and the backup is created in the flash recovery area

  2. Only one channel is allocated and the backup is created in the destination specified for channel

  3. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

  4. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

Answer: A

Question No: 92

You want to track and store all transactional changes to a table over its lifetime.

To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.

After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.

To accomplish this, you issued the following command:

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

  1. The command produces an error because the retention time cannot be reduced.

  2. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

  3. All historical data is purged and the new flashback data archives are maintained for three years.

  4. All historical data older than three years is purged from the flashback archive FLA1.

Answer: D

Question No: 93

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.

From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

  1. The EVEN parameter was not set.

  2. The SQL_TRACE parameter is set to FALSE.

  3. Enterprise Manager is not used.

  4. The STATISTICS_LEVEL parameter is set to BASIC.

  5. The TIMED_STATISTICS parameter is set to FALSE.

Answer: D

Question No: 94

Which two statements are true regarding hot patching? (Choose two.)

  1. It requires relinking of the Oracle binary.

  2. It does not require database instance shutdown.

  3. It can detect conflicts between two online patches.

  4. It is available for installing all patches on all platforms.

  5. It works only in a single database instance environment.

Answer: B,C Explanation:

Online Patching

Regular patches typically contain .o (object) files and/or .a (archive) libraries, and therefore require a relink of the RDBMS binary. Online patches, however, contain .so files, which are dynamic/shared libraries, and do not require a relink of the RDBMS binary. Consequently, since a relink is not needed, you can apply or roll back online patches while the RDBMS instance is running. This simplifies administration, because no downtime is needed, and also results in a much quicker turnaround time for installing or de-installing Online Patches.

A regular RDBMS patch can require many minutes to install, since it requires instance shutdown, a relink, and instance startup. On the other hand, you can install an online patch in just a few seconds.

Online patches are only applicable for Oracle RDBMS and not any other products. Online patches are currently supported on the following Windows and UNIX platforms for version

11.2.0.1.0 and later:

->Linux x86

->Linux x86_64

->HP-UX Itanium

->Solaris SPARC 64-bit

->Solaris AMD 64-bit

->AIX (AIX 6.1 and later)

About Patch Conflicts:

All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a conflict.

Question No: 95

In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy.

Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?

  1. using only the RMAN SWITCH command to set the new location for the data file

  2. placing the database in the MOUNT state for the restore and recovery operations.

  3. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

  4. configuring two channels: one for the restore operation and the other for the recovery operation

Answer: C

Question No: 96

Consider the following scenario for your database:

->Backup optimization is enabled in RMAN.

->The recovery window is set to 7 days in RMAN.

->The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.

->The TOOLS tablespace is read-only since November 4, 2007.

On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

  1. The RMAN backup fails because the TOOLS tablespace is read-only

  2. The RMAN skips the backup of the tablespace because backup optimization is enabled

  3. The RMAN makes backup because optimization can be enabled only for backups to disk

  4. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Answer: D

Question No: 97

Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

Ensurepass 2018 PDF and VCE

  1. Implement RMAN multiplexing

  2. Set the DEBUG ON in the RMAN script

  3. Specify the command ID in the RMAN script

  4. Use a tag with the RMAN BACKUP command

Answer: C

Question No: 98

Note the following parameter settings: Which setting is NOT allowed?

  1. ALTER SYSTEM SET DB_CACHE_SIZE=50M;

  2. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

  3. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;

  4. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

Answer: B

Question No: 99

You created a tablespace with the following statement: CREATE BIGFILE TABLESPACE adtbs

DATAFILE #39;/probdb/data/adtbs.dbf#39; SIZE 10G;

There is now a requirement to increase the size of the tablespace.

Which two ALTER statements are correct in this scenario? (Choose two.)

  1. ALTER TABLESPACE adtbs RESIZE 20G;

  2. ALTER TABLESPACE adtbs ADD DATAFILE;

  3. ALTER TABLESPACE adtbs AUTOEXTEND ON;

  4. ALTER TABLESPACE adtbs ADD DATAFILE#39;/proddb/data/adtbs1.dbf#39; SIZE 10G;

  5. ALTER TABLESPACE adtbs MODIFY DATAFILE #39;/proddb/data/adtbs.dbf#39; AUTOEXTEND ON;

Answer: A,C Explanation: C:\sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 – Production on Sat Jan 28 20:34:23 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQLgt; conn / as sysdba Connected.

SQLgt; CREATE BIGFILE TABLESPACE adtbs

DATAFILE#39;C:\adtbs.dbf#39; SIZE 1G; Tablespace created.

(A)

SQLgt; ALTER TABLESPACE adtbs RESIZE 2G

Tablespace altered.

(B) and (D)

SQLgt; ALTER TABLESPACE adtbs ADD DATAFILE#39;C:\adtbs.dbf#39; SIZE 1G; ALTER TABLESPACE adtbs ADD DATAFILE #39;C:\adtbs.dbf#39; SIZE 1G

ERROR at line 1:

ORA-32771: cannot add file to bigfile tablespace (C)

SQLgt; ALTER TABLESPACE adtbs AUTOEXTEND ON;

Tablespace altered. (E)

SQLgt; ALTER TABLESPACE adtbs MODIFY DATAFILE #39;C:\adtbs.dbf#39; AUTOEXTEND ON; ALTER TABLESPACE adtbs MODIFY DATAFILE #39;C:\adtbs.dbf#39; AUTOEXTEND ON

ERROR at line 1:

ORA-02142: missing or invalid ALTER TABLESPACE option

Question No: 100

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

  1. Alert log file

  2. Archived redo log files

  3. Control file autobackups

  4. Server Parameter file (SPFILE)

  5. Recovery Manager (RMAN) backup piece

Answer: B,C,E

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.