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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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

931

How do you find current date and time in oracle?

997

What is a snapshot in oracle database?

979

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

1011

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

1022

How to load excel data sheet to oracle database

979

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

1 1412

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

942

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

993

what is the dual table in oracle?

940

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

1002

What is oracle update statement with inner join ?

1006

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

965

How to convert csv to table in oracle?

936

What is the string concatenation operator in oracle?

1110

Un-Answered Questions { Oracle }

how to handle exceptions?

572

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2158

Â What are the oracle DML commands possible through an update strategy?

1014

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

1040

What is a dba?

553

How to add a new column to an existing table in oracle?

1090

What is the difference between translate and replace in oracle?

1126

How can you find your id on a system?

526

What is the recommended interval at which to run statspack snapshots, and why?

2879

Why are recursive relationships bad? How do you resolve them?

532

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

1818

Explain user account with reference to oracle.

937

Explain what are the different type of segments?

920

How to insert multiple rows with one insert statement in oracle?

1032

What is the normalization?

548

For More Un-Answered { Oracle } Questions Click Here