Upgrade Oracle9i/10g OCA to Oracle Database OCP

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?

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?

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';

To which disks in the disk group will the new value be applicable?

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
----------------

SQL> ALTER TABLE altb SHRINK SPACE COMPACT;

Table altered.

SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;

BLOCKS
-------------------------
View the Exhibit and examine the output and commands executed on the ALTB table.

Why does the number of blocks for the table remain the same after the shrink operation?

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?

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD.
The default format of which two data types would be affected by this setting?

Examine the following set of RMAN commands:

RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*; RKAN>RUN
{
ALLOCATECHANNELchlDEVICETYPEDISK;
EXECUTESCRIPTfull_backup;
}

Which statement is true when the RMAN run block is executed?

As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.

Which of the following steps are required to transport a tablespace from the database to the targetdatabase:

1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Convert data filed by using Recovery Manager (RMAN).
4. Transfer the dump file and data filed to the target machine.
5. Import metadata at the target database.
6. Make the tablespace read/write at the target database.

Exhibit:

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: