databases Online Quiz - 234
Description: databases Online Quiz - 234 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which of the following SQL statements can calculate and return the absolute value of -33?
You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?
Which is the procedure used to issue User-Defined error messages from stored Sub-Programs?
Which line of the following code has an error? SELECT * FROM emp WHERE comm = NULL ORDER BY ename;
- 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 two statements about the overloading feature of packages are true? (Choose two)
Which two statements about packages are true? (Choose two)
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?