Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 21:

  View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine

  the CRS11G disk group when one disk is offline.

  Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?

  ASM-disk-group-1 (exhibit):

  

  ASM-disk-group-2 (exhibit): A. Because the disk group is created with NORMAL redundancy

  

  B. Because the disk repair time attribute is set to a nonzero value

  C. Because the mirrored extents cannot be rebalanced across the other three disks

  D. Because the other three disks have 60% free space, the disk rebalancing is delayed

  Correct Answer: B

• Question 22:

  Given below is a list of scenarios:

  1) A user terminates his session abnormally.

  2) The connection between the server and the client application terminates because of a network failure.

  3) A schema is accidentally dropped.

  4) The tablespace is accidentally dropped from the database.

  5) The hard disk gets corrupted and the data files in the disk are lost.

  6) The database instance abnormally shuts down because of power failure.

  Which scenarios require DBA intervention to perform recovery?

  A. 1, 3, and 6

  B. 4, 5, and 6

  C. 3, 4, and 5

  D. 1, 2, and 6

  Correct Answer: C

• Question 23:

  Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

  A. It is a copy or a subset of the target database.

  B. It is opened in RESTRICT mode after a duplicating operation.

  C. It is created by using backups and archived redo log files from the target database.

  D. It is created with the same database identifier (DBID) as that of target database.

  Correct Answer: AC

• Question 24:

  While designing a database, you created the EMPLOYEES table as an index-organized table (IOT). You must create a bitmap index on the EMPLOYEES .JOB_ID column.

  Which must you do to enable the creation of the bitmap index?

  A. A primary key must have been created.

  B. A mapping table must have been created.

  C. An overflow tablespace must have been specified.

  D. The PCTTHRESHOLD option must have been specified.

  Correct Answer: B

• Question 25:

  You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue?

  A. Disable automatic checkpoint tuning.

  B. Check the size of the redo log file size and increase the size if it is small.

  C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

  D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

  Correct Answer: BC

• Question 26:

  You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)

  A. It is a smallfile tablespace.

  B. It is a bigfile tablespace (BFT).

  C. It is a default bigfile tablespace.

  D. It is a locally managed tablespace.

  E. It is a dictionary-managed tablespace.

  Correct Answer: AD

• Question 27:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  A. The ADR base keeps all diagnostic information in binary format

  B. SQL*Plus provides the ADRI script, which can be used to work with ADR

  C. The ADR can be used for problem diagnosis only when the database is open

  D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

  E. The ADR can be used for problem diagnosis even when the database instance is down

  F. The ADR base is shared across multiple instances

  Correct Answer: EF

• Question 28:

  

  View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session:

  RMAN> BACKUP DATABASE FILESPERSET 2;

  The database has seven data files. Why is the value of %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?

  A. Because the progress is reported for each data file

  B. Because the progress is reported for each backup set

  C. Because other RMAN sessions have issued the same BACKUP command

  D. Because new data files have been added to the database while the RMAN backup is in progress

  Correct Answer: B

• Question 29:

  The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:

  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

  Which action should you perform immediately after using this command?

  A. You should perform a log switch

  B. You should make a backup of the database

  C. You should switch the database to the NOARCHIVELOG mode

  D. You should shut down the database instance and perform a complete database recovery

  Correct Answer: B

• Question 30:

  In which two aspects does hot patching differ from conventional patching? (Choose two.)

  A. It consumes more memory compared with conventional patching.

  B. It can be installed and uninstalled via OPatch unlike conventional patching.

  C. It takes more time to install or uninstall compared with conventional patching.

  D. It does not require down time to apply or remove unlike conventional patching.

  E. It is not persistent across instance startup and shutdown unlike conventional patching.

  Correct Answer: AD