DBSkool Header Image Background

Category: PL/SQL_MCQPage 1 of 2

Creating Triggers & Applications for Triggers

1. Which statements are true? (Choose all that apply) A. If errors occur during the compilation of a trigger, the trigger is still created. B. If errors occur…

Manipulating Large Objects

1. How can you migrate from a LONG to a LOB datatype for a column? A. Use the DBMS_MANAGE_LOB.MIGRATE procedure B. Use the UTL_MANAGE_LOB.MIGRATE procedure C. Use the…

Managing Dependencies

1. Which three are true statements about dependent objects? (Choose three) A. Invalid objects cannot be described. B. An object with status of invalid cannot be a referenced…

Design Considerations for PL/SQL Code

1. All unnamed, programmer-defined exception that are user in the application and the error numbers are— A. -1 through -19999 B. -20000 through -20999 C. -20000 through -40000…

Using Dynamic SQL

1. Every SQL statement must be___ A. Bind B. Execute C. Parsed D. Fetched Answer: C 2. Parse statement checking____ A. Logic B. Syntax C. Variable D. References…

Utilizing Oracle-Supplied Packages in Application Development

1. What happens during the execute phase with Dynamic SQL for data manipulation language (INSERT, UPDATE, and DELETE) operations? A. The rows are selected and ordered. B. The…

Using More Package Concepts

1. Examine this code: CRATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10 ; PROCEDURE reset_comm ( p_comm IN NUMBER ) ; END comm._package ;/ User Jones…

Creating Packages

1. Which two programming constructs can be grouped within a package? (Choose two) A. Cursor B. Constant C. Trigger D. Sequence E. View Answer: A, B 2. Which…

Creating Functions & Debugging Subprogram

1. Which statement is true? A. Stored functions can be called from the SELECT and WHERE clauses only. B. Stored functions do not permit calculations that involve database…

Creating Procedures

1. Examine This code: CREATE OR REPLACE PROCEDURE add_dept ( p_dept_name departments.department_name%TYPE DEFAULT ‘Unknown’, p_loc dedartments.location_id%TYPE DEFAULT 1700 ) IS BEGIN INSERT INTO departments ( department_id, department_name, location_id…