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

Explain self joins in oracle?

958

Explain oracle data types with examples?

975

What do you mean by cdb and pdb in oracle 12c?

1022

Explain compound trigger in oracle?

990

Write a syntax for update query in oracle?

983

What is a trigger and what are its types in oracle?

1021

Please explain oracle data types with examples?

1009

What are the various constraints used in oracle?

1004

What is translate in oracle?

1058

Please explain drop constraint oracle?

1048

Who developed oracle & when?

959

Explain oracle left join with an example?

962

Explain joins in oracle?

989

What is oracle latest version?

1046

What is an oracle and why it is used?

1091

Un-Answered Questions { Oracle }

What is meant by joins?

1026

What are the constraints in odi?

575

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2220

How can we delete duplicate rows in a table?

943

How many file formats are supported to export data?

1156

What privilege is needed for a user to delete rows from tables in another schema?

1031

How to see free space of each tablespace?

985

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2017

What do you mean by a deadlock?

1025

Why do we need integrity constraints in a database?

985

Components of Oracle Data Integrator?

507

How many segment are present in Oracle Manufacturing

2278

How to get last row id?

950

Explain odi architecture?

579

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

For More Un-Answered { Oracle } Questions Click Here