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?

489

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

538

Discuss row chaining, how does it happen?

529

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?

566

How can you find dead processes?

512

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

551

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

504

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?

546

What is tkprof and how is it used?

561

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

547

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

505

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 }

How to speed up webrick?

1017

Explain the use of show option in imp command.

1062

In the oracle version 9.3.0.5.0, what does each number shows?

1248

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

514

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

550

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

If you are working Microsoft excel, which type of file you used .excel or .csv?

606

What are the various types of snapshots ?

990

In what sequence do triggers get fired by oracle forms?

923

can we implement package in package?

542

What is a trigger oracle?

1053

How to select all columns of all rows from a table in oracle?

1015

Can a formula column referred to columns in higher group ?

2472

Explain what are the characteristics of data files?

1045

What degree do database administrators need?

516

For More Un-Answered { Oracle } Questions Click Here