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 dynamic sql in oracle?

1072

Please explain joins in oracle?

1062

What are the types of trigger in oracle?

982

Explain oracle 12c new features for developers?

1058

Please explain compound trigger in oracle?

1057

Explain drop constraint oracle?

1067

What is an oracle?

1018

What is the difference between primary key and unique key and foreign key in oracle?

982

what is the difference between substr and instr function in oracle?

1090

Explain the difference between sap and oracle?

1029

What is oracle join syntax?

1003

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

Mention what are the benefits of oracle rac?

Mention what is the volume management techniques used in oracle rac?

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

Un-Answered Questions { Oracle }

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?

What do you understand by format trigger?

What is tkprof?

How to export your own schema?

1007

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

How to pass a cursor variable to a procedure?

1109

How different is ms access and oracle?

1038

How can I see all tables in oracle?

1010

How oracle flex asm works?

Explain the use of rows option in imp command.

1085

How will you identify oracle database software release?

1010

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

597

What are the types of data contol?

614

What is the relation between database and instance?

644

For More Un-Answered { Oracle } Questions Click Here