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?

1029

Why do we use coalesce function in oracle?

1118

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

1058

How translate command is different from replace?

1083

How will you differentiate between varchar & varchar2?

1041

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

987

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

1029

What is the use of aggregate functions in oracle?

1026

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

994

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

1150

Why do we need integrity constraints in a database?

1019

Write a trigger example in oracle?

1061

Explain the difference between sql and oracle?

1076

Please explain oracle left join with an example?

1045

Explain the truncate in oracle?

966

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the use of file param in imp command?

1165

What is recovery manager in Oracle?

1055

List the various oracle database objects?

1057

How to create a temporary table in oracle?

1267

how may join possible between (requisition with purchase order)

2247

What are named parameters?

1089

What are group functions in oracle?

1040

What is data block in Oracle?

1116

How do you bind variables in oracle?

980

What are the types of partitions in oracle?

1036

Explain the difference between sap and oracle?

1029

What is pragma autonomous transaction in oracle?

1068

What is using clause and give example?

1038

What exactly do quotation marks around the table name do?

963

Can we connect to ORACLE db using Windows Authentication?

1256

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