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

What is different type of rman backup?

722

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

627

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

570

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

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

602

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

677

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

622

What parameters control copy latches?

638

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

713

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

613

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

1 1083

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

609

What is explain plan and how is it used?

657

What is the purpose of the grep command?

1 2198

How do you set up tablespaces during an oracle installation?

657

Un-Answered Questions { Oracle }

How to connect ms access to oracle servers?

1061

How many types of cluster table in Oracle?

1084

What is a trigger and what are its types?

1335

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1072

Explain the difference between sql and oracle?

1131

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1962

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2311

How to define a cusotmer as a supplier in ORACLE R12

2310

What is the simplest tool to run commands on oracle servers?

1057

Explain joins in oracle?

1094

Why more redos are generated when the oracle database is in begin backup mode?

1175

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

611

What are the restrictions in a oracle read only transaction?

1087

Explain the use of show option in imp command.

1155

Tell me about standby database? What should we watch out for?

592

For More Un-Answered { Oracle } Questions Click Here