Oracle Database: Program with PL/SQL Quiz Questions and Answers

Which of the data types are supported by plsql?

Answer :
  • All of the above

Which of the following is true about the parameter modes in PL/SQL Subprograms?

Answer :
  • All of the above.

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;

Answer :
  • The cursor is not opened.

A Stored Procedure is a______.

Answer :
  • All of the above

PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content.

Answer :
  • TRUE

PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?

Answer :
  • All mentioned above

Like all identifiers, the names of constants, variables, and parameters are case sensitive.

Answer :
  • FALSE

Which of the following are used for displaying output on a web page?

Answer :
  • Both A & B

PL/SQL stands for -

Answer :
  • Procedural Language/SQL

Select invalid variable types.

Answer :
  • VARCHAR1