GeekInterview.com
  I am new, Sign me up!
 

PL/SQL Interview Questions


PL/SQL Interview Questions

Questions: 241
Comments: 1047
 PL/SQL Tags
 Showing Questions 1-10 of 241 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 PL/SQL Interview Questions
Sorting Options :  

What is the best technique of debugging large and fragmented dynamic SQL. 
Latest Answer: Better insert the dynamic SQL statement into a log table. To see the Exact query or if you have Quest Software (TOAD) use the SQL monitor or session browser to see what query executed. ...

Performance wise which is a better option if-else construct or a decode? Why  
Latest Answer: decode is much faster then If -Else because decode in built already have all the values of the column which we want to decode whereas in if - else statement  , we need to explicitly specify.please anyone correct me ...
Read Answers (2) | Asked by : test2008

You have a package called A and one function in that packgae called XYZ.If you need to call that function in second packaged B, How will you call? 
Latest Answer: Call the package.procedure (A.XYZ) in the other procedure. This is not possible if XYZ is a private procedure. ...
Read Answers (4) | Asked by : harit79

How will you stop an infinite loop without closing the program?  
Latest Answer: use the EXIT statementThis will stop the looping and proceed to the next executable statement.or EXIT WHEN condition ...

1) Why we use pl/sql array rather than cursor?2) In which condition we use function overloading? 3) What is pipe function?4) What is the mutating trigger? What should be the condition? 
Latest Answer: Triggers are PLSQL block or Procedures which get executed whenever:1) an INSERT, DELETE or UPDATE happens on a table. 2) DDL like ALTER or CREATE happens on a table. 3) an INSTEAD OF trigger on a view is issued - If a DML operation is issued on a view, ...
Read Answers (4) | Asked by : harit79

What is call by value and call by reference in parameters (IN, OUT, INOUT)? 
Latest Answer: In Parameter:: call by reference OUT Parameter: call by valueIN OUT Parameter: call by valueif you use the hint NOCOPY  with OUT Parameter and IN OUT Parameter then ::: call by reference ...
Read Answers (5) | Asked by : arunnaa

what is the difference between an explicit cursor and select into statement? 
Latest Answer: When a cursor name is explicitly assigned to a SELECT statement through CURSOR statement, it is called an explicit cursor. Explicit cursors are generally used to work with more than one row within PL/SQL. It has got the following attributes:1. Defining ...

How can we find the select statement is indexed or not? 
Latest Answer: 1. using AUTOTRACESQL> SET AUTOTRACE ON TRACEONLYSELECT *    FROM emp WHERE emp_name = 'ABC';2. Using EXPLAIN PLANSQL> EXPLAIN PLAN forSELECT *    FROM emp WHERE emp_name = 'ABC';The advantage ...
Read Answers (4) | Asked by : bmsrao

Why are we not supposed to include TCL statements in a trigger? 
Latest Answer: We cannot use TCL statements in triggers, because using them violates the integrity of the transaction. But if we want TCL statements to be used in triggers then that can be implemented by using Autonomous i.e. by providing PRAGMA AUTONOMOUS_TRANSACTION ...
Read Answers (4) | Asked by : bmsrao

Why PL/SQL does not support retriving multiple records? 
Latest Answer: Retriving multiple records is a basic feature of SQL where we fetch the data using SELECT statement.SELECT *  FROM emp;This itself gives us multiple records. There is no additional feature required to do the same in PL/SQL.At the same time, PL/SQL ...
Read Answers (4) | Asked by : bmsrao

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape