Explore topic-wise MCQs in Technical MCQs.

This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.

1.

The searchedCASEstatement has no selector and theWHENclauses of the statement contain search conditions that give Boolean values.

A. Yes
B. No
C. Can be yes or no
D. Can not say
E.
Answer» B. No
Discussion
2.

In which Oracle does the PL/SQL Continue Statement is supported?

A. Oracle 8g
B. Oracle 11g
C. Oracle 9g
D. Oracle 10g
Answer» C. Oracle 9g
Discussion
3.

What are the selectors in case of CASE statement?

A. Variable
B. Function
C. Expression
D. All of the above
Answer» E.
Discussion
4.

DECLARE grade char(1) := 'A'; BEGIN CASE grade when 'A' then dbms_output.put_line('Excellent'); when 'B' then dbms_output.put_line('Very good'); when 'C' then dbms_output.put_line('Well done'); when 'D' then dbms_output.put_line('You passed'); when 'F' then dbms_output.put_line('Better try again'); else dbms_output.put_line('No such grade'); END CASE; END; 7.CASE statement uses which keyword to work like IF statement?

A. INTO
B. AS
C. WHEN
D. IN
Answer» D. IN
Discussion
5.

The CASE statement selects one sequence of statements to execute.

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
Answer» B. FALSE
Discussion
6.

BEGIN a := 100; IF( a < 20 ) THEN dbms_output.put_line('a is less than 20 ' ); ELSE dbms_output.put_line('a is not less than 20 ' ); END IF; END; 4.Which of the following is true?

A. It's ELSIF, not ELSEIF.
B. An IF-THEN statement can have zero or one ELSE's and it must come after any ELSIF's.
C. Once an ELSIF succeeds, none of the remaining ELSIF's or ELSE's will be tested.
D. All of the above
Answer» E.
Discussion
7.

BEGIN a:= 10; IF( a < 20 ) THEN dbms_output.put_line('a is less than 20 ' ); END IF; dbms_output.put_line('value of a is : ' || a); END;3.What is output for the following code?

A. a is less than 20
B. Error
C. a is not less than 20
D. Null
Answer» D. Null
Discussion
8.

What is output for the following code?

A. Null
B. a is less than 20
C. Error
D. Exception
Answer» C. Error
Discussion
9.

The __________ associates a condition with a sequence of statements enclosed by the keywords THEN and END IF.

A. GOTO statement
B. IF statement
C. CASE statement
D. LOOP statement
Answer» C. CASE statement
Discussion