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

Oracle General (1803)
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.

1033

How do you find current date and time in oracle?

1106

What is a snapshot in oracle database?

1075

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

1124

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

1127

How to load excel data sheet to oracle database

1080

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

1 1582

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

1032

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

1132

what is the dual table in oracle?

1045

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

1113

What is oracle update statement with inner join ?

1121

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

1044

How to convert csv to table in oracle?

1050

What is the string concatenation operator in oracle?

1236

Un-Answered Questions { Oracle }

What is the difference between translate and replace?

1118

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

641

What is File steps?

673

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1170

How to invoke the original export import utilities?

1139

How to display row numbers with the records?

1144

What is a nested table?

1113

What is the finger command?

619

Describe an oracle table?

1105

What is a canvas in oracle forms?

1119

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2211

What is the sid in oracle?

1036

Difference between lexical and bind varible.

What is the difference between recovery and restoring of the oracle database?

1297

Explain what are the uses of rollback segment?

1069

For More Un-Answered { Oracle } Questions Click Here