FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

PL/SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
46. What is the difference between Database triggers and Stored procedures?
 
    Triggers
  • Defined with CREATE TRIGGER
  • Data dictionary contains source code in USER_TRIGGERS
  • Implicitly invoked COMMIT, SAVEPOINT, and ROLLBACK are not allowed
    Procedures
  • Defined with CREATE PROCEDURE
  • Data dictionary contains source code in USER_SOURCE
  • Explicitly invoked COMMIT, SAVEPOINT, and ROLLBACK are allowed
Your Name Your Email-ID
Your Answer
 
47. What is a PL/SQL Package?
  A package is a schema object that groups logically related PL/SQL types, variables, and subprograms. Packages usually have two parts, a specification and a body; sometimes the body is unnecessary. The specification (spec for short) is the interface to the package. It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package. The body defines the queries for the cursors and the code for the subprograms.
Your Name Your Email-ID
Your Answer
 
48. What are the advantages of PL/SQL Packages?
 
  • Modularity
  • Easier Application Design
  • Information Hiding
  • Added Functionality
  • Better Performance
Your Name Your Email-ID
Your Answer
 
49. What is the maximum size of a LOB?
  4GB
Your Name Your Email-ID
Your Answer
 
50. What is set operators?
  Set operators combine the results of two queries into one result. INTERSECT returns all distinct rows selected by both queries. MINUS returns all distinct rows selected by the first query but not by the second. UNION returns all distinct rows selected by either query. UNION ALL returns all rows selected by either query, including all duplicates.
Your Name Your Email-ID
Your Answer