GeekInterview

What are various constraints used in SQL - NULLNOT NULLCHECKDEFAULT

What are various constraints used in SQL - NULLNOT NULLCHECKDEFAULT
Answer Question
Last Updated On : Nov 06, 2009 Answers: 8
Filed in : SQL Interview Questions

Oracle Compress Parameter - My database size is 100GB. I am using compress parameter. Will my database

Oracle Compress Parameter - My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen.
Answer Question
Asked by : Pragati.rch | Last Updated On : Nov 05, 2009 Answers: 1
Filed in : Oracle DBA Interview Questions

Using which language oracle is developed

Using which language oracle is developed
Answer Question
Asked by : jack_thomas | Last Updated On : Nov 05, 2009 Answers: 5
Filed in : Oracle Basics Interview Questions

What is the use of nocopy parameter in oracle procedure - Hi, What is nocopy parameter in oracle procedure.

What is the use of nocopy parameter in oracle procedure - Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P
Answer Question
Asked by : ily_saravanan | Last Updated On : Nov 05, 2009 Answers: 8
Filed in : PL/SQL Interview Questions

Referential Integrity Constraint - What is the role of Referential Integrity Constraint in Normalization

Referential Integrity Constraint - What is the role of Referential Integrity Constraint in Normalization
Answer Question
Asked by : leorence | Last Updated On : Nov 04, 2009
Filed in : Oracle FAQs

Referential Integrity Constraint - What is the role of Referential Integrity Constraint in Normalization

Referential Integrity Constraint - What is the role of Referential Integrity Constraint in Normalization
Answer Question
Asked by : leorence | Last Updated On : Nov 04, 2009
Filed in : Oracle FAQs

Sql query to get 4th or 5th maximum value from a table

Sql query to get 4th or 5th maximum value from a table
Answer Question
Asked by : ramaprasad | Last Updated On : Nov 04, 2009 Answers: 15
Filed in : Oracle SQL FAQ

How do I eliminate the duplicate rows

How do I eliminate the duplicate rows
Answer Question
Last Updated On : Nov 04, 2009 Answers: 12
Filed in : SQL and SQL Plus Interview Questions

Types of Triggers in Oracle

Types of Triggers in Oracle
Answer Question
Asked by : GIRISH H.R. | Last Updated On : Nov 02, 2009 Answers: 7
Filed in : PL/SQL FAQ

Recover data from database block corruption error - How to solve the database block corruption error

Recover data from database block corruption error - How to solve the database block corruption error even index also validated and recreated and dont have any backup.
Answer Question
Asked by : hemant.agarwal03 | Last Updated On : Nov 02, 2009 Answers: 1
Filed in : Oracle FAQs

How to Read .csv File - How to read columns from excel file (converted into .CSV format) into Forms

How to Read *.csv File - How to read columns from excel file (converted into *.CSV format) into Forms using upload button.
Answer Question
Asked by : mehra_narender | Last Updated On : Nov 01, 2009 Answers: 1
Filed in : Oracle FAQs

Dump Destination - What is dump destination What are bdump, cdump and udump Explain in detail.

Dump Destination - What is dump destination What are bdump, cdump and udump Explain in detail.
Answer Question
Asked by : gyanudba | Last Updated On : Oct 31, 2009 Answers: 4
Filed in : Oracle DBA Interview Questions

Force View - What is Force View. Why Oracle Give Facility to create force view What is the use of force

Force View - What is Force View. Why Oracle Give Facility to create force view What is the use of force View
Answer Question
Asked by : nitin_kumat | Last Updated On : Oct 29, 2009 Answers: 5
Filed in : PL/SQL Interview Questions

Acid Properties - What is Acid Properties in Oracle

Acid Properties - What is Acid Properties in Oracle
Answer Question
Asked by : kingfisher | Last Updated On : Oct 29, 2009
Filed in : Oracle FAQs

Acid Properties - What is Acid Properties in Oracle

Acid Properties - What is Acid Properties in Oracle
Answer Question
Asked by : kingfisher | Last Updated On : Oct 29, 2009
Filed in : Oracle FAQs

Null Value - How to handle Null value in WHERE Condition

Null Value - How to handle Null value in WHERE Condition
Answer Question
Asked by : anjinunna | Last Updated On : Oct 29, 2009
Filed in : Oracle SQL FAQ

Null Value - How to handle Null value in WHERE Condition

Null Value - How to handle Null value in WHERE Condition
Answer Question
Asked by : anjinunna | Last Updated On : Oct 29, 2009
Filed in : Oracle SQL FAQ

How to eliminate duplicate rows from a table leaving one from the duplicates

How to eliminate duplicate rows from a table leaving one from the duplicates
Answer Question
Last Updated On : Oct 29, 2009 Answers: 7
Filed in : SQL Interview Questions

How we can eliminate duplicates without using distinct command

How we can eliminate duplicates without using distinct command
Answer Question
Asked by : Suganthidinesh | Last Updated On : Oct 29, 2009 Answers: 8
Filed in : SQL Interview Questions

Difference between procedure and function. - Functions are named PL/SQL blocks that return a value and

Difference between procedure and function. - Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function...
Answer Question
Last Updated On : Oct 29, 2009 Answers: 13
Filed in : SQL Interview Questions