Mapping files can be added to Configuration in the application code

They can be configured in hibernate.cfg.xml using the elements

Both a and b

None of the above

refresh();

flush();

fetch();

load()

None

StandardQueryCache and UpdateTimestampsCache

StandardQueryCache

QueryCache

QueryCache and TimestampsCache

lazy="true"

lazy="false"

lazy="on"

lazy="off"

lazy=false;

lazy=true;

lazy=yes;

lazy=no;

Session.createQuery();

Session.createCriteria();

Session.createSQLQuery();

Session.lod();

The size of an undo block

The size of the redo log files

The size of the database buffer cache.

The value of the UNDO_RETENTION parameter.

Undo blocks generated per second.

By auditing the all DML operations on table.

By using external table

By using triggers.

By using anonymous PL/SQL blocks

BFILE

BLOB

CLOB

LONG RAW

DROP TABLESPACE USERS

ALTER TABLE SALES_REP DROP PARTITION P1

DROP TABLE EMPLOYEES

DROP USER SMITH

ALTER TABLE EMPLOYEES DROP COLUMN DESIGN_ID

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.

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.