Extent

Segement

Oracle block

Operating system block

The index need to be dropped, and then re-created.

The resolution of index fragmentation depends on the type of index.

The index can be rebuilt while users continue working on the table.

The index can be rebuilt, but users will not have access to the index during this time.

The fragmented can be ignored because Oracle resolve index fragmentation by means of a freelist.

Check

Unique

Not Null

Primary Key

Foreign Key

The oracle server creates no undo tablespace.

The oracle server creates an undo segment in the system tablespace.

The oracle server cerates one undo tablespace with the name SYS_UNDOTBS.

Database creation fails because you did not specify an undo tablespace on the create database statment.

SELECT text FROM user_source WHERE name = 'SALARY_CALC';

SELECT * FROM user_source WHERE name='SALARY_CALC';

SELECT * FROM user_objects WHERE object_name='SALARY_CALC';

SELECT * FROM user_procedures WHERE object_name='SALARY_CALC';

SELECT text FROM user_source WHERE name='SALARY_CALC' and owner='JOHN'

V$UNDOSTAT

V$TRANSACTION

V$ROLLSTAT

DBA_UNDO_EXTENTS

DBA_ROLLBACK_SEGS

RUN { RESTORE TABLESPACE user_data; RECOVER TABLESPACE user_data; ALTER DATABASE OPEN; }

RUN { ET NEWNAME FOR '/DISK3/user_data01.dbf' TO '/DISK2/user_data01.dbf'; RESTORE TABLESPACE user_data; SWITCH DATAFILE '/DISK3/user_data01.dbf';

RUN { RESTORE TABLESPACE user_data; SET NEWNAME FOR '/DISK3/user_data01.dbf' TO '/DISK2/user_data01.dbf'; SWITCH DATAFILE '/DISK3/user_data01.dbf';

RUN { SET NEWNAME FOR '/DISK3/user_data01.dbf' TO '/DISK2/user_data01.dbf'; RESTORE TABLESPACE user_data; RECOVER TABLESPACE user_data; ALTER DATABASE OPEN;}

All of the data files must be from a backup taken prior to the point in time to which you want to recover.

Only the data files belonging from the SYSTEM tablespace must be from a backup taken prior to the point in time to which you want to recover.

Only the data files that need recovery must be from a backup taken prior to the point in time which you want to recover.

Only the data files belonging to the SYSTEM tablespace and the data files that need recovery must be from a backup taken prior to the point in time to which you want to recover.

ARCn

DBWn

CKPT

LGWR

PMON

SMON

Using SQL commands.

Using SQL*Plus Commands.

Using operating system commands.

Using Recover Manager commands.

LIST EXPIRED

DELETE EXPIRED

DELETE OBSOLETE

CHANGE UNCATALOG

Extent

Segement

Oracle block

Operating system block

Only the EMPLOYEES table.

Only the EMPLOYEES table and its corresponding primary key index.

The EMPLOYEES table and partition P1.

The EMPLOYEES table, IPK_EMP index, and the SALES table.

User the DROP DATAFILE command.

Use the DROP TABLESPACE command.

Ensure that all database files are Oracle Managed Files(OMF) before using the DROP TABLESPACE command.

Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.

Set the LOG_ARCHIVE_START parameter to TRUE in the initialization parameter file.

Automatic archive is the default when ARCHIVELOG mode is set. No further actions are required.

Set the LOG_ARCHIVE_MAX_PROCESSES parameter to n (where n is the number of Archiver process) in the initialization parameter file.

Immediately after setting the database in ARCHIVELOG mode, in SQL*Plus select automatic archiving using the syntax : ALTER DATABASE SET LOG_ARCHIVE_START=TRUE

A text copy of the control file.

A binary copy of the control file.

A file containing a SQL statement which will re-create the database.

A file containing a SQL statement which will re-create the control file.

Each target database requires its own recover catalog.

RMAN scripts can be stored in the recovery catalog or the targer control file.

A channel is a stream of data to a device type and corresponds to one server session.

The RMAN executable interprets server session commands and establishes connections to the target database.

Only when the new master site already has existing replication groups.

By issuing a single command to create , populate, and activate the new master.

When the master definition site is not the same for all of the master grouups.

Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.

A checkpoint defines the highest system change number (SCN)

All redo entries higher or at the SCN are known to be written to the data files.

Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.

The LOG_CHECKPOINT_INTERVAL initialization paramter specifies the amount of time beteen incremental checkpoints.

It performs a merge join of the row from T2 only if it does'nt exist in the T1 table.

It creates a natural join of table T1 and T2 for all columns that have the same name.

It creates a Cartesian prodcut of table T1 and table T2 for all columns that have the same name.

For each row from T2, it updates the row if it exists witin table T1, otherwise it inserts the row into T1.