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 the difference between post-database commit and post-form commit?

1111

What is blob data type in oracle?

1052

What is the usage of analyze command in oracle?

1040

What is an oracle table?

936

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

922

How do you find current date and time in oracle?

991

What is a snapshot in oracle database?

976

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

1004

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1012

How to load excel data sheet to oracle database

970

What does `(+)` do in a where clause?

1 1401

Is there an oracle sql query that aggregates multiple rows into one row?

936

Why does oracle 9i treat an empty string as null?

982

what is the dual table in oracle?

935

Is there any function in oracle similar like group_concat of mysql?

992

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle server autotrace in oracle?

1094

What do you mean by merge in oracle and how can we merge two tables?

1006

How to enter a new row into a table interactively?

967

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1902

Explain the use of analyse option in exp command.

1069

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

935

What is ceil and floor in oracle?

1016

What is a dynamic performance view in oracle?

954

Why do we use bulk collect in oracle?

1013

Explain the importance of .pll extension in oracle?

958

what is difference between sql plus and sql*plus? (not sql and sql plus).

3824

How can we view last record added to a table?

974

What are data pump export and import modes?

1021

How to create a stored function in oracle?

1044

How to set a transaction to be read only in oracle?

1038

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