0

databases Online Quiz - 114

Description: databases Online Quiz - 114
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

The INTO clause is mandatory for SELECT statements within PL/SQL blocks.

  1. True

  2. False


Correct Option: B

5 + NULL evaluates to 5 and ‘PL/’ || NULL || ‘SQL’ evaluates to ‘PL/SQL’

  1. True

  2. False


Correct Option: B

what is the concatenation operator in dbms_output.put_line() function

  1. +

  2. ||

  3. .


Correct Option: C

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

  1. line 1

  2. line 2

  3. line 3

  4. line 4


Correct Option: C
  1. fox pro

  2. oracle

  3. db2

  4. sql server


Correct Option: B
  1. SELECT * FROM emp WHERE empid = 493945;

  2. SELECT empid FROM emp WHERE empid= 493945;

  3. SELECT empid FROM emp;

  4. SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;


Correct Option: D

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;

  1. ACTIVE

  2. LOA

  3. TERMINATED

  4. 38475


Correct Option: B

SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

  1. True

  2. False


Correct Option: B

MAXVALUE is a valid parameter for sequence creation.

  1. True

  2. False


Correct Option: A

Dropping a table has which of the following effects on a nonunique index created for the table?

  1. No effect

  2. The index will be rendered invalid

  3. The index will be dropped

  4. The index will contain NULL values.


Correct Option: C
- Hide questions