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

2068

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

5 7280

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2230

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2209

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 9193

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

4366

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

6 17116

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

2103

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

iGate,

2425

ABOUT IDENTITY?

HCL,

2057

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

15 16038

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

1 5105

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

HCL, IBM,

7 12967

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

CGI, IBM,

3 7848

How to Select second Maximum salary in a Table ?

Oracle,

13 15765

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the use of indexes option in imp command.

1179

How different is ms access and oracle?

1038

List out the types of joins.

1158

How to manage transaction isolation level?

1006

What is oracle and what are its different editions?

1065

Can we save images in a database and if yes, how?

1065

What is oracle analytical function?

1143

How to divide query output into groups in oracle?

992

What is oracle rownum?

952

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144

How to delete all rows a table in oracle?

1068

What is a procedure in oracle?

1197

What is the maximum limit on the number of columns in a table?

1086

Does oracle partitioning improve performance?

992

What is the difference between post-database commit and post-form commit?

1199

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