Advanced Database Programming

PL/SQL is an Oracle proprietary, procedural, fourth-generation programming language. True or False?

• True

• False

In which three ways does PL/SQL extend the SQL programming language? (Choose all correct answers)

• By adding conditional control.

• By adding iterative control

• By adding procedural constructs.

• By adding compound constructs.

A program which specifies a list of operations to be performed sequentially to achieve the desired result can be called:

• procedural

• nondeclarative

• low level

• declarative

Which of the following statements is true? (Choose all correct answers)

• SQL is an ANSI-compliant, nonprocedural, fourth-generation programming language.

• PL/SQL is an Oracle proprietary, procedural, third-generation programming language.

• PL/SQL is an ANSI-compliant, procedural programming language.

• PL/SQL is an Oracle proprietary, procedural, fourth-generation programming language.

Which of the following statements is true?

• You can embed SQL statements within PL/SQL code.

• You can embed procedural constructs within SQL code.

• You can embed PL/SQL statements within SQL code.

• None of these are correct.

What are the characteristics of an anonymous block? (Choose two.)

• Stored in the database

• Can be declared as procedures or as functions

• Compiled each time the code is executed

• Unnamed

Which lines of code will correctly display the message "Hello World" ? (Choose two.)

• DBMS_OUTPUT.PUT_LINE('Hello' || 'World');

• DBMS_OUTPUT('Hello World');

• DBMS_OUTPUT.PUT_LINE('Hello World');

• DBMS_OUTPUT.PUT_LINE('Hello' || ' ' || 'World');

How can you display results to check that a PL/SQL block is working correctly?

• Use an Exception section

• You don't need to do anything, the results will display automatically.

• Use DBMS_OUTPUT.PUT_LINE

• Write a C or Java program to display the results

Given below are the parts of a PL/SQL block:

1. END;

2. EXCEPTION

3. DECLARE

4. BEGIN

Arrange the parts in order.

• 3,4,2,1

• 3,2,4,1

• 4,3,2,1

• 2,1,4,3

Which lines of code will correctly display the message "The cat sat on the mat"? (Choose two.)

• DBMS_OUTPUT.PUT_LINE('The cat sat on the mat');

• DBMS_OUTPUT.PUT_LINE('The cat' || 'sat on the mat');

• DBMS_OUTPUT.PUT_LINE(The cat sat on the mat);

• DBMS_OUTPUT.PUT_LINE('The cat sat ' || 'on the mat');