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

What is different type of rman backup?

665

You see multiple fragments in the system tablespace, what should you check first?

584

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

534

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?

575

How do you set up your tablespace on installation level: low?

570

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

631

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

576

What parameters control copy latches?

592

What is difference between logical standby database and physical standby database?

673

What is the easiest method to create a file on unix?

570

using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?

1 1017

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

563

What is explain plan and how is it used?

607

What is the purpose of the grep command?

1 2143

How do you set up tablespaces during an oracle installation?

606

Un-Answered Questions { Oracle }

How to execute a stored procedure in oracle?

1091

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2195

What are the varoius components of physical database structure of oracle database?

1006

What is SQL access advisor in Oracle?

1189

What is variable? What is Flow of variable?

620

What do you understand by a database object? Can you list a few of them?

1018

Why we use bulk collect in oracle?

1044

Give the advantages and disadvantages of clusters.

1050

What are the benefits of ordbms?

1088

What is oracle real application clusters?

material view and view disadvantages?

1073

what is a package n what r the packages availbla in report

2096

What is current record attribute property?

Is it possible to execute a dynamic sql from forms?

1070

Which date function is used to find the difference between two dates?

578

For More Un-Answered { Oracle } Questions Click Here