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

A - Large Object or LOB data types are pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms.

B - The composite data types have data items that have internal components that can be accessed individually. For example, collections and records.

C - References are pointers to other data items.

D - All of the above.

Q 2 - What is wrong in the following code?

DECLARE
   c_id := 1;
   c_name  customers.name%type;
   c_addr customers.address%type;
  BEGIN
   SELECT name, address INTO c_name, c_addr
   FROM customers
   WHERE id = c_id;
END;

A - You cannot use the SELECT INTO statement of SQL to assign values to PL/SQL variables.

B - The SELECT INTO statement here is wrong. It should be: SELECT c_name, c_address INTO name, addr

C - The WHERE statement is wrong. It should be: WHERE id := c_id;

D - The variable c_id should be declared as a type-compatible variable as −

c_id customers.id%type := 1;

Q 3 - What is the output of the following code?

DECLARE
   x number := 4;
BEGIN
   LOOP
      dbms_output.put_line(x);
      x := x + 1;
      exit WHEN x > 5;
   END LOOP;
      dbms_output.put_line(x);
END;

A - 4

     5

     6

B - 4

     5

C - 4

D - None of the above.

Q 4 - Which of the following is the correct syntax for creating a VARRAY named grades, which can hold 100 integers, in a PL/SQL block?

A - TYPE grades IS VARRAY(100) OF INTEGERS;

B - VARRAY grades IS VARRAY(100) OF INTEGER;

C - TYPE grades VARRAY(100) OF INTEGER;

D - TYPE grades IS VARRAY(100) OF INTEGER;

Q 5 - Which of the following is not true about PL/SQL cursors?

A - A cursor is a view on a table.

B - A cursor holds the rows (one or more) returned by a SQL statement.

C - The set of rows the cursor holds is referred to as the active set.

D - None of the above.

Q 6 - Which of the following is not among the types of PL/SQL records?

A - Table-based

B - View-based

C - Cursor-based records

D - User-defined records

Q 7 - Which of the following is true for querying a table in the same trigger?

A - The AFTER keyword should be used, because triggers can query the table or change it again only after the initial changes are applied and the table is back in a consistent state.

B - The BEFORE keyword should be used, because triggers can query the table or change it again only after the initial changes are applied and the table is back in a consistent state.

C - None of the points in a. and b.

D - Both of the points in a. and b.

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

A - PL/SQL packages are schema objects that groups logically related PL/SQL types, variables and subprograms.

B - A package has two parts: Package specification and Package body or definition.

C - Both the parts are mandatory.

D - None of the above.

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 - Which of the following is not true about the comparison methods?

A - These are used for comparing objects.

B - The Map method is a function implemented in such a way that its value doesn’t depend upon the value of the attributes.

C - The Order methods implement some internal logic for comparing two objects.

D - None of the above.