Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a nvl function?

1021

Why do we use coalesce function in oracle?

1112

What is the quickest way to fetch the data from a table?

1056

How translate command is different from replace?

1078

How will you differentiate between varchar & varchar2?

1039

What are the set operators union, union all, minus & intersect meant to do?

987

What is a nvl function? How can it be used?

1026

What is the use of aggregate functions in oracle?

1023

What do you mean by a database transaction & what all tcl statements are available in oracle?

992

What is a data dictionary and how can it be created?

1144

Why do we need integrity constraints in a database?

1017

Write a trigger example in oracle?

1055

Explain the difference between sql and oracle?

1075

Please explain oracle left join with an example?

1042

Explain the truncate in oracle?

965

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Can a parameter be passed to a cursor?

1118

What is recovery manager(rman) backup in Oracle?

1183

What is oracle host variable?

1056

How to assign query results to variables?

1048

What are joins, explain all types of joins?

2297

What are the components of logical database structure in oracle database?

1086

How to turn on or off recycle bin for the session?

1105

How to upsert (update or insert into a table)?

997

Is it possible to insert comments into sql statements return in the data model editor ?

2553

What is meant by recursive hints in oracle?

1084

What is an index associated with a constraint?

1035

Name the three major set of files on disk that compose a database in Oracle?

1119

How to set up autotrace for a user account?

1057

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2139

Does oracle charge for java?

1053

For More Un-Answered { Oracle General } Questions Click Here