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 ?

1033

How to store only time; not date and time?

1020

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

1092

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

1065

How can I introduce multiple conditions in like operator?

988

How to load a large xml file?

1055

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

990

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

1141

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

1034

What are the oracle differences between nvl and coalesce

1149

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

1067

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

1033

What exactly do quotation marks around the table name do?

963

How to do paging with oracle?

999

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

1168

Un-Answered Questions { Oracle }

What are the database administrators utilities available?

1031

How to use subqueries with the exists operator in oracle?

1027

How to check the oracle tns settings?

1047

Write a trigger example in oracle?

1062

When do you get a .pll extension in oracle? Explain its importance

1042

Describe varray?

1058

How to start your 10g xe server from command line?

1073

What are named parameters?

1090

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1979

How to determine what records to extract?

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2521

What is a static data dictionary in oracle?

1112

How to display employee records who gets more salary than the average salary in the department?

1065

Explain how can you use the same lov for 2 columns?

1128

For More Un-Answered { Oracle } Questions Click Here