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?

1114

What is blob data type in oracle?

1052

What is the usage of analyze command in oracle?

1043

What is an oracle table?

936

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

923

How do you find current date and time in oracle?

993

What is a snapshot in oracle database?

976

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

1006

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

974

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

1 1405

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

936

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

983

what is the dual table in oracle?

936

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

993

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Is it possible to split the print reviewer into more than one region ?

2228

What is different types of joins?

972

Explain the use of inctype option in exp command.

982

How many types of auditing in Oracle?

986

How to define an oracle cursor variable?

980

How to set up autotrace for a user account?

981

Give the various rollback segment states.

1005

What do you understand by database schema and what does it hold?

1185

What are privileges and grants?

1008

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1816

How to connect to the server with user account: sys?

979

Why oracle is used?

1003

Explain what are the characteristics of data files?

1038

Please explain oracle left join with an example?

965

What are the different editions of oracle?

1058

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