Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 $oracle_base and $oracle_home?

1141

State and explain the different types of data models?

1000

What is key preserved table?

1084

What is a sub query and what are the different types of subqueries?

1179

What are the different pseudo commands? Explain in general?

1129

Explain the different normalization forms?

1161

State the various uses of dbcc command?

1114

What are a collation and state the different types of collation sensitivity?

1252

State the difference between a primary key and foreign key?

999

What are the different types of trigger and explain its various uses and functions?

1175

Explain about functional dependency and its relation with table design?

1066

Explain about your project and its relation to the current job position you are applying to?

1080

What are privileges and grants?

1111

How to display row numbers with the records?

1144

What are the uses of linked server and explain it in detail?

1124

Un-Answered Questions { Oracle }

Describe the types of sub query?

1060

Describe varray?

1118

What is snapshot is too old? Give and example for better understand.

1659

What is integrity and what is constraint??Explain with example

2347

What is different types of joins?

1081

Is there any function in oracle similar like group_concat of mysql?

1113

What is a cursor in oracle?

1232

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2067

Differentiate between pre-select and pre-query?

1160

Give one method for transferring a table from one schema to another?

638

Is it possible to insert comments into sql statements return in the data model editor ?

2638

What are the variable types?

684

What is tns entry?

1245

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3106

How to assign data of the deleted row to variables?

1120

For More Un-Answered { Oracle } Questions Click Here