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

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

Examine the following ALTER command:

SQLgt; ALTER DISKGROUP dgroup1 UNDROP DISKS;

What is the purpose of the command?

  1. It cancels all pending disk drops within the disk group.

  2. It adds previously dropped disks back into the disk group.

  3. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

  4. It mounts disks in the disk group for which the drop-disk operation has already been completed.

  5. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Answer: A

Question No: 42

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.

Which two statements are true?

  1. You must ensure that the SALES database is mounted or open.

  2. You must restore a backup control file to perform a block media recovery.

  3. You must take the tools01.dbf data file offline before you start a block media recovery.

  4. You must put the database in NOARCHIVELOG mode to perform a block media recovery.

  5. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

Answer: A,E

Question No: 43

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

  1. Only one nested subplan is allowed per parent plan

  2. The plans can be nested up to four levels.

  3. Nested plans only control resources used by recursive SQL

  4. Nested plans control only the degree of parallelism and I/O requests

  5. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

Answer: E

Question No: 44

There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?

  1. the DBNEWID utility

  2. the DBVERIFY utility

  3. the ANALYZE command

  4. the RMAN REPORT command

  5. the RMAN CROSSCHECK command

  6. the CHECK_OBJECT procedure of the DBMS_REPAIR package

Answer: B

Question No: 45

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.

Which statement is true in this situation?

  1. The online redo log files and archived redo log files are required to accomplish the recovery

  2. The uncommitted transaction will be committed at the next startup of the database instance

  3. The uncommitted transaction is rolled back automatically at the next opening of the database

  4. The DBA has to perform the recovery on the database to recover the uncommitted transaction

Answer: C

Question No: 46

You executed the following command In Recovery Manager {RMAN): RMANgt;REPORTNEEDBACKUPdays 3;

What is the output of this command?

  1. a list of files that require a backup within three days

  2. a list of files requiring more than 3 days of archive logs to apply

  3. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

  4. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them

Answer: B Explanation:

Using RMAN REPORT NEED BACKUP with Different Retention Policies (link)

You can specify different criteria for REPORT NEED BACKUP, using one of the following forms of the command:

REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS

Displays objects requiring backup to satisfy a recovery window-based retention policy REPORT NEED BACKUP REDUNDANCY n

Displays objects requiring backup to satisfy a redundancy-based retention policy REPORT NEED BACKUP DAYS n

Displays files that require more than n days#39; worth of archived redo log files for recovery REPORT NEED BACKUP INCREMENTAL n

Displays files that require application of more than n incremental backups for recovery

Question No: 47

Examine the parameter settings in your database.

Latesttests 2018 PDF and VCE

Which statement is correct about the database?

  1. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

  2. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

  3. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET andSGA_TARGET are set.

  4. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

Answer: D Explanation:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/memory.htm#47750

Configuring Automatic PGA Memory

When configuring a brand new instance, it is hard to know precisely the appropriate setting for PGA_AGGREGATE_TARGET. You can determine this setting in three stages:

Make a first estimate for PGA_AGGREGATE_TARGET, based on a rule of thumb. By default, Oracle uses 20% of the SGA size. However, this initial setting may be too low for a large DSS system.

Run a representative workload on the instance and monitor performance, using PGA statistics collected by Oracle, to see whether the maximum PGA size is under-configured or over-configured.

Tune PGA_AGGREGATE_TARGET, using Oracle PGA advice statistics.

Question No: 48

memory_target big integer 808M pga_aggregate_target big integer 0 sga_target big integer 0

SQLgt; SHOW PARAMETER SGA_MAX_SIZE

NAME TYPE VALUE

————————————————-

sga_max_size big integer 808M

Which statement is correct about the database?

  1. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

  2. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and

  3. SGA_TARGET are set.

  4. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

  5. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

Answer: E

Question No: 49

The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?

  1. The Oracle database will not perform block checking for any of the data blocks.

  2. The Oracle database will perform block checking for the default permanent tablespace

    only.

  3. The Oracle database will perform block checking for the data blocks in all user tablespaces.

  4. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

  5. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

    Answer: D

    Question No: 50

    As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.

    Which of the following steps are required to transport a tablespace from the database to the targetdatabase:

    1. Make the tablespace read-only at the source database.

    2. Export metadata from the source database.

    3. Convert data filed by using Recovery Manager (RMAN).

    4. Transfer the dump file and data filed to the target machine.

    5. Import metadata at the target database.

    6. Make the tablespace read/write at the target database. Exhibit:

      Latesttests 2018 PDF and VCE

      1. 2, 4, and 5

      2. All the steps C. 2, 3, 4 and 5 D. 1, 2, 4, 5 and 6

Answer: D Explanation:

Refer to here. Generate a Transportable Tablespace Set read_only-expdp-4-import-read_wrtie

1, 2, 4, 5, 6 (optional)

If both platforms have the same endianness, no conversion is necessary. Otherwise you must do aconversion of the tablespace set either at the source or destination database. Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to any otherdirectory of your choosing.

Run the following query to determine the location of DATA_PUMP_DIR: SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = #39;DATA_PUMP_DIR#39;;

Latesttests 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Transport the data files to the location of the existing data files of the destination database. On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or

DISKGROUP/SID/datafile/.

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