Adding a new user to database.

Adding a new tablespace to database.

Dropping a table from the database.

Dropping a user from the database.

Dropping a datafile from a tablespace.

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.

None

Up to the current free space in the tablespace

Unlimited space, including autoextends

Up to the default quota established at tablespace creation time

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

alter session set idle_timeout=30;

alter session set idle_timeout=1800;

alter profile limit idle_time 30;

alter profile set idle_timout 30;

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.

Setting the initialization parameter NO_PASSWORD_REUSE to TRUE

Altering that user’s profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_REUSE_MAX

Altering that user’s profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

Using a password verify function to record the new password and compare the new passwords to those recorded previously

Set the initialization parameter PASSWORD_COMPLEXITY to ALPHANUM.

Alter that user’s profile setting PASSWORD_COMPLEXITY to ALPHNANUM.

Alter the user’s profile to use a password verify function that performs REGEX comparisons to validate the password.

There is no mechanism that lets you prevent an all-numeric password

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.

SELECT

DEBUG

REFERENCES

READ

Oracle Net Manager.

Data Pump.

Oracle Universal Installer (OUI).

Oracle Enterprise Manager.

Database Configuration Assistant (DBCA).

Object level.

Row level.

Block level.

Schema level.

Database level.

Loss of the initialization parameter file.

One of the redo log members.

Any data file belonging to the default permanent tablespace

Any archive log file.

Any control file.

It is possible to have tablespaces of different block sizes in a database.

A data block is the smallest unit of I/O for data files.

Multiple tablespaces can share single data file.

Each data block in the database always corresponds to one OS block.

Each segment contains one or more extents.

Data files and redo log files can be renamed at the MOUNT stage.

Control files are required to bring the database to the NOMOUNT stage.

Data files and online redo log files are checked for consistency while opening the database.

Data files and redo log files are made available to users at the OPEN stage.

Control files are read at the OPEN stage for the location of data files.