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

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

586

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

623

Discuss row chaining, how does it happen?

622

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?

641

How can you find dead processes?

586

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

650

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

601

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?

638

What is tkprof and how is it used?

660

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

626

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

582

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 do daily transactions with out sql* loader control file regesterd in apps?

1733

How to do a full database export?

1155

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

621

Can you have more than one content canvas view attached with a window ?

2375

Can we store pictures in the database and if so, how it can be done?

1094

What do you understand by row chaining?

What is variable and how many types of variable?

640

how report can be generated if we have the database designed in oracle 10g?

1945

How many types of dba are there?

617

What is Undo Management Advisor in Oracle?

1154

How to select an oracle system id (sid)?

1125

Explain rename?

1048

Mention how can you determine what protocol is being used for interconnect traffic?

What is the difference between cold backup and hot backup?

622

what is profile in odi?

703

For More Un-Answered { Oracle } Questions Click Here