Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

College School Exams Tests, DELL,

5 10696

What is integrity and what is constraint??Explain with example

Google,

2280

difference between procedures and function?

IBM,

7 10379

wirte the syntax of update query?

IBM,

3 5480

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1861

what is difference between sql plus and sql*plus? (not sql and sql plus).

3891

where we have to use ON clause and where we have to use USING clause in JOINS

2 4191

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.

Wipro,

1840

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

Wipro,

2108

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

Wipro,

2 6350

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 4792

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

Wipro,

1 4369

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

Wipro,

1 4703

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 5023

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

Wipro,

2301

Un-Answered Questions { Oracle }

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1272

What is a scenario in odi?

571

What is the load balancing advisory?

What are the differences between blob and clob in oracle?

1082

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2230

what is profile in odi?

646

What is the usage of merge statement?

1142

How to increment dates by 1 in oracle?

1067

Can I create users through internet explorer in oracle 10g?

1078

What is an oracle database table?

1011

What is oracle instant client?

1022

Mention how oracle flex asm works?

How to convert dates to characters in oracle?

1037

What is ODI console?

669

Why does oracle 9i treat an empty string as null?

1048

For More Un-Answered { Oracle } Questions Click Here