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?

1017

Explain oracle data types with examples?

1028

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

1059

Explain compound trigger in oracle?

1038

Write a syntax for update query in oracle?

1034

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

1070

Please explain oracle data types with examples?

1068

What are the various constraints used in oracle?

1045

What is translate in oracle?

1096

Please explain drop constraint oracle?

1104

Who developed oracle & when?

1003

Explain oracle left join with an example?

1011

Explain joins in oracle?

1035

What is oracle latest version?

1095

What is an oracle and why it is used?

1148

Un-Answered Questions { Oracle }

What is package and main advantages?

606

What is the difference between a database and instance? What is the relation between them?

585

List out the types of joins.

1157

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7670

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1882

What is the relation of a user account and a schema in oracle?

1080

What is snapshot is too old? Give and example for better understand.

1602

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

I have applied the following commands: now what will happen, will the database will give an error / it will work?

548

What is a server parameter file in oracle?

1056

Explain the various types of oracle report?

1070

Tell me about standby database? What should we watch out for?

547

What are the uses of Oracle Rollback Segment?

1125

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1014

What are dba privileges?

534

For More Un-Answered { Oracle } Questions Click Here