Chapter 5 - Market Segmenting, Targeting, and Positioning

Question 1

What is the basic syntax of a block?

Answer 1

DECLARE

BEGIN

EXCEPTION

END

Question 2

What are ‘Anonymous Blocks’?

Answer 2

When you click the run button you get ‘compile runs’

Question 3

What are ‘Named Block’?

Answer 3

When you click the run button you get ‘compiles’

P code is generated

Question 4

How would you declare a variable v_foo and assign it the value of 7?

Answer 4

v_foo NUMBER := 7;

Question 5

How would you assign the count of teachers in the COSC department from the teachers table?

Answer 5

SELECT COUNT(dept)
INTO v_count
FROM teachers
WHERE dept = ‘COSC’;

Question 6

Write this as a PL/SQL

If(grade>90) {
System.out.println(“A”);

} else if (grade>80) {
System.out.println(“B”);

} else {
System.out.println(“Fail”);

}

Answer 6

IF v_grade > 90 THEN
dbms_output.put_line(‘A’);

ELSIF v_grade > 80 THEN
dbms_output.put_line(‘B’);

ELSE
dbmd_output.put_line(‘Fail’);

END IF;

Question 7

Write this as a PL/SQL

while (i < 5) {
System.out.println(i);
i++;
}

Answer 7

WHILE i < 5 LOOP
dbms_output.put_line(i);
i := i + 1;
END LOOP;

Question 8

Declare variable v_name to be the same variable type as name from the WEEK4_Employees table

Answer 8

v_name WEEK4_Employees.name%TYPE;

Question 9

Print out “Hello World”

Include line needed to print lines

Answer 9

SET SERVEROUTPUT ON;

dbms_output.put_line(‘Hello World’);