[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