1Z0-034 Online Practice Questions and Answers

Which two statements are true regarding the functionality of the remap command in ASMCMD?

A. It repairs blocks that have read disk I/O errors.

B. It checks whether the alias metadata directory and the file directory are linked correctly.

C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.

D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

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.

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*';

The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.

How would you achieve this?

A. Implement a profile for the users.

B. Implement external roles for the users.

C. Set the threshold for the undo tablespace.

D. Implement a Database Resource Manager plan.

Which two statements are correct about database transportation? (Choose two.)

A. The source and target platforms must be the same

B. Redo logs, control files and temp files are also transported

C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed

D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.

Which of these methods would you use to achieve this? (Choose all that apply.)

A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

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

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

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

UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configuration?

A. Undo expires after 1000 seconds and is deleted.

B. Inactive undo is retained for 1000 seconds even if new transactions fail due to lack of space in the undo tablespace.

C. Inactive undo is retained for at least 1000 seconds if free undo space is available.

D. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSAUX tablespace to provide read consistency.