PL/SQL Online Quiz

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

A - PL/SQL provides access to predefined SQL packages.

B - PL/SQL provides support for Object-Oriented Programming.

C - PL/SQL provides support for Developing Web Applications and Server Pages.

D - All of the above.

Q 2 - Which of the following is not true about large object data types and in PL/SQL?

A - BFILE is used to store large binary objects in operating system files outside the database.

B - BLOB is used to store character data in the database.

C - CLOB is used to store large blocks of character data in the database.

D - NCLOB is used to store large blocks of NCHAR data in the database.

Q 3 - Which of the following is true about the following code snippet?

DECLARE
   a number(3) := 100;
BEGIN
   IF (a = 50 ) THEN
      dbms_output.put_line('Value of a is 10' );
   ELSEIF ( a = 75 ) THEN
      dbms_output.put_line('Value of a is 20' );
   ELSE
       dbms_output.put_line('None of the values is matching');
   END IF;
   dbms_output.put_line('Exact value of a is: '|| a ); 
END;

A - It has syntax error.

B - It will print 'None of the values is matching'.

C - It will print

None of the values is matching

Exact value of a is: 100

D - None of the above.

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 true about PL/SQL cursors?

A - Explicit cursors are automatically created by Oracle.

B - Implicit cursors are programmer defined cursors.

C - The most recent implicit cursor is called the SQL cursor, and has the attributes like %FOUND, %ISOPEN, %NOTFOUND, and %ROWCOUNT.

D - All of the above.

Q 6 - The following code tries to fetch some information from all the rows in a table named customers for use in a PL/SQL block. What is wrong in the following code?

DECLARE
   c_id customers.id%type;
   c_name customers.name%type;
   c_addr customers.address%type;
   CURSOR c_customers is
      SELECT id, name, address FROM customers;
BEGIN
   LOOP
      FETCH c_customers into c_id, c_name, c_addr;
      EXIT WHEN c_customers%notfound;
      dbms_output.put_line(c_id || ' ' || c_name || ' ' || c_addr);
   END LOOP;
   CLOSE c_customers;
END;

A - It need not use a cursor.

B - The cursor is not opened.

C - It will not print information from all the rows.

D - There is nothing wrong in the code.

Q 7 - Which of the following is not a benefit of a database trigger?

A - Enforcing referential integrity

B - Event logging and storing information on table access

C - Allowing invalid transactions

D - Generating some derived column values automatically

Q 8 - Which of the following is a PL/SQL collection types?

A - Index-by tables or Associative array

B - Nested table

C - Variable-size array or Varray

D - All 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 code will create an object type named local_address with two field house_no and street?

A -

CREATE OR REPLACE OBJECT local_address 
(house_no varchar2(10),
 street varchar2(30),
 );

B -

CREATE OR REPLACE TYPE local_address AS OBJECT
(house_no varchar2(10),
 street varchar2(30),
 );

C -

CREATE OR REPLACE OBJECT  local_address AS 
(house_no varchar2(10),
 street varchar2(30),
 );

D -

CREATE OR REPLACE CLASS local_address 
(house_no varchar2(10),
 street varchar2(30),
 );