Tag: databases

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.

TNSLSNR

LISTENER

LOCAL_LISTENER

DEFAULT_LSRN

LIST EXPIRED

DELETE EXPIRED

DELETE OBSOLETE

CHANGE UNCATALOG

OPEN

IDLE

MOUNT

NOMOUNT

SET

ALTER

CHANGE

UPDATE

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.

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.