When you try to save 34567.2255 into a column defined as NUMBER(7,2) what value is actually saved?
34567.00
34567.22
34567.23
3456.22
What is the default display length of the DATE datatype column?
8
9
6
16
Which clause in a query limits the rows selected?
ORDER BY
FROM
SELECT
WHERE
The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
True
False
PL/SQL blocks may be nested within exception block.
The following block statement will run successfully SCOTT.EMP.EMPNO := 1234;
5 + NULL evaluates to 5 and ‘PL/’ || NULL || ‘SQL’ evaluates to ‘PL/SQL’
what is the concatenation operator in dbms_output.put_line() function
+
||
.
what will be the output of the following block: set serveroutput on; declare a int; b int; begin a:=NULL; b:=NULL; if a< b then dbms_output.put_line('y'); else dbms_output.put_line('n'); end if; end;
y
n
error
no output
which statement is used to break a loop in pl/sql
exit
break
stop
continue