Which of the following is true about the following PL/SQL CASE statement syntax? CASE selector WHEN value1 THEN S1; WHEN value2 THEN S2; WHEN value3 THEN S3; ..... ELSE Sn; ..... default case END CASE;

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is true about the following PL/SQL CASE statement syntax? CASE selector WHEN ‘value1’ THEN S1; WHEN ‘value2’ THEN S2; WHEN ‘value3’ THEN S3; ____ ELSE Sn; ____ default case END CASE;

A	It is wrongly written.
B	It is perfectly written.
C	It is you can specify the literalNULL for all the S expressions and the default Sn.
D	All the expressions like theselector, the value and the returns values, need not be of the same data type.

Explanation:

Detailed explanation-1: -Which of the following is true about the execution section of a PL/SQL block? It is a mandatory section. It consists of the executable PL/SQL statements.

Detailed explanation-2: -Q 19-Which of the following is not true about the PL/SQL functions? A-A PL/SQL function is same as a procedure except that it returns a value.

Detailed explanation-3: -Which of the following is true about the PL/SQL data structure VARRAY? It also has a maximum size that cannot be changed. A VARRAY type is created with the CREATE VARRAY statement, at the schema level. Maximum size of a VARRAY can be changed using the ALTER TYPE statement.

Detailed explanation-4: -Which of the following is true about PL/SQL package body? The package body has methods declared in package specification and private. It is created using the CREATE PACKAGE Statement.

There is 1 question to complete.

MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL