Oracle Oracle Database 1Z0-034 Questions & Answers

• Question 131:

  Given below are RMAN commands to enable backup optimization and set the retention policy:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE BACKUP OPTIMIZATION ON;

  RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.

  Viewthe Exhibit to examine the operations performed by using RMAN.

  Which two statements are true about the backup of the USERS tablespace? (Choose two.)

  

  A. It will be backed up as a part of database backup on Friday.

  B. It will be backed up as a part of database backup on Tuesday.

  C. It will not be backed up as a part of database backup on Wednesday.

  D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

  Correct Answer: BD

• Question 132:

  View the Exhibit to observe the error.

  

  You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.

  What can you do to reduce the chance of this error in the future?

  A. Increase the value of SGA_MAX_SIZE

  B. Enable automatic memory management

  C. Set the PRE_PAGE_SGA parameter to true

  D. Lock the System Global Area (SGA) in memory

  Correct Answer: B

• Question 133:

  Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

  A. Flash recovery area must be defined

  B. Undo retention guarantee must be enabled.

  C. Database must be running in archivelog mode.

  D. Automatic undo management must be enabled.

  E. The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).

  Correct Answer: DE

• Question 134:

  You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).

  Identify two scenarios in which you must have a recovery catalog.

  A. To store the backup information of multiple database

  B. To restrict the amount of space that is used by the backups

  C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

  D. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.

  Correct Answer: AD

• Question 135:

  View the Exhibit and examine the RMAN commands.

  

  Which statement describes the effect of a backup retention policy on the backup of a backup set?

  A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.

  B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.

  C. The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.

  D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.

  Correct Answer: A

• Question 136:

  Which four resources can directives be specified by using the Oracle Resource Manager?

  A. CPU usage

  B. degree of parallelism

  C. number of open cursors

  D. number of sorts performed

  E. idle time for blocking sessions

  F. number of I/Os requests

  Correct Answer: ABEF

• Question 137:

  You are managing a 24*7 database. The backup strategy for the database is to perform usermanagedbackups.

  Identify two prerequisites to perform the backups. (Choose two.)

  A. The database must be opened in restricted mode.

  B. The database must be configured to run in ARCHIVELOG mode.

  C. The tablespaces are required to be in backup mode before taking the backup.

  D. The tablespaces are required to be in read-only mode before taking the backup

  Correct Answer: BC

• Question 138:

  You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.

  Which statement is true regarding the ACL created?

  A. It is a list of remote database links stored in the XML file that are available to the users of the database.

  B. It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.

  C. It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.

  D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such as UTL_TCP.

  Correct Answer: B

• Question 139:

  The DB_BLOCK_CHECKING parameter is set to FULL. What checks occur each time the DBWnprocess(es) writes?

  A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

  B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

  C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

  D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.

  E. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

  Correct Answer: A

• Question 140:

  The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?

  A. Control files

  B. Password file

  C. Inactive online redo log file

  D. Archived log files required to perform recovery

  E. Newly created tablespace which is not backed up

  Correct Answer: AD