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

Explain the use of show option in imp command.

1062

What suggestions do you have to reduce the network traffic?

915

Explain the use of grant option in imp command.

973

Explain the dml?

930

Explain alias?

1098

Explain the use of constraints option in exp command.

1009

Explain index?

1218

How to create lov dynamically at runtime & attach to text field?

1119

Difference between hot backup vs. Cold backup?

953

How can we force the database to use the user specified rollback segment?

1091

What is a trace file and how is it created in oracle?

997

What do you mean by redo log file mirroring?

988

Explain the use of compress option in exp command.

982

Explain the use of parfile option in exp command.

1013

Explain the use of log option in exp command.

1064

Un-Answered Questions { Oracle }

How to login to the server without an instance?

1128

Who is dba in dbms?

533

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2081

What is the dynamic sql in oracle?

1027

What is difference between sid and service name in oracle?

919

Explain what are clusters?

1065

How to connect asp pages to oracle servers?

1025

When do we use group by clause in a sql query?

1003

What are the oracle differences between nvl and coalesce

1093

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2476

What is a private synonym?

1542

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

526

Respected sir, Please send me technical questions related to oracle apps..

1779

What do you understand by the term 'normalization'?

635

What is oracle update statement with inner join ?

1009

For More Un-Answered { Oracle } Questions Click Here