Question 1

Which clause in a query limits the rows selected?

technology databases

ORDER BY
FROM
SELECT
WHERE

Answer

Correct Option: D

Question 2

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

technology databases

True
False

Answer

Correct Option: B

Question 3

PL/SQL blocks may be nested within exception block.

technology databases

True
False

Answer

Correct Option: A

Question 4

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

technology databases

True
False

Answer

Correct Option: B

Question 5

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

technology databases

True
False

Answer

Correct Option: B

Question 6

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

technology databases

+
||
.

Answer

Correct Option: C

Question 7

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;

technology databases

y
n
error
no output

Answer

Correct Option: B

Question 8

which statement is used to break a loop in pl/sql

technology databases

exit
break
stop
continue

Answer

Correct Option: A

Question 9

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

technology databases

line 1
line 2
line 3
line 4

Answer

Correct Option: C

Question 10

which of the following is not an explicit cursor attribute

technology databases

%notfound
%rowcount
%isopen
%isclose

Answer

Correct Option: D

Question 11

DUP_VAL_ON_INDEX corressponds to which of the following error.

technology databases

ORA-01427
ORA-01476
ORA-00001
ORA-01001

Answer

Correct Option: C

Question 12

Which Database is oldest database in world ?

technology databases

fox pro
oracle
db2
sql server

Answer

Correct Option: B

Question 13

Which of the following statements contains an error?

technology databases

SELECT * FROM emp WHERE empid = 493945;
SELECT empid FROM emp WHERE empid= 493945;
SELECT empid FROM emp;
SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

Answer

Correct Option: D

Question 14

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;

technology databases

ACTIVE
LOA
TERMINATED
38475

Answer

Correct Option: B

Question 15

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

technology databases

percentage sign
Quotation marks
Ampersand
Ellipses

Answer

Correct Option: C

Question 16

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

technology databases

True
False

Answer

Correct Option: A

Question 17

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

technology databases

True
False

Answer

Correct Option: B

Question 18

Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?

technology databases

NEW_TIME
Decode
ROWIDTOCHAR
SQRT

Answer

Correct Option: B

Question 19

MAXVALUE is a valid parameter for sequence creation.

technology databases

True
False

Answer

Correct Option: A

Question 20

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

technology databases

No effect
The index will be rendered invalid
The index will be dropped
The index will contain NULL values.

Answer

Correct Option: C

Description: databases Online Quiz - 114
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 114

Find more quizzes from top tags