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?

625

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

549

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

498

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?

534

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

523

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

581

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

540

What parameters control copy latches?

560

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

621

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

537

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

1 948

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

528

What is explain plan and how is it used?

553

What is the purpose of the grep command?

1 2057

How do you set up tablespaces during an oracle installation?

568

Un-Answered Questions { Oracle }

How to retrieve data from an cursor to a record?

1043

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1915

suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

717

What is pragma autonomous transaction in oracle?

1012

What is an oracle transaction?

1073

In oracle there is column command, how will you explain that?

991

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2280

what is load plans and types of load plans?

571

What is bulk copy or bcp in oracle?

1066

How to create a single index for multiple columns?

992

How to convert times to characters in oracle?

995

What is the use of Oracle Control File?

1029

How to convert a date to char in oracle? Give one example.

1015

Explain database link?

1070

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1978

For More Un-Answered { Oracle } Questions Click Here