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 3744

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

CSC,

2 16809

how do get database name at sql prompt?

3 7054

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

2321

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

1855

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

2 4995

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

6 9067

what are archived logs?

2193

what are bitmap indexes? How does they work?

2232

what are the database links ?

2 4755

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

1 3849

what are different types of locks?

6 8575

master table and child table performances and comparisons in Oracle ?

2131

what are the different types of cursors? explain?

4 10192

what are different types of deletes?

1 3747

Un-Answered Questions { Oracle }

What is transport network substrate (tns) in oracle?

1040

If you see statistics that deal with "undo" what are they really talking about?

643

Explain the use of online redo log files in oracle.

1034

What is oracle log switch?

605

What is a subquery in oracle?

1099

What is set operator oracle?

969

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

How to view the data files in the current database?

1094

How to install oracle database 10g xe?

1010

When configuring sqlnet on the client what files need to be set up?

635

What is rac?

Is there an oracle sql query that aggregates multiple rows into one row?

968

What is an oracle table?

981

What are the key components of oracle’s maximum availability architecture?

Give one method for transferring a table from one schema to another?

598

For More Un-Answered { Oracle } Questions Click Here