Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Wipro Oracle General Interview Questions
Questions Answers Views Company eMail

4. Display the order number and client number from the ORDER table. Output the result in the format. Client ordered

1 3310

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 3217

6. Display the client name and order date for all orders using the traditional method.

1444

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

1 2372

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

1 2701





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

2 3067

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.

3 4999

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

1710

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

1 2888

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

2 3238

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

1 4474

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

1483

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

1 3032

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

1 2943

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

2 3505

Post New Wipro Oracle General Interview Questions




Wipro Oracle General Interview Questions


Un-Answered Questions

How to redirect to another page?

1308


If Dg set load increase 25%, How much increase fuel Consumption (15 kva 2 cylinder DG set)

1573


Clarify what information architecture?

274


Explain resource in android?

263


Define its url.

306






What is a bookie in bookkeeper?

1


What is hmc in hybris?

3


What is product attributes?

376


how many joint can done in HT line and what is life of the joint

1342


How will you do beta testing?

413


What are analytic functions in sql?

309


How do you Export a session ?

1203


How much is magento cloud?

1


What does %f mean c?

330


Explain different pipelining hazards and how are they eliminated? : .NET Architecture

290