GeekInterview.com
  I am new, Sign me up!
 

PL/SQL Interview Questions


PL/SQL Interview Questions

Questions: 241
Comments: 1044
 PL/SQL Tags
 Showing Questions 71-80 of 241 Questions
<< Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
 Sponsored Links

 
 PL/SQL Interview Questions
Sorting Options :  

What is Pragma Init Exception ? what is difference between user defined exception and init pragma exception. what is the use of it.  
Latest Answer: You trap a nonpredefined Oracle server error by declaring it first, or by using the OTHERS handler. The declared exception is raised implicitly. In PL/SQL, the PRAGMA EXCEPTION_INIT tells the compiler to associate an exception name with an Oracle error ...

Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter 
Latest Answer: Thanks parweej, alter trigger disable worked for me.. ...
Read Answers (3) | Asked by : Pavan

Latest Answer: Disadvantages of Triggers    It is easy to view table relationships , constraints, indexes, stored procedure in database but triggers are difficult to view.    Triggers execute invisible to client-application. They are not ...
Read Answers (2) | Asked by : Pavan

if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible 
Latest Answer: you can select the table for updationfor eg: select * from emp for update;no you can do the update/insert anything you want... any other user or session would be able to do any insert/update to the same table only after you release the table by commit ...

What is Force View. Why Oracle Give Facility to create force view? What is the use of force View 
Latest Answer: A view can be created even if the defining query of the view cannot be executed, as long as the CREATE VIEW command has no syntax errors. We call such a view a view with errors. For example, if a view refers to a non-existent table or an invalid column ...

Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P 
Latest Answer: Three types of parameter modes1) IN parameter mode- This mode is used to pass values to the calling module when invoked. The value of IN parameter can't be changed in the module. 2) OUT parameter mode -This mode is used to return a value to the main ...

Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample 
Latest Answer: A mutating error comes when u r trying to do some DML operation on a table that owns the trigger.... there are a lot of options to avoid mutation .. eg, Making it autonomous transaction or making it a statement level trigger ... or using ...

Latest Answer: PL/SQL tables are temporary array like objects used in a PL/SQL Block. The size of pl/sql table is unconstrained. For varrays we need to specify upperbound.Pl/sql tables can not be stored in database where as varrays can be stored in database.We can use ...
Read Answers (2) | Asked by : AT

Latest Answer: Pls try this link:http://www.databasejournal.com/features/oracle/article.php/1558021Cheers- Faizal ...
Read Answers (1) | Asked by : skdash78

Latest Answer: Disadvantage : 1) Executing DDL statements through dbms_sql sometime can result in deadlock. example : we are trying to drop one object at the time it is being accessed by other user. ...
Read Answers (4) | Asked by : ddkdhar
Tags : DBMS

View page << Previous 4 5 6 7 [8] 9 10 11 12 13 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