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

Explain self joins in oracle?

1063

Explain oracle data types with examples?

1083

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

1112

Explain compound trigger in oracle?

1091

Write a syntax for update query in oracle?

1076

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

1157

Please explain oracle data types with examples?

1132

What are the various constraints used in oracle?

1106

What is translate in oracle?

1147

Please explain drop constraint oracle?

1161

Who developed oracle & when?

1061

Explain oracle left join with an example?

1064

Explain joins in oracle?

1094

What is oracle latest version?

1153

What is an oracle and why it is used?

1220

Un-Answered Questions { Oracle }

How can I see all tables in oracle?

1063

What is Session Tasks?

642

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2428

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2383

how do u setup a replication site?

2035

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

640

How would you go about increasing the buffer cache hit ratio?

2659

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4688

Will you be able to store pictures in the database?

1178

What is the oracle implicit cursor?

1115

What is the quickest way to export a table to a flat file?

1017

What is the Repository and how many types of repository?

636

How to unlock the sample user account in oracle?

1079

What are the general rules on data consistency?

1066

Is insert autocommit in oracle?

1134

For More Un-Answered { Oracle } Questions Click Here