1Z0-034 Online Practice Questions and Answers

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

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

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.

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.

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

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

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

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

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

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

A. The number of DBWR processes increases

B. The number of ASMB processes increases

C. The number of DBWR_TO_SLAVES increases

D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/ Ooverhead

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

A. An upper limit on how far you can flash back the database, depending on the information in the redo logs

B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space

What two are the prerequisites for enabling Flashback Database?

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined

Examine the following command that is used to duplicate a database on the same host:

RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }

Which two statements describe the effect after the database is duplicated successfully? (Choose two)

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

A. Its entries are specific to a single database.

B. It contains file systems that have been mounted by Direct NFS.

C. It is globally available to all Oracle 11g databases on the machine.

D. It contains file systems that have been mounted by the kernel NFS system.