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

Latesttests 2018 Jan Oracle Official New Released 1z0-034
100% Free Download! 100% Pass Guaranteed!

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

Question No: 101

SQLgt; SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS

——– 704


Table altered.

SQLgt; SELECT blocks FROM user_segments WHERE segment_name=*ALTB*; BLOCKS

————- 704

View the Exhibit and examine the output and commands executed on the ALTB table. Why does the number of blocks for the table remain the same after the shrink operation?

  1. because the table did not contain migrated or chained rows

  2. because the row IDs remain the same for all rows during the shrink operation

  3. because the progress of the shrink operation is not saved in the bitmap blocks of the table

  4. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation

Answer: D

Question No: 102

You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

  1. Mount the database

  2. Open the database in NORMAL mode

  3. Open the database in RESTRICTED mode

  4. Open the database with the RESETLOGS option

Answer: A Explanation:

After restoring the control file, it is time to load the restored control file onto the database instance, to issue STARTUP MOUNT command to load it.

Question No: 103

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?

  1. You must shut down the database instance to perform the backups.

  2. You must configure the flash recovery area (fast recovery area) for the database.

  3. You can perform complete database backups without closing the database.

  4. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.

Answer: C,D

Question No: 104

Identify two correct statements about the Active Session History (ASH) data.

  1. A part of SGA memory is used to store ASH data as rolling buffer.

  2. The ASH data can be analyzed between any two small time intervals.

  3. All ASH data in memory are flushed to disk by MMON in every 3 seconds.

  4. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

Answer: A,B

Question No: 105

Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).

  1. You can use RMAN stored scripts.

  2. Recovery is faster if data is stored in catalog in addition to the control file.

  3. You can store backup information of all registered databases in one place.

  4. Database backups are automatically deleted when they are older than the specified time period.

Answer: A,C


Question No: 106

View the Exhibit and examine the steps that you executed to create a database resource plan.

Subsequently, you execute the following procedure which results in an error: SQLgt; EXECUTE dbms_resources_manager.validate_pending_area ( );

What could be the reason?

Latesttests 2018 PDF and VCE

  1. The pending area is automatically submitted after the plan creation

  2. The procedure must be executed before creating the resources plan directive

  3. The SYS_GROUP resource consumer group is not included in the resource plan directive

  4. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

Answer: D

Question No: 107

Identify three key features of Oracle Data Pump (Choose three.)

  1. Data Pump can stop a running job and resume it later

  2. Data Pump can perform import using database link

  3. Data Pump uses absolute path instead of relative path

  4. Data Pump uses relative path instead of absolute path

  5. Data Pump can perform incremental and cumulative exports

Answer: A,B,D

Question No: 108

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.

Which of these methods would you use to achieve this? (Choose all that apply.)

  1. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

  2. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

  3. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

  4. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

Answer: B,C,D Explanation: Purpose

The md_restore command restores disk groups from a metadata backup file.

Syntax and Description

md_restore backup_file [-silent]

[-full|-nodg|-newdg -o #39;old_diskgroup:new_diskgroup [,…]#39;] [-S sql_script_file] [-G #39;diskgroup [,diskgroup…]#39;]


Reads the metadata information from backup_file.


Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.


Specifies to create a disk group and restore metadata.


Specifies to restore metadata only.

-newdg -o old_diskgroup:new_diskgroup]

Specifies to create a disk group with a different name when restoring metadata. The -o option is required with


-S sql_script_file

Write SQL commands to the specified SQL script file instead of executing the commands.

-G diskgroup

Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.

Question No: 109

Which statement is true about a Scheduler-generated event?

  1. It can be generated when a file arrives on the file system.

  2. it indicates state changes that occur within the Scheduler itself.

  3. it is raised by an application that is consumed by the Scheduler to start a job.

  4. it requires jobs to be defined with an event condition and a queue specification.

    Answer: D Explanation:

    Consuming Job State Events with your Application

    To consume job state events, your application must subscribe to the Scheduler event queue

    SYS.SCHEDULER$_EVENT_QUEUE. This queue is a secure queue and is owned by SYS. To create a subscription to this queue for a user, do the following:

    1. Log in to the database as the SYS user or as a user with the MANAGE ANY QUEUE privilege.

    2. Subscribe to the queue using a new or existing agent.

    3. Run the package procedure DBMS_AQADM.ENABLE_DB_ACCESS as follows: DBMS_AQADM.ENABLE_DB_ACCESS(agent_name, db_username); where agent_name references the agent that you used to subscribe to the events queue, and db_username is the user for whom you want to create a subscription.

      There is no need to grant dequeue privileges to the user. The dequeue privilege is granted on the Scheduler event queue to PUBLIC.

      Question No: 110

      Which three elements can a job chain process involve? (Choose three)

      1. an event

      2. a schedule

      3. a program

      4. another chain

      5. a lightweight job

Answer: B,D,E Explanation:

Don#39;t really understand the answer so far. Defining Chain Steps

After creating a chain object, you define one or more chain steps. Each step can point to one of the following:

->A Scheduler program object (program)

->Another chain (a nested chain)

->An event schedule, inline event, or file watcher

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
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE