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

Difference between open_form and call_form in oracle.

1161

Explain an exception and its types?

1073

What are the different types of record groups in oracle? Explain each of them

1025

Explain the use of record length option in exp command.

1067

What is control file used for?

1209

Explain the use of inctype option in exp command.

1034

what are actual and formal parameters?

1104

Differentiate between translate and replace?

1117

Explain the use of rows option in imp command.

1085

Explain the use of rows option in exp command.

1091

Explain the use of tables option in exp command.

1116

Differentiate between post-database commit and post-form commit?

1041

Explain the use of full option in exp command.

1116

Difference between pre-select and pre-query

1108

Explain an exception?

994

Un-Answered Questions { Oracle }

What is a read only transaction in oracle?

1029

How many types of knowledge Modules? Where are used in km?

621

How can you find out how many users are currently logged into the database? How can you find their operating system id?

539

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

1197

Is the After report trigger fired if the report execution fails ?

2915

What is a synonym? What are its various types?

1110

Explain the use of online redo log files in oracle.

1037

What is required by oracle rac database to connect to a network?

How to use group functions in the select clause using oracle?

1072

Explain what are the uses of rollback segment?

1015

Components of Oracle Data Integrator?

548

How to use subqueries in the from clause in oracle?

1112

What os user should be used for the first part of an oracle installation (on unix)?

549

what is port in oracle? how is it related to database application.

1949

How will you run ms_batch file in forms?

For More Un-Answered { Oracle } Questions Click Here