[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-034 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
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: 21

Which three statements are true about windows?

  1. Only one window can be open at any given time

  2. Consumer groups are associated with windows

  3. Windows work with job classes to control resource allocation

  4. The database service name must be provided during windows creation

  5. Windows can automatically start job or change resource allocation among jobs for various time periods.

    Answer: A,C,E

    Question No: 22

    Note the following statements that use flashback technology:

    1. FLASHBACK TABLE lt;tablegt; TO SCN lt;scngt;;

    2. SELECT * FROM lt;tablegt; AS OF SCN 123456;



    5. SELECT * FROM lt;tablegt; VERSIONS AS OF SCN 123456 AND 123999;

      Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

      1. 1, 2, and 5

      2. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5

Answer: A Explanation:

The BEFORE DROP clause uses Recycle Bin;

The FLASHBACK DATABASE uses flashback logs at FRA area.

Question No: 23

View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

SQLgt; startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

Why did the instance fail to start? Exhibit:

Ensurepass 2018 PDF and VCE

  1. Because the PGA_AGGREGATE_TARGET parameter is not set

  2. Because the STATISTICS_LEVEL parameter is set to BASIC

  3. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal

  4. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

Answer: B Explanation:

Setting SGA Target Size

You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to an on zero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of

individual components, which are now automatically and dynamically resized (tuned) as needed.


The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.

Question No: 24

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

  1. An ASM instance mounts an ASM control file

  2. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

  3. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

  4. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: C,D

Question No: 25

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.

Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

  1. Change the RMAN archived log deletion policy.

  2. Use the RMAN CROSSCHECK command to reclaim the archived log space.

  3. Change the RMAN retention policy to retain backups for a shorter period of time.

  4. Use OS command to move files from the flash recovery area to some other location

Answer: B,D

Question No: 26

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)





  5. ALTER DISKGROUP dgroupA ADD DISK #39;/devices/A*#39;;

Answer: A,C Explanation: Altering Disk Groups

You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTERDISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations. Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query theV$ASM_OPERATION view to monitor the status of this operation.


Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation.


Use this clause to drop one or more disks from the disk group. DROP DISK

The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.

Question No: 27

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT;

Why would you need this to be executed?

  1. Because row IDs may change during the flashback operation

  2. Because the object number changes after the flashback operation

  3. Because the rows are retrieved from the recycle bin during the flashback operation

  4. Because the table is moved forward and back to a temporary during the flashback opertion

Answer: A

Question No: 28

Examine the following set of RMAN commands:





Which statement is true when the RMAN run block is executed?

  1. The execution of the script fails because multiple channels cannot coexist.

  2. The script is executed and both the channels are used for the script execution.

  3. The new channel, CH1, is ignored because a channel has been configured already.

  4. The persistent configuration parameter DC1 is overridden because a new channel is allocated in the RMAN run block.

Answer: D

Question No: 29

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:

ERROR at line I:

ORA-0I565: error in identifying file #39;/u01/app/oracle/oradata/TEST/temp01.tmp#39; ORA-27037: unable to obtain file status

What would be the most efficient way to rectify this error?

  1. Add a new tempfile to the user#39;s temporary tablespace and drop the tempfile that produced the error.

  2. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

  3. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

  4. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Answer: A

Question No: 30

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  1. Inactive and current redo log files are required to accomplish recovery

  2. Online and archived redo files are required to accomplish instance recovery

  3. All redo log entries after the last checkpoint are applied from redo log files to data files

  4. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Answer: C

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