Tag: technology

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

True

False