Tag: databases

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.

The contents and data files belonging to the IND2 tablespace are dropped.

The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.

The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle Managed Files (OMF) or of the database was created using OMF.

The contents of the tablespace are dropped along with all its data files except those identical with Oracle-Managed Files (OMF) naming convention.

Do nothing, the PMON process handles everything.

Shut down the database and restore all the tables the user was updating.

Log in as DBA, clean up the partial updates in those tables, and do another manual backup.

Use LogMiner to find out which records are changed based on the user’s ID, then roll back all those changes.

The data file needs to be restored by using operating system commands, because a data file movement must take place, and then the database can be recovered from RMAN.

The data file needs to be restored by using operating system commands, since a data file movement must take place, and then the database must be recovered manually.

From RMAN you can issue the commands RESTORE and RECOVER. RMAN automatically restores the data file on DISK 3 to another disk, based upon utilization statistics.

From RMAN you can issue a SET NEWNAME command to update the data file location information in the control file, and then issue the RESTORE and RECOVER commands to recover the database.

Backups will never expire.

It removes any retention policy.

The DELETE OBSOLETE command will fail with an error.

It sets the retention policy to the default of REDUNDANCY 1.

OPEN

IDLE

MOUNT

NOMOUNT

SET

ALTER

CHANGE

UPDATE

TNSLSNR

LISTENER

LOCAL_LISTENER

DEFAULT_LSRN

PMON

SMON

RECO

ARCn

CKPT