ORACLE INTERVIEW QUESTIONS & ANWSERS

[satishavula]

hi friends,
Can Any one had answers to ORACLE interview questions.
Pls help me my brother had to attend interview
next week.So I request you all can anybody have answers
pls send to me.It will be very helpful to my brother.

Thanks and regards
satish

[chandraismoon]

hi
here r some Oracle faq with me
hope it will be usefull

faq---------------

Normalization and types
Subquery and correlated subqueries
Primary key and candidate key
Primary key and reference key
Primary key and index
Index types and default index
Cursors and ref-cursor
Procedures and functions
Exceptions
SGA
Back ground process
Extent
Segment
Optimizer
Optimizer hints
Two phase commit
Explain plan
UTL
How to return value from procedure
what r the parameters used in proc & function
what is the use of declaring variables in package specification & package body?
Cursors and types
Cursor attributes
Cursor variables
What are packages?Advantage of Packages over Procedures
In Package Specification there are 2 Procedures declared? Can i write 3 Procedures in Package Body?
What Built in packages you have used
What do u mean by Static SQL and Dynamic SQL
What is an alternate to DBMS_SQL Package
What is Row Chaining
.
What are Triggers? Different Triggers
Can i write TCL commands in Triggers
what is Mutating Table
What are Instead of Triggers?
Types of Backup?
My SQL query is returning rows very slowly? What you will check in that to make it fast
If a procedure p1 having another procedure p2 ,I want to commit p2 and roll back p1 what to do?
I have a senario Emp Table has 10 Rows I have Written a Procedure in that procedure have opened a Cursor and stated fetching Rows one by one after 5 rows are fetched then Some one from other session has Inserted 5 Rows , Now in my cursor how many rows will be fetched
If I have given a update statement what it will do(Back end process)?



hope u may have answres to the queries
if not give reply iso i will try to provide u,now i don\'t have time

regds
Chandra

Post edited by: chandraismoon, at: 2004/09/20 14:52

[sanereddy]

Please check in our question bank, we have around 500 on Oracle.

[chandraismoon]

Hi Mr.Reddy
I am a Vaibhav,having access rights to access QB but the problem is I tried so many times to access the QB but I was failed.
Even I deleted cookies too

Can u help me
My id is Chandraismoon

[kalareddy]

You should update your details from the main site with proper information. You will not get access if you have invalid or incorrect information. Here is the link to update your details.


http://<br /> http://www.exforsys.c...amp;Itemid=149

[chandraismoon]

hi
what kind of wrong information i may provided

I couldn\'t get u

regds
vaibhav

[sanereddy]

Please check the your details in the registration Data,