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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

Wipro,

2 6476

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

Wipro,

2 4906

3. Display all the client numbers in the ORDER table. Remove duplicates.

Wipro,

1 4442

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

Wipro,

1 4798

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.

Wipro,

3 5118

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

Wipro,

2353

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

Wipro,

1 4225

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

Wipro,

1 3743

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

Wipro,

2 4551

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.

Wipro,

3 6952

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

Wipro,

2388

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

Wipro,

1 3934

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

Wipro,

2 4712

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

Wipro,

1 5653

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

Wipro,

2352

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use "in" parameter properly?

1116

What are oracle functions?

1087

Explain the importance of .pll extension in oracle?

1057

What is hash cluster in oracle?

1244

What happens if recursive calls get out of control?

1136

What is the meaning of recursive hints in oracle?

1095

What is a proxy object?

1103

Is primary key indexed by default in oracle?

1046

What is set operator oracle?

1034

How can Oracle users be audited?

1169

Explain how you would restore a database using RMAN to Point in Time?

2184

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2342

How to use "while" statements in oracle?

1375

How do I escape a reserved word in oracle?

1253

Explain the function of optimizer in oracle?

1196

For More Un-Answered { Oracle General } Questions Click Here