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?

1026

Please explain joins in oracle?

1020

What are the types of trigger in oracle?

933

Explain oracle 12c new features for developers?

1006

Please explain compound trigger in oracle?

1008

Explain drop constraint oracle?

1004

What is an oracle?

962

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

933

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

1049

Explain the difference between sap and oracle?

993

What is oracle join syntax?

960

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 }

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

562

What is dba in sound level?

542

What are the roles of dba?

1033

What is the disk migration? what is the steps involved in oracle disk migration?

1183

How to check the server version in oracle?

1053

What are dba privileges?

495

How to download oracle database 10g xe?

966

What is the finger command?

546

What is package and main advantages?

561

What is a package in oracle?

1044

What is the parameter mode that can be passed to a procedure?

994

What is the best way to do multi-row insert in oracle?

1029

What is Virtual Private Database in Oracle?

1031

While taking hot backup (begin end backup) what will happens back end?

528

How to use windows user to connect to the server?

949

For More Un-Answered { Oracle } Questions Click Here