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?

958

Why do we use coalesce function in oracle?

1053

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

1001

How translate command is different from replace?

1009

How will you differentiate between varchar & varchar2?

992

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

939

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

960

What is the use of aggregate functions in oracle?

981

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

934

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

1057

Why do we need integrity constraints in a database?

974

Write a trigger example in oracle?

983

Explain the difference between sql and oracle?

1026

Please explain oracle left join with an example?

960

Explain the truncate in oracle?

914

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to export data with a field delimiter?

971

How do I limit the number of rows returned by an oracle query after ordering?

1102

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

1001

How to drop an index?

910

What is merge in oracle?

997

How to create a new table in your schema?

1034

How to convert dates to characters in oracle?

987

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2056

Explain the blob datatype?

1016

what is the difference between data migration and production migration.

2276

How can I combine multiple rows into a comma-delimited list in oracle?

1001

How to calculate date and time differences in oracle?

994

How to select an oracle system id (sid)?

1020

What is a subquery?

1059

What are the different types of partitions in oracle?

911

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