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

Difference between inner join vs where ?

1096

How to store only time; not date and time?

1070

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

1167

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

1124

How can I introduce multiple conditions in like operator?

1056

How to load a large xml file?

1110

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

1053

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

1202

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

1083

What are the oracle differences between nvl and coalesce

1243

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

1113

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

1092

What exactly do quotation marks around the table name do?

1029

How to do paging with oracle?

1054

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

1228

Un-Answered Questions { Oracle }

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2267

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1450

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2458

how report can be generated if we have the database designed in oracle 10g?

1945

Explain a segment?

1133

What does sharding mean?

1058

What do you understand from cache fusion?

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2269

What is the dba role in oracle?

629

Where is the multi connections are used in ORACLE DATA INTEGATOR?

674

How to open a cursor variable?

1093

How to assign query results to variables?

1101

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2376

What types of joins are used in writing subqueries?

1038

why dont we assign not null constraint as table level constraint.

2800

For More Un-Answered { Oracle } Questions Click Here