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

1139

Please explain joins in oracle?

1112

What are the types of trigger in oracle?

1033

Explain oracle 12c new features for developers?

1127

Please explain compound trigger in oracle?

1111

Explain drop constraint oracle?

1123

What is an oracle?

1069

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

1037

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

1145

Explain the difference between sap and oracle?

1088

What is oracle join syntax?

1064

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 to get execution path reports on query statements?

1047

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2042

Explain view?

1094

What is a database instance?

633

What is a system tablespace?

1137

How do I reset a sequence in oracle?

1159

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2342

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2213

What are the functions of administration?

612

Difference between varchar and varchar2 data types?

1264

Whats the benefit of dbms_stats over analyze?

2068

How to lock and unlock a user account in oracle?

1165

How to rebuild an index in oracle?

1077

what are the tools used for oracle 10g in real time.

2502

For More Un-Answered { Oracle } Questions Click Here