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 are summary column and placeholder column in reports?

Explain the difference between repeating frame and frame.

Explain the benefits and uses lexical parameter.

What is ole automation?

What is the sequence of firing in report trigger?

What are record groups ?

What is path setting for dll?

What is transactional trigger property?

What are property classes?

What is iapxtb structure? Explain its importance

Difference between lexical and bind varible.

What are open_form,call_form,new_form?

What are the types of windows (window style)?

What are the file systems and volume management techniques used in oracle rac?

What are the conditions kept in mind while connecting the oracle rac with the network?

Un-Answered Questions { Oracle }

What is the maximum limit on the number of columns in a table?

1035

How to create a server parameter file?

1095

What is ASM (Automatic Storage Management) in Oracle?

1152

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2913

How many control files should you have?

561

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1349

What is Segment Advisor in Oracle?

1069

What do you mean by merge in oracle and how can we merge two tables?

1014

What is PL/SQL ?

1950

How to resolve the ORA-39133 error in Oracle?

1062

How do you set up tablespaces during an oracle installation?

570

What is a sub query? Describe its types?

977

What is procedure overloading in oracle?

1010

What is the difference between primary key and unique key and foreign key in oracle?

936

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1879

For More Un-Answered { Oracle } Questions Click Here