Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 121:

  Examine the following set of RMAN commands:

  RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*; RKAN>RUN { ALLOCATECHANNELchlDEVICETYPEDISK; EXECUTESCRIPTfull_backup; }

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

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

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

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

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

  Correct Answer: D

• Question 122:

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

  A. ALTER DISKGROUP misc MOUNT;

  B. ALTER DISKGROUP misc DROP DISK misc2;

  C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;

  D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

  E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

  Correct Answer: AC

• Question 123:

  Before a Flashback Table operation, you execute the following command:

  ALTER TABLE employees ENABLE ROW MOVEMENT;

  Why would you need this to be executed?

  A. Because row IDs may change during the flashback operation

  B. Because the object number changes after the flashback operation

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

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

  Correct Answer: A

• Question 124:

  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]

  A. Change the RMAN archived log deletion policy.

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

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

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

  Correct Answer: BD

• Question 125:

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

  A. An ASM instance mounts an ASM control file

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

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

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

  Correct Answer: CD

• Question 126:

  Which three statements are true about windows?

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

  B. Consumer groups are associated with windows

  C. Windows work with job classes to control resource allocation

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

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

  Correct Answer: ACE

• Question 127:

  Note the following statements that use flashback technology:

  1.

  FLASHBACK TABLE [table] TO SCN ;

  2.

  SELECT * FROM [table] AS OF SCN 123456;

  3.

  FLASHBACK TABLE [table] TO BEFORE DROP;

  4.

  FLASHBACK DATABASE TO TIMESTAMP ;

  5.

  SELECT * FROM [table] 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?

  A. 1, 2, and 5

  B. 1, 3, and 4

  C. 2, 3, 4, and 5

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

  Correct Answer: A

• Question 128:

  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:

  SQL> 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: A. Because the PGA_AGGREGATE_TARGET parameter is not set

  

  B. Because the STATISTICS_LEVEL parameter is set to BASIC

  C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal

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

  Correct Answer: B

• Question 129:

  View the Exhibit.

  

  You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files

  using the External Table Population method.

  You execute the command shown on the exhibit, but only two files have been created.

  Which parameter must be changed so that four files are created?

  A. TYPE

  B. LOCATION

  C. PARALLEL

  D. DEFAULT DIRECTORY

  E. ORGANIZATION EXTERNAL

  Correct Answer: C

• Question 130:

  Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

  A. New channels for restore and recovery tasks

  B. New name for the data files of the tablespace

  C. Auxiliary name for the data files of the tablespace

  D. Auxiliary destinations for an auxiliary set of data files

  Correct Answer: D