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

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,

2088

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 5546

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 5251

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

Wipro,

2 5542

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

Wipro,

5 8367

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

Wipro,

1 4435

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

Wipro,

2109

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

Wipro,

2265

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

Wipro,

2 5240

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 8154

What is the difference between RBBMS & DBMS?

4 9311

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 4382

Which Oracle App Is Most Popular One ?

3 5393

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

1 5382

what is domain in database and its benefits?

2390

Un-Answered Questions { Oracle }

Explain what does a control file contain?

1166

What are the benefits of ordbms?

1142

What are the differences between date and timestamp in oracle?

1105

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

2049

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

627

what is oracle data integrator (odi)?

675

What is the difference between I and G in Oracle?

1158

How can you find out how many users are currently logged into the database? How can you find their operating system id?

589

What command is used to type files to the screen?

635

What are the differences between lov and list item?

1150

how do u place it in required folder

1991

What are the different editions of oracle?

1185

What do you understand by lov and how can it be used?

1157

What is the meaning of recursive hints in oracle?

1105

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2441

For More Un-Answered { Oracle } Questions Click Here