Interview Questions For Pl/Sql,Sql,Oracle

1 :- Joins :- Equijoin,left, right

2 :- If there are two matching rows in one table and 1 row in ,in inner join how many rows will returned?

3:- Types of indexes?

4:- Primary and secondary Key

5:- Can we pass null values in foreign key?

6 :- triggers, cursors?

7 :- how to find out error in procedures?

 8:- Left join/right Join

 9 :- Procedures

10 :- Collections in PL/SQL :- http://www.oracle.com/technetwork/issue-archive/2012/12-jul/o42plsql-1653077.html

11 :- Function over loading

Collections are used in some of the most important performance optimization features of PL/SQL, such as

• BULK COLLECT. SELECT statements that retrieve multiple rows with a single fetch, increasing the speed of data retrieval.
• FORALL. Inserts, updates, and deletes that use collections to change multiple rows of data very quickly
• Table functions. PL/SQL functions that return collections and can be called in the FROM clause of a SELECT statement.

13 :- Performance tuning :- Adding hint/removing hint:- use_hash,use_nl
14 :- Index/No index
15.RMAN