databases Online Quiz - 234
|Description: databases Online Quiz - 234|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which is the procedure used to issue User-Defined error messages from stored Sub-Programs?
- Examine this procedure: CREATE OR REPLACE PROCEDURE DELETE_PLAYER(V_IDIN NUMBER) IS BEGIN DELETE FROM PLAYER WHERE ID = V_ID EXCEPTION WHEN STATS_EXIST_EXCEPTION THEN DBMS_OUTPUT.PUT_LINE(Cannotdeletethisplayer, childrecordsexistin PLAYER_BAT_STAT table); END; What prevents this procedure from being created successfully?
Which operator will be evaluated first in the following SELECT statement? SELECT (2+3*4/2–5) FROM dual;
Which of the following statements is false with respect to packages?
Private constructs in the package body are hidden and inaccessible. Is this an advantage of a package?