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

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

Wipro,

2016

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

Wipro,

3 5401

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

Wipro,

2 5144

25. Display the client number and the value of the highest value order placed by that client.

Wipro,

2 5439

26. Display the earliest shipping date in the format: DD/MON/YYYY

Wipro,

5 8132

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

Wipro,

1 4331

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

Wipro,

2061

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

Wipro,

2204

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

Wipro,

2 5119

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

Wipro,

6 7898

What is the difference between RBBMS & DBMS?

4 9065

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 4302

Which Oracle App Is Most Popular One ?

3 5253

whats the difference between join command and Cartesian product using example?

1 5306

what is domain in database and its benefits?

2297

Un-Answered Questions { Oracle }

How to concatenate two text values in oracle?

1110

How to use "in out" parameter properly?

1044

What are the various types of snapshots ?

1023

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2825

How to create a new table by selecting rows from another table?

1077

What are the restrictions in a oracle read only transaction?

1028

What is the page protect in reports?

all steps of bitmap report?

2348

How many types of cluster table in Oracle?

1030

Explain the method to debug errors in an oracle application.

What are the differences between lov and list item?

1060

Explain the use of log option in exp command.

1112

what is a Nested Loop join?

2104

What is merge statement used for?

1021

Can we save images in a database and if yes, how?

1057

For More Un-Answered { Oracle } Questions Click Here