Archive for September, 2007
- Difference between post query and pre query? | Posted by silpa on Sep 17 2007 under Uncategorized
- What is clustered index? | Posted by silpa on Sep 17 2007 under Uncategorized
- What are referenced object? | Posted by silpa on Sep 17 2007 under Uncategorized
- Steps involved in db shutdown? | Posted by silpa on Sep 17 2007 under Uncategorized
- Steps involved in db startup? | Posted by silpa on Sep 17 2007 under Uncategorized
- What is referential integrity? | Posted by silpa on Sep 17 2007 under Uncategorized
- Types of db links? | Posted by silpa on Sep 17 2007 under Uncategorized
- Types of segments? | Posted by silpa on Sep 17 2007 under Uncategorized
- Why use an index? | Posted by silpa on Sep 17 2007 under Uncategorized
- Difference between data block,extent and segment? | Posted by silpa on Sep 17 2007 under Uncategorized
- Difference between hot backup and cold backup? | Posted by silpa on Sep 17 2007 under Uncategorized
- Command used to encrypt pl/sql application? | Posted by silpa on Sep 17 2007 under Uncategorized
- Explain union,minus,union all,intersect? | Posted by silpa on Sep 17 2007 under Uncategorized
- Difference between SUBSTR and INTSTR? | Posted by silpa on Sep 17 2007 under Uncategorized
- What is library? | Posted by silpa on Sep 17 2007 under Uncategorized
- What are pl/sql exceptions and cursor exceptions? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between rowid and rownum? | Posted by silpa on Sep 11 2007 under Uncategorized
- What are common pseudo columns? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is one time procedure? | Posted by silpa on Sep 11 2007 under Uncategorized
- What are hints in oracle? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is nvl2 function? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between object lib and pl/sql library? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between groupby and orderby clause? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is normalization and differents forms of it? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between alias and synonym? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between foreign key and reference key? | Posted by silpa on Sep 11 2007 under Uncategorized
- What are actual and formal parameters? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is functional dependency? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between unique and primary key? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between truncate and delete? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is mutation of a trigger? When and why it occurs? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is Force view? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is p code and source code? | Posted by silpa on Sep 11 2007 under Uncategorized
- What are types of binding in pl/sql? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is bulk binding? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is exception handling in pl/sql? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is data concurrency and consistency? | Posted by silpa on Sep 11 2007 under Uncategorized
- What are the data types in pl/sql? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is cursor and its types? | Posted by silpa on Sep 11 2007 under Uncategorized
- What are the cursor attributes? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is the difference between %ROWTYPE and %TYPE? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between cursor and reference cursor? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between implicit and explicit cursors? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is high water mark? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is a two-phase commit? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is a snapshot? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is a distributed db? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is one time procedure? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is flashback in oracle 9i? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between db sever and data dictionary? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is the difference between instead of trigger,database trigger and schema trigger? | Posted by silpa on Sep 11 2007 under Uncategorized
- What is the use of analyze command? | Posted by silpa on Sep 11 2007 under Uncategorized
- Difference between SQL and PL/SQL? | Posted by silpa on Sep 11 2007 under Uncategorized