databases Online Quiz - 114
Description: databases Online Quiz - 114 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Attempted
0/20
Correct 0
Score 0
‹
›
The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
5 + NULL evaluates to 5 and ‘PL/’ || NULL || ‘SQL’ evaluates to ‘PL/SQL’
what is the concatenation operator in dbms_output.put_line() function
which of the following lines is invalid: FOR i IN 1…256 LOOP --Line 1 x := x + i ; --Line 2 i := I + 5; --Line 3 END LOOP; --Line 4
The user issues the following statement. What will be displayed if the EMPID selected is 60494? SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”) FROM emp;
SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.
MAXVALUE is a valid parameter for sequence creation.
Dropping a table has which of the following effects on a nonunique index created for the table?