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 }

What privilege is needed for a user to create tables in oracle?

953

can you convert or reverse engineer a fmx back to a fmb file?

1164

What is ASM (Automatic Storage Management) in Oracle?

1196

what are the API of GL,PO,AP

2267

How to convert a string to a date in oracle database?

1052

How to use subqueries with the in operator using oracle?

1091

What is the difference between truncate and delete? How would a full table scan behave after?

552

What is transaction control statement and how many types of transaction control statement in Oracle?

1155

How do you store pictures in a database?

1005

What do you understand by redo log file mirroring?

What is data type in oracle?

1125

What is an oracle user role?

984

What are the uses of Oracle Rollback Segment?

1126

What is oracle partial backup?

585

How to define an anonymous procedure with variables?

1158

For More Un-Answered { Oracle } Questions Click Here