Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 


 Interview Questions  
 Our Services  

PL-SQL Interview Questions and Answers

NEW INTERVIEW QUESTIONS.COM ORACLE INTERVIEW QUESTIONS PL-SQL INTERVIEW QUESTIONS QUESTIONS LISTING

PL-SQL Interview Questions & Answers


A D V E R T I S E M E N T





[ Page 1] Page 2 Page 3 Next

Newinterviewquestions.com: World's Largest Interview Questions Website.
Questions Question: how can a function retun more than one value in oracle with proper example?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How to know the last executed procedure?
Ratings Rating:
View Answer View Answer: Here

Questions Question: State the difference between implict and explict cursor's
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is difference b/w stored procedures and application procedures,stored function and application function..
Ratings Rating:
View Answer View Answer: Here

Questions Question: Explian rowid,rownum?what are the psoducolumns we have?
Ratings Rating:
View Answer View Answer: Here

Questions Question: 1)what is the starting "oracle error number"? 2)what is meant by forward declaration in functions?
Ratings Rating:
View Answer View Answer: Here

Questions Question: In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
Ratings Rating:
View Answer View Answer: Here

Questions Question: How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Ratings Rating:
View Answer View Answer: Here

Questions Question: How to disable multiple triggers of a table at at a time?
Ratings Rating:
View Answer View Answer: Here

Questions Question: can we declare a column having number data type and its scale is larger than pricesion ex: column_name NUMBER(10,100), column_name NUMBAER(10,-84)
Ratings Rating:
View Answer View Answer: Here

Questions Question: What are the Restrictions on Cursor Variables?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What will the Output for this Coding> Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
Ratings Rating:
View Answer View Answer: Here

Questions Question: If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is the basic structure of PL/SQL ?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What are the components of a PL/SQL block ?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What are the components of a PL/SQL Block ?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What are the datatypes a available in PL/SQL ?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
Ratings Rating:
View Answer View Answer: Here

Questions Question: What is difference between % ROWTYPE and TYPE RECORD ?
Ratings Rating:
View Answer View Answer: Here

[ Page 1] Page 2 Page 3 Next


 Sponsors  

Latest 10 Answers
When there is any situation that u should attach a new patch to ur kernel , then download the patch and install it,to make changes to kernel , go to ok prompt and type boot -r, it will update or reconfigure the kernel
Honesty, helpful and reliable
procedure is a set of sql statement ,are combined to gether to perform a specific task or to solve a specifi problem.it does not return value.
leadership is power to influence a group so that the members willingly exert efforts as aspired by the leader.
I have the unique combination of technical skill and the ability to build strong customer relationship. I have the ability to stay focussed in stressfull situation. I would be great addition to your team.
first execute the bc search spec to fetch the data then executes the applet search spec if applet search spec is not match with bc it skips
TCP-Transmission Control Protocol. TCP is Reliable. TCP is Connection oriented. UDP-User Datagram Protoco UDP is Unreliable. UDP is Connectionless.
By default in structure all data member and member function are public,i,e if you not mentation any access specifier. But in case of class By default all data member and member function are private.
Structure is a user defined data type. By default all structure variables are public type and we cann't use access specifier in structure type variable, where as in class we can define objects(variables) under required access specifier type.
variable cost is the cost which is not fixed in nature

Newinterviewquestions.com is a part of Vyom Network. Top



Copyright © 2017, newinterviewquestions.com. All rights reserved Privacy Policy | Terms and Conditions

Page URL: http://www.newinterviewquestions.com/cat/PL-SQL-interview-questions/Default.asp?cachecommand=bypass


Download Yahoo Messenger | Web Hosting | Dedicated Server | Free SMS Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains Quick2host Reviews Buy Online Traffic