Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

when do u go for hash partitioning?

1 3676

what is RAID technology?which is better RAID 0+1 OR RAID 5?

CSC,

2 16674

how do get database name at sql prompt?

3 6943

what is the scenario where you take the database to NoArchivelog mode?

2273

does the query needs a hint to access a materialized view?

1825

what is analyze command ? what kind of statistics does it generate?

2 4921

how do u know the total no of rows in a table?

6 8913

what are archived logs?

2154

what are bitmap indexes? How does they work?

2191

what are the database links ?

2 4662

does the query needs a hint to access a materialized view?

1 3796

what are different types of locks?

6 8383

master table and child table performances and comparisons in Oracle ?

2083

what are the different types of cursors? explain?

4 10010

what are different types of deletes?

1 3656

Un-Answered Questions { Oracle }

How to do clean up if create database failed?

987

What is the sql query to find the employee who has Nth maximum salary?

5235

What are the differences between char and nchar in oracle?

1029

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5445

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2216

What is the purpose of the import option ignore? What is its default setting?

562

What are the possible ways to gain information regarding the control file?

515

Explain integrity constraints?

1066

How do we create privileges in oracle?

997

Why we use oracle d2k?

What is oracle instant client?

978

what is oracle forms?

1067

Which profile required to access solution in Designer tool?

551

Can we convert a date to char in oracle and if so, what would be the syntax?

969

How to delete a user account in oracle?

922

For More Un-Answered { Oracle } Questions Click Here