Oracle Net is layered on top of the network protocol.

Oracle Net must reside on both the client and the server for peer-to-peer communication to occur.

On the client side, Oracle Net is responsible for working with the listener to receive incoming connection requests.

On the server side, Oracle Net is responsible for several connectivity issues such as : the location of the server, whatever one or more protocol is involved in the connection, and how to handle exception and interrupts.

Restore the data file and perform incomplete recovery.

Restore the data file and perform point-in-time recover.

Drop the tablespace and lose all data in the tablespace.

Restore the database and lose all data since the last backup.

alert.ora

init.ora

tnsname.ora

redolog

SYNC or ASYNC to identify the network transmission mode.

LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

Extent

Segement

Oracle block

Operating system block

V$UNDOSTAT

V$TRANSACTION

V$ROLLSTAT

DBA_UNDO_EXTENTS

DBA_ROLLBACK_SEGS

OPEN

IDLE

MOUNT

NOMOUNT

PMON

SMON

RECO

ARCn

CKPT

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.

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.

SET

ALTER

CHANGE

UPDATE

ARCn

DBWn

CKPT

LGWR

PMON

SMON

LIST EXPIRED

DELETE EXPIRED

DELETE OBSOLETE

CHANGE UNCATALOG

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.

Check

Unique

Not Null

Primary Key

Foreign Key

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 fragmented can be ignored because Oracle resolve index fragmentation by means of a freelist.

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

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'

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.

Using SQL commands.

Using SQL*Plus Commands.

Using operating system commands.

Using Recover Manager commands.