PL/SQL Online Quiz

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

A - PL/SQL's general syntax is based on that of ADA and Pascal programming language.

B - Apart from Oracle, PL/SQL is available in TimesTen in-memory database and IBM DB2.

C - PL/SQL is tightly integrated with SQL.

D - It does not offer error checking.

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 not true about PL/SQL decision making structures?

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

B - The IF statement also adds the keyword ELSE followed by an alternative sequence of statement.

C - The IF-THEN-ELSIF statement allows you to choose between several alternatives.

D - PL/SQL does not have a CASE statement.

Q 4 - Consider the following code snippet: how many times the loop will run?

DECLARE
   a number(2);
BEGIN
   FOR a in 10 .. 20 LOOP
       END LOOP;
END;

A - 11

B - 10

C - 9

D - Infinite loop.

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 code will open a cursor named cur_employee?

A - OPEN cur_employee;

B - OPEN CURSOR cur_employee;

C - FETCH cur_employee;

D - FETCH CURSOR cur_employee;

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 optional [FOR EACH ROW] clause specifies

A - A table with index.

B - A table with primary key.

C - A row level trigger.

D - A table with a unique key.

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

A - The specification is the interface to the package.

B - It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package.

C - It contains all information about the content of the package and the code for the subprograms.

D - None of the above.

Q 9 - The collection method COUNT

A - Returns the last (largest) index numbers in a collection that uses integer subscripts.

B - Returns the number of elements that a collection currently contains.

C - Checks the Maximum Size of a Collection.

D - None of the above.

Q 10 - Which of the following is true about the inheritance for PL/SQL Objects?

A - PL/SQL allows creating object from existing base objects.

B - To implement inheritance, the base objects should be declared as NOT FINAL.

C - The NOT INSTANTIABLE clause allows you to declare an abstract object.

D - All of the above.