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

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

Wipro,

1 4239

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

Wipro,

1 3751

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

Wipro,

2 4562

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 6970

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

Wipro,

2394

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

Wipro,

1 3945

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

Wipro,

2 4726

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

Wipro,

1 5662

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

Wipro,

2361

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

Wipro,

1 4132

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

Wipro,

1 4011

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 5705

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 6583

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

Wipro,

2252

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,

2173

Un-Answered Questions { Oracle }

What are the roles and responsibilities of oracle dba?

704

What is the fastest query method to fetch data from the table?

1424

What are the varoius components of physical database structure of oracle database?

1045

What are the different types of backups that are available in oracle?

Can we connect to ORACLE db using Windows Authentication?

1312

What is the maximum number of triggers that can be applied to a single table?

1075

As an oracle dba what are the entire unix file you should be familiar with?

626

Can we call procedure inside function in oracle?

1154

Why do you use stored procedures and state some of its disadvantages?

1080

Why do we use materialized view instead of table or views?

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2576

What is the difference between single instance environment and rac environment?

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2339

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

634

What are the restrictions on external table columns?

1116

For More Un-Answered { Oracle } Questions Click Here