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

Oracle General (1803)
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?

1135

How many types of tables supported by oracle?

1130

How to select some rows from a table in oracle?

1130

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

1038

How to use subqueries with the in operator using oracle?

1144

Can select statements be used on views in oracle?

1088

How to use "while" statements in oracle?

1383

How to sort the query output in oracle?

1077

How to use null as conditions in oracle?

1131

How to use "for" statements in oracle?

1126

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

1136

What is transport network substrate (tns) in oracle?

1100

Un-Answered Questions { Oracle }

How to execute a stored procedure in oracle?

1151

How do I become a dba?

628

What is difference between logical standby database and physical standby database?

713

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2261

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.

5688

How can I learn oracle dba?

601

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1758

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

1977

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

What's dateware house and what's clustor with practicle example

2238

Give the various rollback segment states.

1095

How to drop an index in oracle?

1125

What is difference between cartesian join and cross join?

1169

Explain a data segment?

1112

Does oracle partitioning improve performance?

1054

For More Un-Answered { Oracle } Questions Click Here