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 5333

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 3765

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

Wipro,

1 3516

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

Wipro,

1 3968

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 3838

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

Wipro,

1743

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

Wipro,

1 3046

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

Wipro,

1 3051

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

Wipro,

2 3523

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 5663

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

Wipro,

1911

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

Wipro,

1 3229

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

Wipro,

2 3698

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

Wipro,

1 4857

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

Wipro,

1696

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What privilege is needed for a user to connect to oracle server?

547

How to define a specific record type?

606

Is oracle the best database?

509

List the various oracle database objects?

592

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1795




In the oracle version 9.3.0.5.0, what does each number shows?

736

How do I manually uninstall oracle client?

510

Calculate difference between 2 date / times in oracle sql?

557

Compare and contrast between sql and sql server and explain its various functions?

519

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1791

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1346

Can multiple cursors being opened at the same time?

602

What is the difference between online and offline backups?

555

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1199

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

579

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