Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 4809

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 5124

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

2364

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

1 4231

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

1 3747

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

2 4560

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 6961

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

2391

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

1 3942

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

2 4724

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

1 5655

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

2357

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

1 4126

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

1 4007

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 5704

Post New Wipro Oracle General Interview Questions


Wipro Oracle General Interview Questions


Un-Answered Questions

Define the term 'users' in openstack.

302


What is the command used to fetch first 5 characters of the string?

1467


Tell me what is https/ssl update?

948


What is winword exe error?

680


What are switches? Explain the concepts of layer-3 switches?

898


Name some of the most common actuarial software used in industry?

1119


What is the difference between memcpy and memmove?

1087


on “sed” command EmpData(Sample Database) 1122|j.b. saxena |g.m. |account |12/12/52|6000 2233|n.k. gupta |d.g.m |sales |31/12/40|9000 4545|anil agarwal |director |account |06/07/47|7500 5656|lalit choudhury |executive|marketing|07/09/50|5000 1265|chanchal singhvi|g.m. |admin |12/09/63|6000 0110|shyam saksena |chairman |marketing|12/12/43|8000 5566|jai sharma |director |account |23/12/89|7000 7733|jayant |d.g.m |sales |29/02/70|6000 1. From the above database substitute the delimiter of first 3 lines with “ : “ 2. From the above database substitute the delimiter with “ : ” 3. Insert the string “ XYZ Employees” in the first line. 4. Store the lines pertaining to the directors, d.g.m and g.m into three separate files. 5. Using address store first 4 lines into a file Empupdate. 6. Find the pattern “account” in the database and replaces that with “accounts”. 7. Select those lines which do not have a pattern “g.m”. 8. Insert a blank line after every line in the database.

3153


What is looping and how to avoid it in framework manager?

1254


What number ranges can be configured in srm ?

1037


What companies are working on Internet of Things (IoT)?

3


What does rownum mean in sql?

1091


How do I compare two strings in excel?

773


what is the difference between window & document in javascript?

1008


Is it possible to create web application with both webforms and mvc?

1037