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.

935

How do you find current date and time in oracle?

1002

What is a snapshot in oracle database?

985

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

1015

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

1032

How to load excel data sheet to oracle database

983

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

1 1418

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

949

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

998

what is the dual table in oracle?

944

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

1006

What is oracle update statement with inner join ?

1008

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

970

How to convert csv to table in oracle?

941

What is the string concatenation operator in oracle?

1117

Un-Answered Questions { Oracle }

What is the function of having virtual internet protocol address (vip) in oracle rac?

How to write date and time interval literals in oracle?

995

How do you put database is archivelog mode, explain procedure?

518

Is there any link between pr form(purchse requisition)and po form(purchase order)

2677

Difference between bind parameter and lexical parameter.

how do u setup a replication site?

1942

What is a tns service name?

960

What are the execution control statements in oracle?

1044

Why do we need oracle client?

901

ABOUT IDENTITY?

2015

What is package and main advantages?

564

What are nested tables?

1121

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1879

What is a table index?

1029

How to build data dictionary view an new database?

975

For More Un-Answered { Oracle } Questions Click Here