databases Online Quiz - 114
Description: databases Online Quiz - 114 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which clause in a query limits the rows selected?
The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
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
which statement is used to break a loop in pl/sql
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
which of the following is not an explicit cursor attribute
DUP_VAL_ON_INDEX corressponds to which of the following error.
Which Database is oldest database in world ?
Which of the following statements contains an error?
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;
The default character for specifying runtime variables in SELECT statements is :-
Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.
Which function below can best be categorized as similar in function to an IF-THEN-ELSE 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?