Tag: databases

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'

DBA_UNDO_EXTENTS

DBA_ROLLBACK_SEGS

Using SQL commands.

Using SQL*Plus Commands.

Using operating system commands.

Using Recover Manager commands.

LIST EXPIRED

DELETE EXPIRED

DELETE OBSOLETE

CHANGE UNCATALOG

SET

ALTER

CHANGE

UPDATE

ARCn

DBWn

CKPT

LGWR

PMON

SMON

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.