PLSQL Set 10

Receives a message from the pipe and writes it to the message buffer ✘ Deletes the pipe from the memory ✘ Removes all the data from the pipe ✘ Clears the data from the message buffer ✔

-1 ✘ 1 ✘ -7 ✘ 7 ✔

The column will contain a reference to the building object. ✘ The column will not contain a reference to the building object. ✘ The column will contain the building object itself. ✘ The column will not contain the building object itself. ✔

Implicit cursor ✘ View declaration ✘ BIND and EXECUTE operations ✘ All of these ✔

CREATE Or Replace TYPE AddressType AS OBJECT ✘ CREATE Or Replace TYPE AddressType AS OBJECT (street VARCHAR2(15), city VARCHAR2(15), state CHAR(2), zip VARCHAR2(5) ); ✘ CREATE AddressType AS OBJECT (street VARCHAR2(15), city VARCHAR2(15), state CHAR(2), zip VARCHAR2(5) ); ✘ CREATE TYPE AddressType AS OBJECT ✔

DECLARE TYPE numbers_nt IS TABLE OF NUMBER; l_numbers numbers_nt; BEGIN l_numbers.EXTEND; l_numbers(1) := 1; END;

✘ DECLARE TYPE numbers_nt IS TABLE OF NUMBER; BEGIN l_numbers.EXTEND; END; ✘

DECLARE TYPE numbers_nt IS TABLE OF NUMBER; l_numbers numbers_nt; BEGIN l_numbers := numbers_nt (1, 2, 3); END;

✘ DECLARE TYPE numbers_nt IS TABLE OF NUMBER; BEGIN l_numbers.EXTEND; ✔

SET DESCRIBE ✘ SET DESC (RIBE) ✘ DESCRIBES ✘ All of these ✔

The trigger converts the lowercase characters into uppercase. ✘ The trigger is deleted. ✘ The trigger is deleted in restriction. ✘ The trigger converts the uppercase characters into lowercase. ✔

DELETE(m,n) ✘ DELETE(n) ✘ DELETE ✘ EDIT ✔

When the client implicitly enables resumable semantics for the session using the ALTER SESSION statement ✘ When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement ✘ When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement ✘ When the client explicitly enables resumable semantics for the session using the CREATE SESSION statement ✔