Oracle SQL Test 2

Question 1

When using explicit cursors, list the correct command sequence to process a batch of records.

Accepted Answer

OPEN, FETCH, CLOSE

Answer

CURSOR, FETCH, CLOSE

Answer

INITIALIZE, GET, CLOSE

Answer

CURSOR, GET, FETCH, CLOSE

Question 2

Choose variables that aren't valid.

Accepted Answer

VARCHAR1

Answer

NUMBER

Answer

CHAR

Answer

INTEGER

Question 3

Which of the following functions does not work as a grouping function?

Accepted Answer

DISTINCT

Answer

MIN

Answer

SUM

Answer

COUNT

Question 4

In the PL/SQL language, where do you declare an explicit cursor?

Accepted Answer

In the PL/SQL declaration section.

Answer

In the PL/SQL exception section

Answer

In the PL/SQL working storage section

Answer

In the PL/SQL body section.

Question 5

Select the PL/SQL looping construct that isn't valid.

Accepted Answer

LOOP ... UNTIL ;END LOOP;

Answer

LOOP ... EXIT WHEN ;END LOOP;

Answer

WHILE LOOP ...END LOOP;

Answer

FOR rec IN some_cursor LOOP ...END LOOP;

Question 6

Which of the following is not a DML function in Oracle?

Accepted Answer

TRUNCATE

Answer

NVL

Answer

TO_CHAR

Answer

DECODE

Question 7

Choose the most appropriate response from the options provided below. What comprises a package?

Accepted Answer

Specification and body

Answer

Specification and content

Answer

Header and body

Answer

Box, wrapping, and binding

Question 8

Which of the following Oracle PL/SQL exceptions is not valid?

Accepted Answer

TWO_MANY_ROWS ORA-01422

Answer

DUP_VAL_ON_INDEX ORA-00001

Answer

NO_DATA_FOUND ORA-01403

Answer

None of the above. These are all valid.

Question 9

Choose the incorrect variable declarations.

Accepted Answer

Foo_text varchar2(10) := 'hello world';

Answer

Foo_text number(10);

Answer

Foo_char char(1) := 'Y';

Answer

Foo_number varchar2(10);