Tag: technology

SGA

Streams Pool

PGA

Shared Pool

Flashback

Data guard

ASM

Tivoli data protection

Flash recovery

It specifies the directory containing the oracle managed files

It specifies the directory for database files, if not specified explicitly

It specifies the directory containing the oracle software

It specifies the directory of Optimal Flexible Architecture.

Online redo log files can be backed up

RMAN backup can be taken only if the database is configured in ARCHIEVELOG mode.

Only used data blocks can be backed up as backup sets

Archived redo log files are backed up.

Only consistent database backed up can be performed.

Control file and password file

Password file

Control file

Listener control file

Create the new text file as ALERT.log

You have to recover the alert log file from the valid backup.

No action required. The file will be created automatically by the instance.

Change the value for the BACKGROUND_DUMP_DEST parameter.

A role can contain both system and object privileges.

A role cannot be assigned external authentication.

A role can be granted to itself.

Roles are owned by the SYS user

Roles can be granted to other roles

The database services to be registered with the listener

The log file and trace file destination for the listener.

The protocol used by the listener

The server name where the listener runs.

The port used by the listener.

Extents would be managed by freelists.

Free space would be managed by data dictionary

The segment would be managed by bitmaps.

The segment would be managed by freelists.

Oracle Net Manager.

Data Pump.

Oracle Universal Installer (OUI).

Oracle Enterprise Manager.

Database Configuration Assistant (DBCA).