|
Question |
Rating |
View Answer |
|
Differentiate between TRUNCATE and DELETE |
|
View Answer |
|
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? |
|
View Answer |
|
Can you use a commit statement within a database trigger? |
|
View Answer |
|
What is an UTL_FILE.What are different procedures and functions associated with it? |
|
View Answer |
|
Difference between database triggers and form triggers? |
|
View Answer |
|
What is OCI. What are its uses? |
|
View Answer |
|
What are ORACLE PRECOMPILERS? |
|
View Answer |
|
What is syntax for dropping a procedure and a function .Are these operations possible? |
|
View Answer |
|
Can a function take OUT parameters. If not why? |
|
View Answer |
|
Can the default values be assigned to actual parameters? |
|
View Answer |
|
What is difference between a formal and an actual parameter? |
|
View Answer |
|
What are different modes of parameters used in functions and procedures? |
|
View Answer |
|
Difference between procedure and function. |
|
View Answer |
|
Can cursor variables be stored in PL/SQL tables.If yes how. If not why? |
|
View Answer |
|
How you were passing cursor variables in PL/SQL 2.2? |
|
View Answer |
|
How you open and close a cursor variable.Why it is required? |
|
View Answer |
|
What should be the return type for a cursor variable.Can we use a scalar data type as return type? |
|
View Answer |
|
What is use of a cursor variable? How it is defined? |
|
View Answer |
|
What WHERE CURRENT OF clause does in a cursor? |
|
View Answer |
|
What a SELECT FOR UPDATE cursor represent. |
|
View Answer |