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

Oracle General Interview Questions

Questions Answers Views Company eMail

candidate key is subset of super key but not vice-verse explain

2021

"primary key=unique+null" is equal,reson?not,reason?

5 7057

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2181

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2157

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

BOB Technologies, Cap Gemini, IBM,

2 9028

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4299

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 16826

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071

how to join query for one source type is oracle another source type is sql server ?

iGate,

2387

ABOUT IDENTITY?

HCL,

2011

How to select the name of employee who is getting maximum sal with out using subquery

15 15506

Why required to run root.sh at the time of installation and what exactly it will do

1 5008

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

HCL, IBM,

7 12742

1.display list of all users from ur data base.what is the query?

CGI, IBM,

3 7707

How to Select second Maximum salary in a Table ?

Oracle,

13 15289

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to delete a user account in oracle?

920

Explain oracle insert into command?

1061

What is the use of aggregate functions in oracle?

983

What is the minimum client footprint required to connect c# to an oracle database?

1025

Please explain joins in oracle?

1013

How to pass a cursor variable to a procedure?

1046

What is Segment Advisor in Oracle?

1054

How to create an oracle database manually?

1026

How to create a new table in oracle?

1074

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1993

Can you create a synonym without having a table?

989

What are the numeric comparison operations?

1063

How to write a query with a right outer join in oracle?

1117

What is a data dictionary and how can it be created?

1066

Â What are the oracle DML commands possible through an update strategy?

1008

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