True

False

True

False

SYS privileges

Your privileges

Public privileges

User A’s privileges

ALTER TABLE emp ADD CONSTRAINT ck_sal CHECK (sal BETWEEN sal AND sal*1.1);

CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal ON emp - 6 - FOR EACH ROW WHEN (new.sal < old.sal OR new.sal > old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( - 20508, ‘Do not decrease salary not increase by more than 10%’); END;

CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal ON emp WHEN (new.sal < old.sal OR new.sal > old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( - 20508, ‘Do not decrease salary not increase by more than 10%’); END;

CREATE OR REPLACE TRIGGER check_sal AFTER UPDATE OR sal ON emp WHEN (new.sal < old.sal OR -new.sal > old.sal * 1.1) BEGIN RAISE_APPLICATION_ERROR ( - 20508, ‘Do not decrease salary not increase by more than 10%’); END;

You can call the BONUS.CALC_SALARY packaged function from an INSERT command against the EMPLOYEES table.

You can call the BONUS.CALC_SALARY packaged function from a SELECT command against the EMPLOYEES table.

You can call the BONUS.CALC_SALARY packaged function form a DELETE command against the EMPLOYEES table.

You can call the BONUS.CALC_SALARY packaged function from an UPDATE command against the EMPLOYEES table.

Use a drop procedure statement to drop a standalone procedure.

Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package specification.

Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package body.

For faster removal and re-creation, do not use a drop procedure statement. Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS clause.

FOR EACH ROW trigger on the EMP table.

Statement-level trigger on the EMP table.

FOR EACH ROW trigger on the AUDIT_TABLE table

Statement-level trigger on the AUDIT_TABLE table

Oracle Advanced Queuing

DBMS_JOB

DBMS_SQL

Pipelined Functions

NULL

0

Results in a compilation error

An exception will be raised

SELECT name FROM USER_DEPENDENCIES WHERE referenced_name = 'DBMS_OUTPUT.PUT_LINE'

SELECT name from ALL_SOURCE WHERE owner = USER AND name = 'DBMS_OUTPUT.PUT_LINE'

SELECT DISTINCT name from ALL_SOURCE WHERE INSTR (text, 'DBMS_OUTPUT.PUT_LINE') > 0

SELECT DISTINCT name from USER_SOURCE WHERE INSTR (UPPER (text), 'DBMS_OUTPUT.PUT_LINE') > 0

When a SELECT statement returns no rows

When a SELECT statement returns more than one row

When the datatypes of SELECT clause and INTO clause do not match

When INTO statement is missing in the SELECT statement

TRUE

FALSE

UNDEFINED

NULL

Header

Declarative

Executable

Exception

Begin null; end;

Declare x varchar2(100); begin dbms_output.put_line(x); end;

Begin .. statement1; exception ... end;

Begin dbms_output.put_line(sysdate); end;;

192

255

249

300

1

31

16

255

8

1

31

32

255

600

256

32

there is no limit

16843

255

1024

3

12

6

9