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?

1071

Please explain joins in oracle?

1060

What are the types of trigger in oracle?

979

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?

980

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 }

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

what is the scenario where you take the database to NoArchivelog mode?

2330

How many categories of data types in oracle?

1029

What do you understand by the oracle?

551

how to make an oracle object

2359

What do you mean by redo log file mirroring?

1030

suppose I having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?

791

What view would you use to determine free space in a tablespace?

2224

How to name query output columns in oracle?

1187

What are the benefits of oracle real application clusters (rac)?

Explian File steps in ODI?

623

What are functions of dba?

551

What is the anchoring in reports?

Explain do view contain data?

1010

Is oracle an operator?

923

For More Un-Answered { Oracle } Questions Click Here