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 the difference between single instance environment and rac environment?

What is split brain syndrome in rac?

What are the key characteristics of rac or why to use rac?

What is olr?

What are the main components of an oracle rac system?

How oracle flex asm works?

What is new feature in oracle asm 12c?

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

How can you determine what protocol is being used for interconnect traffic?

What is oracle real application clusters?

When system tablespace is created?

986

What are the database administrators utilities available?

988

What is system tablespace?

1056

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

987

How does one get the view definition of fixed views/tables?

975

Un-Answered Questions { Oracle }

Explain the term 'oracle grid architecture'?

551

What is the function of having virtual internet protocol address (vip) in oracle rac?

Explian File steps in ODI?

592

Explain about party and customer in ar : oracle accounts receivable

1163

How to create a new table in your schema?

1050

How to define an oracle sub procedure?

1076

What is backup in Oracle?

966

Were you involved in any data conversion, which one?

Can select statements be used on views in oracle?

1002

How do we create privileges in oracle?

1004

How does one create a new database?

545

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

2319

Differentiate between function and procedure in oracle.

1032

What if your ocr (oracle cluster registry) is corrupted?

What do you mean by cdb and pdb in oracle 12c?

1024

For More Un-Answered { Oracle } Questions Click Here