Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 101:

  memory_target big integer 808M pga_aggregate_target big integer 0 sga_target big integer 0 SQL> SHOW PARAMETER SGA_MAX_SIZE

  NAME TYPE VALUE ------------------------------------------------------------------------------------------------- sga_max_size big integer 808M Which statement is correct about the database?

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

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

  C. SGA_TARGET are set.

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

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

  Correct Answer: E

• Question 102:

  Examine the parameter settings in your database.

  

  Which statement is correct about the database?

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

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

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

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

  Correct Answer: D

• Question 103:

  You executed the following command In Recovery Manager {RMAN):

  RMAN>REPORTNEEDBACKUPdays 3;

  What is the output of this command?

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

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

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

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

  Correct Answer: B

• Question 104:

  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?

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

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

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

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

  Correct Answer: C

• Question 105:

  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?

  A. the DBNEWID utility

  B. the DBVERIFY utility

  C. the ANALYZE command

  D. the RMAN REPORT command

  E. the RMAN CROSSCHECK command

  F. the CHECK_OBJECT procedure of the DBMS_REPAIR package

  Correct Answer: B

• Question 106:

  You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statements are true?

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

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

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

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

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

  Correct Answer: AE

• Question 107:

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

  A. Only one nested subplan is allowed per parent plan

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

  C. Nested plans only control resources used by recursive SQL

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

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

  Correct Answer: E

• Question 108:

  Examine the following ALTER command:

  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

  What is the purpose of the command?

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

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

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

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

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

  Correct Answer: A

• Question 109:

  You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):

  RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

  Identify the statement that correctly describes the implications of this command.

  A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.

  B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

  C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulativebackups.

  D. when there are already three backup, one of the existing backups must be removed manually before takingthe fourth backup.

  Correct Answer: B

• Question 110:

  Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

  A. It can be used to allow the access privilege settings for users but not roles.

  B. It can be used to allow the access privilege settings for users as well as roles.

  C. It can be used to control the time interval for which the access privilege is available to a user.

  D. It can be used to selectively restrict the access for each user in a database to different host computers.

  E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

  Correct Answer: BCD