True

False

listener.ora

sqlnet.ora server file

sqlnet.ora client file

tnsnames.ora server file

create user ops$admin identified by os;

create user ops$admin identified externally;

create user ops$admin nopassword;

create user ops$admin authenticated by os;

An index creation

SQL statements with a GROUP BY clause

A hash join operation

All of the above

grant alter on gl.accounts to desmond;

grant alter to desmond on gl.accounts;

grant alter table to desmond;

allow desmond to alter table gl.accounts;

grant alter any table with grant option to desmond;

grant alter on gl.accounts to desmond with admin option;

grant alter any table to desmond with grant option;

grant alter any table to desmond with admin option;

Select the next value from oe.orders_seq.

Alter sequence oe.orders_seq to change the next value.

Change the number of sequence numbers that will be cached in memory.

Both A and C.

All of the above.

B loses his SELECT privilege on sh.products.

B retains his SELECT privilege on sh.products.

B loses his SELECT privilege if A was dropped with the CASCADE REVOKE option.

B retains his SELECT privilege if A was dropped with the NOCASCADE REVOKE option

B loses his privileges.

B retains his privileges.

B loses his privileges if A was dropped with the CASCADE REVOKE option.

B retains his privileges if A was dropped with the NOCASCADE REVOKE option.

CREATE ANY JOB

ALTER USER

CREATE ANY PROCEDURE

All of the above

alter session enable role user_admin;

alter session set role user_admin;

alter role user_admin enable;

set role user_admin;

set role all;

alter user augustin default role all;

alter session enable role info_czar;

alter session enable info_czar identified by brozo

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

System Services

Locking Services

SQL Services

Distributed DATA Facilities

Compiled form of application plan

Compiled form of Database Requests

Collection of Sql statements

Collection of Application plansCollection of Application plans

Compiles the SQL statements

Complies the list of packages into application plan

Stored the application plan and packages into Directory

Chooses the best access path from catalog tables

True

False

True

False

LOAD

UNLOAD

REORG

RUNSTATS