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 will be a segment released?

1 4017

How can we plan storage for very large tables ?

1 4732

What are disadvanteges of having raw devices ?

1 3857

What is the significance of having storage clause ?

1 4272

What is meant by Redo Log file mirrorring ? How it can be achieved?

1 3778

What is dictionary cache ?

2 5266

Why query fails sometimes ?

1 4988

How does Space allocation table place within a block ?

1 4020

How will you monitor rollback segment status ?

2 5858

Which parameter in Storage clause will reduce no. of rows per block?

1 4009

What is advantage of having disk shadowing/ Mirroring ?

1 4175

How will you create multiple rollback segments in a database ?

1 4318

What is the functionality of SYSTEM table space ?

3 7618

List the factors that can affect the accuracy of the estimations ?

1 3653

What is meant by free extent ?

2 5242

Un-Answered Questions { Oracle }

Can we modify approve purchase order?if yes what is navigation?

2010

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

1694

Name the three major set of files on disk that compose a database in Oracle?

1123

what is port in oracle? how is it related to database application.

1949

What is the usage of synonyms?

1142

How to create a single index for multiple columns?

1037

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1846

What are the oracle differences between nvl and coalesce

1148

How to commit the current transaction in oracle?

1120

What are the different pseudo commands? Explain in general?

1080

What is the most common database language that a db administrator needs to know?

575

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2271

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

575

What does a dba stand for?

577

Difference between vat and property class.

For More Un-Answered { Oracle } Questions Click Here