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?

1062

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

1078

How to load excel data sheet to oracle database

1024

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

1 1496

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

980

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

1056

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?

990

What is the string concatenation operator in oracle?

1177

Un-Answered Questions { Oracle }

What is olr?

How to get last row id?

992

What is the difference between media recovery & crash recovery?

What is the Cdc?

701

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

589

Explain constraining triggers.

1094

How to move objects from DEV to QA and QA to PROD Environments?

716

How can you tell if a tablespace has excessive fragmentation?

599

Mention what are the main components of an oracle rac system?

How to create a new table in oracle?

1155

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2351

How do you prevent output from coming to the screen?

528

What is a subquery?

1122

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

For More Un-Answered { Oracle } Questions Click Here