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 6371

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 4799

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

Wipro,

1 4378

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

Wipro,

1 4708

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 5027

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

Wipro,

2306

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

Wipro,

1 4132

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

Wipro,

1 3663

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

Wipro,

2 4466

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 6838

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

Wipro,

2339

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

Wipro,

1 3855

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

Wipro,

2 4633

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

Wipro,

1 5591

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

Wipro,

2291

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I recompile a procedure in oracle?

964

How to use subqueries with the exists operator in oracle?

1027

How to view existing locks on the database?

1053

How to create a new table in oracle?

1156

What is a schema in oracle?

1013

When do you get a .pll extension in oracle? Explain its importance

1042

What is Trigger in Oracle?

1171

What is the quickest way to fetch the data from a table?

1058

What is the exact use of Collections?

2143

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2179

What is a package in oracle?

1102

What to do if dba lost the system password?

1172

Why is oracle so popular?

997

How can we force the database to use the user specified rollback segment?

1148

What is object data modeling?

966

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