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?

1041

What are the database administrators utilities available?

1031

What is system tablespace?

1097

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?

1044

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

1021

Un-Answered Questions { Oracle }

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

668

What are the constraints are used in Ur project?

550

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

1949

what is the difference between functional dependecy and multilevel dependency?

2462

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

765

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1078

What is the use of the Service Knowledge module?

588

When do I need to use a semicolon vs a slash in oracle sql?

1090

Explain integrity constraints?

1104

When do you get a .pll extension in oracle?

1146

What is a view and how is it different from a table?

1045

Explain the wait events in statspack report 'enqueue'?

577

Explain do view contain data?

1011

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

659

How can we generate report output in excel format?

997

For More Un-Answered { Oracle } Questions Click Here