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

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

What is the purpose of scan?

What is the function of cache fusion in oracle rac?

material view and view disadvantages?

1073

How many types of tables supported by oracle?

1076

How to select some rows from a table in oracle?

1077

How to connect to a local oracle 10g xe server?

992

How to use subqueries with the in operator using oracle?

1091

Can select statements be used on views in oracle?

1027

How to use "while" statements in oracle?

1325

How to sort the query output in oracle?

1028

How to use null as conditions in oracle?

1083

How to use "for" statements in oracle?

1073

How to use group functions in the select clause using oracle?

1071

What is transport network substrate (tns) in oracle?

1046

Un-Answered Questions { Oracle }

What is explain plan and how is it used?

606

Can the query output be sorted by multiple columns in oracle?

992

What do you understand by the term 'normalization'?

673

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

582

How many types of dimensions in oracle?

578

How do I become a database administrator?

572

How would you go about verifying the network name that the local_listener is currently using?

2049

What parameters control copy latches?

592

IS it possible to built the oracle database without setting the kernal parameters?

2347

Explain an exception?

993

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2521

What is using clause and give example?

1039

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

689

How to assign a tablespace to a users in oracle?

1048

What is a dead lock in oracle?

1121

For More Un-Answered { Oracle } Questions Click Here