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

PL/SQL blocks may be nested within exception block.

  1. True

  2. False


Correct Option: A

The following block statement will run successfully SCOTT.EMP.EMPNO := 1234;

  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

DUP_VAL_ON_INDEX corressponds to which of the following error.

  1. ORA-01427

  2. ORA-01476

  3. ORA-00001

  4. ORA-01001


Correct Option: C

Which Database is oldest database in world ?

  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

The default character for specifying runtime variables in SELECT statements is :-

  1. percentage sign

  2. Quotation marks

  3. Ampersand

  4. Ellipses


Correct Option: C

Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

  1. True

  2. False


Correct Option: A

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