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 3983

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 3853

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

 1747

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

 1 3056

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

 1 3064

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

 2 3535

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 5686

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

 1918

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

 1 3240

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

 2 3710

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

 1 4875

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

 1699

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

 1 3429

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

 1 3301

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 4700

Post New Wipro Oracle General Interview Questions


Wipro Oracle General Interview Questions


Un-Answered Questions

What are the advantage and features of selenium ide?

490

What is the difference between "actionresult" and "viewresult" ?

1

Explain the instruction stream queue mechanism in the 8086?

562

what is difference between GTS bench mark and temporary bench mark

3936

HELLO SIR VERY GOOD EVENING SIR, I'M KALAMANI. I NEED TO PREPARE FOR UPCOMING "JINDAL STEEL AND POWER LTD" INTERVIEW. I'M MECHANICAL ENGINEER SIR. SO PLEASE SEND ABOUT JINDAL's PREVIOUS APTITDE TEST QESTION PAPERS TO MY MAIL ID : , , . I WANT TO KNOW ABOUT THEIR PROCEDURE TO BE HELD ON THE INTERVIEW? SO PLEASE SIR SEND UR VALUABLE ANSWER TO ME ON ABOVE MAIL ID SIR. THANK U SIR.

1501




what is entity framework?

595

What is ember.js? Write the steps to create an app in ember.js?

1

Explain the lifecycle of blue prism?

169

Hadoop sqoop is which type of tool?

5

What are the advantages of dbms?

494

What is harness rule and define its types?

191

What are Declare expression and Declare constraints?

269

What is fram control?

472

What is a class in java?

578

I've made some changes to my applicaiton's web.xml, how and where should I update this file?

485