You are not logged in.

#1 2012-03-28 05:02:56

AgentVinod12
User RankUser RankUser RankUser RankUser RankUser Rank
Agent Vinod
From: India
Registered: 2012-03-23
Posts: 1,149
Website

Oracle PL-SQL Interview Questions And Answers

Oracle Database :: Oracle PL-SQL Job Interview Questions and Answers

Oracle PL-SQL Interview Questions and Answers will help you to face a successful Oracle PL-SQL Interview and get hired, here you can learn PL-SQL of Oracle database also and update your knowledge and get preparation for a better job in Oracle PL SQL, So learn PL-SQL with the help of this Oracle PL-SQL Interview Questions with Answers guide

1 What is difference b/w stored procedures and application procedures, stored function and application function?
2 Explian rowid, rownum?what are the psoducolumns we have?
3 what is the starting oracle error number?what is meant by forward declaration in functions?
4 In a Distributed Database System Can we execute two queries simultaneously? Justify?
5 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?
6 How to avoid using cursors? What to use instead of cursor and in what cases to do so?
7 State the difference between implict and explict cursors?
8 How to know the last executed procedure?
9 How can a function retun more than one value in oracle with proper example?
10 If the application is running very slow? At what points you need to go about the database in order to improve the performance?
11 What is the basic structure of PL/SQL?
12 What are the components of a PL/SQL block?
13 What are the datatypes a available in PL/SQL?
14 What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
15 What is difference between % ROWTYPE and TYPE RECORD?

2012-03-28 05:02:56

Advertisement
Ads By Google

Re: Oracle PL-SQL Interview Questions And Answers



\n
The following user say "Thank You" for this post:Guest
The following user say "Thank You" for this post:Guest
The following user say "Thank You" for this post:Guest

#4 2012-03-28 05:11:07

The following user say "Thank You" for this post:Guest

Board footer