Tag: databases

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