1-30

Which type of an exception below does not exist?

A) NO_CURSOR_FOUND

B) TOO_MANY_ROWS

C) INVALID_CURSOR

D) ZERO_DIVIDE

What is meaning of keyword SQLERRM?

A) a special type of exception

B) is used to retrieve the error message

C) returns the numeric value for the error code

D) wrong SQL statement

What is meaning of keyword SQLCODE?

A) returns the numeric value for the error code

B) is used to retrieve the error message

C) notifies that insert error occurs

D) wrong SQL statement

What type of procedure allows invoking user-defined exception?

A) EXCEPTION

B) PRAGMA EXCEPTION_INIT

C) SQLERRM

D) RAISE

What type of procedure is used to retrieve the error message?

A) EXCEPTION

B) PRAGMA EXCEPTION_INIT

C) SQLERRM

D) RAISE

What keyword shows the section of program which traps use-defined exceptions?

A) EXCEPTION

B) PRAGMA EXCEPTION_INIT

C) SQLERRM

D) RAISE

What type of function is used to associate the declared exception with the standard Oracle server error number?

A) EXCEPTION

B) PRAGMA EXCEPTION_INIT

C) SQLERRM

D) RAISE

What type of function is used to return the numeric value for the error code?

A) EXCEPTION

B) PRAGMA EXCEPTION_INIT

C) SQLERRM

D) SQLCODE

Which of the following is NOT an iteration statement supported by PL/SQL:

A) The FOR LOOP statement.

B) The LOOP UNTIL statement.

C) The WHILE LOOP statement.

D) None of the above.

104. Look at this PL/SQL block: DECLARE v_count NUMBER; BEGIN SELECT COUNT(*) INTO v_count FROM employees WHERE salary > 50000; END; No employees earn more than $50,000. Which of the following statements are true?

The SELECT will return value 0 into V_COUNT. (*)

The SELECT will fail because it does NOT return exactly one row.

The block will fail because variable V_SALARY was not declared.

The block will fail because no results are displayed to the user.

. Look at this PL/SQL block: DECLARE v_count NUMBER; BEGIN SELECT COUNT(*) INTO v_count FROM employees WHERE salary > 50000; END; No employees earn more than $50,000. Which of the following statements are true?

The SELECT will fail because it does NOT return exactly one row.

The block will fail because variable V_SALARY was not declared.

The block will fail because no results are displayed to the user.

The SELECT returns exactly one row.

Which one of these SQL statements can be directly included in a PL/SQL executable block?

IF... THEN...;

INSERT INTO...;

SELECT * FROM DUAL;

SHOW USER;

Which of the following is NOT a valid guideline for retrieving data in PL/SQL?

Terminate the SQL statement with a semicolon (;)

Do NOT use a WHERE clause in SELECT statements.

Where possible, declare variables using the %TYPE attribute.

Specify the same number of variables in the INTO clause as database columns in the SELECT clause.

112. Look at the following block: DECLARE v_date DATE := SYSDATE; BEGIN WHILE v_date < LAST_DAY(v_date) LOOP v_date := v_date + 1; END LOOP; DBMS_OUTPUT.PUT_LINE(v_date); END; If today's date is 17th April 2007, what will be displayed when this block executes?

01-MAY-07

31-DEC-07

4/30/2007

4/17/2007

Which statement best describes when a FOR loop should be used?

When an EXIT WHEN statement must be coded.

When an implicitly declared counter must increase by 1 in each iteration of the loop.

When we want to exit from the loop when a Boolean variable becomes FALSE.

When the statements inside the loop must execute at least once.

Look at this code fragment: FOR I IN 1 .. 3 LOOP I := 4; DBMS_OUTPUT.PUT_LINE('The counter is: ' || i); END LOOP; How many lines of output will be displayed?

One

Three

Four

The block will fail because you cannot change the value of I inside the loop.

You want a loop that counts backwards from 10 through 1. How do you code that?

FOR I IN 10 .. 1 LOOP

FOR I IN 1 .. 10 BY -1 LOOP

FOR I IN REVERSE 1 .. 10 LOOP

FOR I IN REVERSE 10 .. 1 LOOP

When declared using %TYPE, a variable will inherit from the column on which it is based.

The name of the column

The value of the column

The data type and size of the column

None of the above

120. Examine the following variable declarations: DECLARE v_number NUMBER := 10; v_result NUMBER; Which of the following correctly assigns the value 50 to V_RESULT?

121. A function called FORMAT_TODAYS_DATE accepts no parameters and returns today's date in the format: Month DD, YYYY. The following anonymous block invokes the function: DECLARE v_today DATE; BEGIN -- invoke the function here Which of the following statements correctly assigns the date variable v_today to the value returned by the format_todays_date function?

Format_todays_date :v_today('Month DD, YYYY');

V_today :format_todays_date ('Month DD, YYYY');

V_today :format_todays_date(v_today);

V_today :TO_DATE(format_todays_date, 'Month DD, YYYY');

26. 124. Which of the following are PL/SQL data types? Index-by tables are often used:

Search thru very large databases

Is a new feature of Oracle 9i

To cache table values to give a performance boost in special situations, especially where frequent lookup is called for.

None of the above.

A PL/SQL block must consist of the following three sections. An Executable section starts with:

BEGIN

DECLARE

EXCEPTION

None of the above

Which one is the wrong answer? The %TYPE attribute:

Is used to declare a variable according to a database column definition

Is used to declare a variable according to a collection of columns in a database table or view

Is used to declare a variable according the definition of another declared variable

Is prefixed with the database table and column names or the name of the declared variable

) You can use most SQL single-row functions such as number, character, conversion, and date single-row functions in PL/SQL expressions.

True

False

4) When using the SELECT statement in PL/SQL, the INTO clause is required and queries can return one or more row.

True

False

Unlock and Upgrade

Remove all limits from your Quizzes

More Quizzes