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 3963

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 3829

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

 1736

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

 1 3040

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

 1 3046

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

 2 3510

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 5657

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

 1907

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

 1 3225

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

 2 3692

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

 1 4850

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

 1692

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

 1 3411

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

 1 3279

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 4679

Post New Wipro Oracle General Interview Questions


Wipro Oracle General Interview Questions


Un-Answered Questions

How do I run multiple commands in linux?

524

What are all the difference between iOS3, iOS4 and iOS5?

447

How to loop through result set objects using mssql_fetch_array()?

533

What is difference between sleep () and wait ()?

478

How can you create topic in kafka?

286




What is the difference between multimeter

1441

Why are the objects immutable in java?

536

Is there a switch..case statement in python?

467

q)what are the validations in sql*loader

1728

if we install two earth pits with a clear space of 5m without any interconnection,by checking the digital multimeter will it show continuity between earth pits? If so what would be the approx. value

1458

4. Calculate the following from the particulars given below: i) Material Cost Variance ii) Material Price Variance iii) Material Usage Variance iv) Material Mix Variance v) Material Yield Variance Material Standard Actual Qty kgs. Price Rs Value Rs. Qty kgs. Price Rs Value Rs A 50 4 200 40 5 200 B 30 6 180 30 6 180 C 20 3 60 30 3 90 100 440 100 470 Loss 20 ----- 30 ----- 80 440 70 470

2639

How can you get the attribute value of a model?

5

What is html and why it is used for?

438

Explain some disadvantages to manual software testing?

583

What is the right Step of Commissioning? (Commissioning, Hub Manager, Hardware)

1577