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 3759

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

CSC,

2 16840

how do get database name at sql prompt?

3 7092

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

2333

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

1864

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

2 5009

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

6 9112

what are archived logs?

2205

what are bitmap indexes? How does they work?

2261

what are the database links ?

2 4780

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

1 3869

what are different types of locks?

6 8615

master table and child table performances and comparisons in Oracle ?

2139

what are the different types of cursors? explain?

4 10237

what are different types of deletes?

1 3772

Un-Answered Questions { Oracle }

What is a user function?

656

what is insert all statement in sql

6529

How to pass parameters to procedures?

1039

Why do we need integrity constraints in a database?

1027

What is flashback in Oracle?

1023

How to use "in out" parameter properly?

1053

What is recovery manager(rman) backup in Oracle?

1188

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1922

What is J2EE Agent and port number?

617

How to export data to a csv file?

1312

What is required by oracle rac database to connect to a network?

Explain drop constraint oracle?

1075

Explain the use of file option in exp command.

1134

What is hash cluster in oracle?

1176

What is where clause in oracle?

1032

For More Un-Answered { Oracle } Questions Click Here