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

How can you find out how many users are currently logged into the database? How can you find their operating system id?

538

What happens if a tablespace clause is left off of a primary key constraint clause?

581

Discuss row chaining, how does it happen?

569

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

604

How can you find dead processes?

539

I am getting error "no communication channel" after changing the domain name? What is the solution?

600

Discuss row chaining, how does it happen? How do you correct it?

549

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597

What is tkprof and how is it used?

608

As an oracle dba what are the entire unix file you should be familiar with?

579

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

537

Where does the clusterware write when there is a network or storage issue?

What is the difference between instance recovery and crash recovery?

What is the volume management techniques used in oracle rac?

What are the benefits of oracle rac?

Un-Answered Questions { Oracle }

What is oracle d2k? Why we use it?

What is null value in oracle?

1097

What are the benefits of ordbms?

1088

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

571

What is the purpose of save points in oracle database?

1118

What is index-organized table in Oracle?

1069

Will you be able to store pictures in the database?

1121

In what sequence do triggers get fired by oracle forms?

956

Explain the characteristics of oracle dba?

1120

What is the difference between formal parameters and actual parameters?

1088

What is difference between cartesian join and cross join?

1088

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2344

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3576

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

1123

What is an Oracle Rollback Segment?

1119

For More Un-Answered { Oracle } Questions Click Here