Q 1 - Which of the following is not true about the PL/SQL language?

A - It supports embedded SQL statements.

B - It has all the features of a modern structured programming language.

C - It is not a block-structured language.

D - Applications developed using PL/SQL are not portable.

Q 2 - Which of the following is true about scalar data types in PL/SQL?

A - They hold single values with no internal components.

B - Examples of scalar data types are NUMBER, DATE, or BOOLEAN.

C - PL/SQL provides subtypes of data types.

D - All are true.

Q 3 - 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 literal NULL for all the S expressions and the default S_n.

D - All the expressions like the selector, the value and the returns values, need not be of the same data type.

Q 4 - Which of the following is not true about the PL/SQL data structure VARRAY?

A - In oracle environment, the starting index for VARRAYs is always 1.

B - You can initialize the VARRAY elements using the constructor method of the VARRAY type, which has the same name as the VARRAY.

C - VARRAYs are one-dimensional arrays.

D - None of the above.

Q 5 - 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.

B - The function body must contain a RETURN statement.

C - The RETURN clause does not specify the data type of the return value.

D - The AS keyword is used instead of the IS keyword for creating a standalone function.

Q 6 - The pre-defined exception NO_DATA_FOUND is raised when

A - A null object is automatically assigned a value.

B - A SELECT INTO statement returns no rows.

C - PL/SQL has an internal problem.

D - PL/SQL ran out of memory or memory was corrupted.

Q 7 - Observe the syntax given below −

CREATE [OR REPLACE ] TRIGGER trigger_name 
{BEFORE | AFTER | INSTEAD OF } 
{INSERT [OR] | UPDATE [OR] | DELETE} 
[OF col_name] 
ON table_name 
[REFERENCING OLD AS o NEW AS n] 
[FOR EACH ROW] 
WHEN (condition)  
DECLARE
   Declaration-statements
BEGIN 
   Executable-statements
EXCEPTION
   Exception-handling-statements
END;

The INSTEAD OF clause is used for creating trigger on a −

A - View

B - Cursor

C - Table

D - Index

Q 8 - Which of the following is not true about PL/SQL collections?

A - A collection is an ordered group of elements having the same data type.

B - A collection is an ordered group of elements having different data type.

C - Each element is identified by a unique subscript that represents its position in the collection.

D - Nested tables and Varrays are types of PL/SQL collections.

Q 9 - Which of the following code is the correct syntax for creating a nested table named salary that will store integer values?

A - TYPE salary IS TABLE OF INTEGER;

B - TYPE salary IS NESTED TABLE OF INTEGER;

C - TABLE salary IS NESTED BY INTEGER;

D - TABLE salary IS INDEXED BY INTEGER;

Q 10 - What will be the output of the following code?

DECLARE
   lines dbms_output.chararr;
   num_lines number;
BEGIN
    dbms_output.enable;
   dbms_output.put_line('Hello!');
   dbms_output.put_line('Hope you are doing well!');
   num_lines := 2;
   dbms_output.get_lines(lines, num_lines);
 
   FOR i IN 1..num_lines LOOP
      dbms_output.put_line(lines(i));
   END LOOP;
END;

A - Hello!

     Hope you are doing well!

B - He

     Ho

C - Hello!

     Hope you

D - Hello!