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

Mention what is the function of cache fusion in oracle rac?

Mention what are the file storage options provided by oracle database for oracle rac?

Mention what is oracle real application clusters?

Mention what is olr?

Mention in rac what files should be created on shared storage?

Mention what is cluster?

Mention what is the difference between single instance environment and rac environment?

Mention what is the difference between instance recovery and crash recovery?

Mention how oracle flex asm works?

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

Mention what are the tools provided in oracle enterprise manager?

Mention what are the key characteristics of rac or why to use rac?

Mention where does the clusterware write when there is a network or storage issue?

Mention what is new feature in oracle asm 12c?

Mention what is split brain syndrome in rac?

Un-Answered Questions { Oracle }

How to turn on or off recycle bin for the instance?

1023

What is bulk load in oracle?

1018

How you find which is the latest record in SCD type2 transformation?

554

What is oracle d2k?

What is odi studio?

552

defination of bitmap index

2060

What is the relation of a user account and a schema in oracle?

1021

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

652

What are the various benefits of using rac architecture?

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2823

what happened to the global index when I truncate the data in one of the partition?

1978

What is the scd? and Types of SCD?

582

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4563

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

1645

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2316

For More Un-Answered { Oracle } Questions Click Here