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

2106

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

5 7473

How to define a cusotmer as a supplier in ORACLE R12

Intelligroup,

2302

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

Intelligroup,

2249

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 9301

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

4414

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

6 17369

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

2145

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

iGate,

2479

ABOUT IDENTITY?

HCL,

2109

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

15 16429

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

1 5179

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

HCL, IBM,

7 13154

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

CGI, IBM,

3 7996

How to Select second Maximum salary in a Table ?

Oracle,

13 16169

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is user managed backup in Oracle?

1202

How do I manually create a database in oracle?

1068

What is Java Pool in Oracle?

1237

Difference between inner join vs where ?

1096

How to fetch the row which has the max value for a column?

1044

How can Oracle users be audited?

1170

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1708

What are the general rules on data consistency?

1060

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1395

How to connect the oracle server as sysdba?

1128

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4680

How to display row numbers with the records?

1134

What is the Tune Query

2345

How to convert a date to char in oracle? Give one example.

1107

How to create a stored procedure in oracle?

1150

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