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 3997

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 3871

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

 1753

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

 1 3068

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

 1 3076

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

 2 3544

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 5706

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

 1922

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

 1 3256

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

 2 3718

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

 1 4881

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

 1705

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

 1 3440

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

 1 3305

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 4711

Post New Wipro Oracle General Interview Questions


Wipro Oracle General Interview Questions


Un-Answered Questions

Tell some of the most important uses of ms access?

500

Explain what is step-loop? Explain all the steps?

713

What are the types of database engines available in mysql?

477

Explain the difference between javascript and an asp script.

506

what are terms used in electrical sales field for Hawells other than C&F   and what are their meanings.???? I m new in this field please help

2503




How do you declare A pointer to array of three chars

532

What is round trip in asp.net?

515

What does Nominal size in a valve means like NG6,NG10 etc

6584

What is ctrl shift qq?

318

Tell me why did you choose this line of work as insurance sales? : insurance sales

328

What is Payroll?

1614

How do you find the size of an arraylist?

409

What is being tracked?

210

Tell me what kind of tests should not be automated?

525

What is a control query?

1596