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

7. Repeat query (7) but also display all clients who have never ordered anything.

Wipro,

1 4121

8. Display the client name and order date for all orders using the natural join keywords.

Wipro,

1 3652

9. Display the client name and order date for all orders using the JOIN . . . USING method.

Wipro,

2 4458

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

Wipro,

3 6833

11. Display the client number and name and the client number and name of the person who referred that client.

Wipro,

2331

12. Display the client name in upper case only and in lower case only.

Wipro,

1 3850

13. Display the second to fifth characters in each client name.

Wipro,

2 4630

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

Wipro,

1 5583

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

Wipro,

2290

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string .

Wipro,

1 4065

17. Display the order number and average item cost for each order.

Wipro,

1 3930

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client has placed orders to the value of

Wipro,

2 5595

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

Wipro,

2 6457

20. Using a set operator, display the client number of all clients who have never placed an order.

Wipro,

2180

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

Wipro,

2095

Un-Answered Questions { Oracle }

Tell me about standby database? What should we watch out for?

544

Differences between package and loadplans?

587

What is an Oracle SYSTEM tablespace and when is it Created?

1104

How can you use check constraints for self referential integrity?

964

What is the difference between formal parameters and actual parameters?

1081

Explain the truncate in oracle?

964

Explain parameter file in oracle.

1022

List out the components of logical database structure of oracle database.

1031

What is CKM and when we will use this CKM?

566

Are These Dff's Flexible?

1164

What are the system variables can be set by users? Explain them

What is tns name?

977

what is normalisation?what are its uses?

2267

What is a schema in oracle?

1010

What is not equal to in oracle?

996

For More Un-Answered { Oracle } Questions Click Here