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 4737

What are disadvanteges of having raw devices ?

1 3857

What is the significance of having storage clause ?

1 4275

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

1 3780

What is dictionary cache ?

2 5268

Why query fails sometimes ?

1 4988

How does Space allocation table place within a block ?

1 4025

How will you monitor rollback segment status ?

2 5861

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

1 4012

What is advantage of having disk shadowing/ Mirroring ?

1 4177

How will you create multiple rollback segments in a database ?

1 4319

What is the functionality of SYSTEM table space ?

3 7622

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

1 3656

What is meant by free extent ?

2 5245

Un-Answered Questions { Oracle }

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

2135

How to define a variable of a specific record type?

1078

What is set verify off in oracle?

1102

How to clone the database using RMAN back

2237

How to loop through data rows in the implicit cursor?

1073

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297

How to use "while" statements in oracle?

1325

How can you find all the processes on your system?

570

Can migrate the one ORACLE DATA INTEGATOR studio to another ORACLE DATA INTEGATOR studio?

628

What is oracle real application clusters?

how to pass a variable more than one values?

650

How to set a transaction to be read only in oracle?

1093

How does one create a new database?

589

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4594

What are the predefined tablespaces in a database?

1081

For More Un-Answered { Oracle } Questions Click Here