Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 4147

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 2786

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

Wipro,

1 2816

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

Wipro,

1 3133

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 2950

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

Wipro,

1321

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

Wipro,

1 2189

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

Wipro,

1 2505

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

Wipro,

2 2837

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 4701

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

Wipro,

1583

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

Wipro,

1 2722

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

Wipro,

2 3002

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

Wipro,

1 4282

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

Wipro,

1357


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

Write a trigger example in oracle?

208


How to use attributes of the implicit cursor in oracle?

205


What are oracle functions?

184


What is difference between sid and service name in oracle?

160


What language does oracle use?

184






Difference between cartesian join and cross join?

194


What is tns service name?

200


What is materialized view in Oracle?

243


What is Undo Management Advisor in Oracle?

251


How to join two tables in a single query using oracle?

221


What is the usage of analyze command in oracle?

219


What is merge in oracle?

182


How to create a stored function in oracle?

231


What is an oracle recycle bin?

216


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

202