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

Difference between inner join vs where ?

989

How to store only time; not date and time?

971

What is the minimum client footprint required to connect c# to an oracle database?

1030

Is there a combination of "like" and "in" in sql?

1016

How can I introduce multiple conditions in like operator?

933

How to load a large xml file?

1010

What is the difference between "as" and "is" in an oracle stored procedure?

951

is there a tool to trace queries, like profiler for sql server?

1096

What is the difference between a user and a schema in oracle?

994

What are the oracle differences between nvl and coalesce

1085

What is the best way to do multi-row insert in oracle?

1026

How do I spool to a csv formatted file using sqlplus?

977

What exactly do quotation marks around the table name do?

922

How to do paging with oracle?

958

How do I limit the number of rows returned by an oracle query after ordering?

1113

Un-Answered Questions { Oracle }

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1905

How to select some rows from a table in oracle?

1021

Point the difference between translate and replace?

1034

How to select all columns of all rows from a table in oracle?

1012

What is difference between logical standby database and physical standby database?

618

what is the difference between substr and instr function in oracle?

1047

Which data loaded are in target db?

531

What happens if the constraint name is left out of a constraint clause?

509

Have you attended the client meetings?

568

How to create a table in a specific tablespace?

925

What is tkprof and how is it used?

561

What are the extensions used by oracle reports?

1005

Explain the use of rows option in imp command.

1053

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2025

1. What is PO rate variance gain and loss?

2854

For More Un-Answered { Oracle } Questions Click Here