|
Question |
Rating |
View Answer |
|
Write the order of precedence for validation of a column in a table ? I. done using Database triggers. ii. done using Integarity Constraints. |
|
View Answer |
|
What is an Exception ? What are types of Exception ? |
|
View Answer |
|
What is Pragma EXECPTION_INIT ? Explain the usage ? |
|
View Answer |
|
What is Raise_application_error ? |
|
View Answer |
|
What are the return values of functions SQLCODE and SQLERRM ? |
|
View Answer |
|
Where the Pre_defined_exceptions are stored ? |
|
View Answer |
|
What is a stored procedure ? |
|
View Answer |
|
What is difference between a PROCEDURE & FUNCTION ? |
|
View Answer |
|
What are advantages fo Stored Procedures |
|
View Answer |
|
What are the modes of parameters that can be passed to a procedure ? |
|
View Answer |
|
What are the two parts of a procedure ? |
|
View Answer |
|
Give the structure of the procedure ? |
|
View Answer |
|
Give the structure of the function ? |
|
View Answer |
|
Explain how procedures and functions are called in a PL/SQL block ? |
|
View Answer |
|
What is Overloading of procedures ? |
|
View Answer |
|
What are two parts of package ? |
|
View Answer |
|
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ? |
|
View Answer |
|
How packaged procedures and functions are called from the following? a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS |
|
View Answer |
|
Name the tables where characteristics of Package, procedure and functions are stored ? |
|
View Answer |