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 10710

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

Google,

2284

difference between procedures and function?

IBM,

7 10392

wirte the syntax of update query?

IBM,

3 5498

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

1865

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

3898

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

2 4199

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,

1846

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,

2116

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 4707

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

Un-Answered Questions { Oracle }

What operator tests column for the absence of data?

599

Explain the use of control file?

1113

How much money does a dba make?

580

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2163

What are the four Oracle system processes that must always be up and running for the database to be useable?

1017

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

1020

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

549

How to get last row id?

992

How do you install statspack?

685

HOW TO SPOT AHIERARCHY?

2295

What are the data types in oracle?

1040

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1786

What are open_form,call_form,new_form?

How to start your 10g xe server?

1041

For More Un-Answered { Oracle } Questions Click Here