One way to drop database objects in a script without throwing errors and cancelling the script if the objects don't exist is to

A. use a PL/SQL block to drop the objects
B. use a PL/SQL block to drop the objects and use an IF statement to handle any errors that are thrown
C. use a PL/SQL block to drop the objects and ignore any exceptions
D. use a PL/SQL block to drop the objects and use a CASE structure to handle any errors that are thrown


Answer: C. use a PL/SQL block to drop the objects and ignore any exceptions

Computer Science & Information Technology

You might also like to view...

Variables of type float represent ______________ -precision floating-point numbers.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Access will automatically create a join line if the common field is designed as a primary key in two tables

Indicate whether the statement is true or false

Computer Science & Information Technology

Some parts of the operating system are resident; that is, these instructions remain on the hard disk until they are needed.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which is correct?

a) Use the size operator to determine the size of a structure. b) Use the struct size operator to determine the size of a structure. c) Use the sizeof operator to determine the size of a structure. d) Determine the size of a structure manually by carefully adding up the sizes of the members.

Computer Science & Information Technology