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

Oracle General Interview Questions

Questions Answers Views Company eMail

In Oracle 10g, "g" Stands for what?

Mphasis,

5 15957

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 7087

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 4661

what is port in oracle? how is it related to database application.

1949

what is host string in sql plus? how does it related to database?

1 6493

how can we write trigger in trigger???????? can we write one trigger on two table???

Value Labs,

2 5927

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

JPMorgan Chase,

4 7657

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

IBM,

7 8726

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

Cognizant,

2 4947

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 3461

How to Remove the 3rd highest salary person record from table?

HCL, IBM,

9 19104

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 5552

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

IBM,

6 7423

what is the difference between table and veiw?

IBM,

4 7246

How to display First 4 rows From Database Table?

6 9696

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to put more than 1000 values into an oracle in clause?

1029

How to speed up webrick?

1076

What are operators in oracle?

1055

what is meant by magic query

2186

How to delete a column in an existing table in oracle?

1072

What is oracle instant client?

1024

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

1056

What are the different pseudo commands? Explain in general?

1080

How to recover a dropped table in oracle?

1048

How to turn on or off recycle bin for the instance?

1084

How to rename an index in oracle?

1114

What is Segment Advisor in Oracle?

1104

What is a Garbage Collection? and what is full recursive Garbage collection?

2902

Please explain compound trigger in oracle?

1057

What is system global area (sga) in oracle?

991

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