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 can we write trigger in trigger???????? can we write one trigger on two table???

2 5915

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 7638

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

Canara Bank,

2351

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 8702

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

Syntel,

2 5938

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 4940

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 3456

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

HCL, IBM,

9 19064

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 5536

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 7410

what is the difference between table and veiw?

IBM,

4 7220

How to display First 4 rows From Database Table?

6 9676

What is the between Function and Procedure?

HCL,

3 6319

12 RULES OF RDBMS

1 4430

How do we know whether an index is created on a table ???

TCS,

2 5888

Un-Answered Questions { Oracle }

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2145

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1971

What are dml statements in oracle?

1089

How to estimate disk space needed for an export job?

1047

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

682

How can we expand Parameter Form Canvas on Reports 6i?

2416

Is it possible to split the print reviewer into more than one region ?

2275

how to handle exceptions in post production

1416

State the difference between a primary key and foreign key?

930

What is oracle rowcount?

1080

What is Virtual Private Database in Oracle?

1083

Why do we need a database?

593

What is a initialization parameter file in oracle?

1033

Is there an oracle sql query that aggregates multiple rows into one row?

971

How to connect ms access to oracle servers?

997

For More Un-Answered { Oracle } Questions Click Here