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.

979

How do you find current date and time in oracle?

1047

What is a snapshot in oracle database?

1025

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

1061

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

1076

How to load excel data sheet to oracle database

1024

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

1 1495

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

977

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

1055

what is the dual table in oracle?

991

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

1053

What is oracle update statement with inner join ?

1059

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

999

How to convert csv to table in oracle?

989

What is the string concatenation operator in oracle?

1177

Un-Answered Questions { Oracle }

What do you understand by anchoring in reports?

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2953

What is the oracle implicit cursor?

1062

How many types of dimensions in oracle?

578

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

How do I become a dba?

582

Give the various exception types.

992

what is the dual table in oracle?

991

Does oracle partitioning improve performance?

992

What is a sub query and what are the different types of subqueries?

1125

How to uncatalog backup?

566

What is the difference between media recovery & crash recovery?

Explain the use of table functions.

2483

What is explain plan and how is it used?

606

Explain what does a control file contain?

1098

For More Un-Answered { Oracle } Questions Click Here