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?

1019

Explain oracle data types with examples?

1028

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

1059

Explain compound trigger in oracle?

1039

Write a syntax for update query in oracle?

1034

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

1072

Please explain oracle data types with examples?

1069

What are the various constraints used in oracle?

1045

What is translate in oracle?

1098

Please explain drop constraint oracle?

1104

Who developed oracle & when?

1003

Explain oracle left join with an example?

1011

Explain joins in oracle?

1036

What is oracle latest version?

1096

What is an oracle and why it is used?

1150

Un-Answered Questions { Oracle }

You see multiple extents in the temporary tablespace. Is this a problem?

591

Explain the use of Merge statement in oracle 11g

1027

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

982

What is the difference between online and offline backups?

1059

Explain the term 'oracle grid architecture'?

587

Explain the use of consistent option in exp command.

1066

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

What is truncate oracle?

971

Why do we need a database?

595

what are savepoint mode and cursor mode properties ?

What are the ansi data types supported in oracle?

947

Mention what are the tools provided in oracle enterprise manager?

Can you tell me how to add new column in existing views?how?How is possible?

1445

What is an Oracle Rollback Segment?

1119

What is a parameter file in oracle?

1134

For More Un-Answered { Oracle } Questions Click Here