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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

what is null value?

9 10850

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 8659

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6294

how to send file attachment from oracle forms

HCL,

2605

what is the difference between rollback & commit? can a foreign key has null value?

6 14721

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2252

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

HP,

2265

how to replace not in with not exist?

IBM,

3807

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?

IBM,

4 7342

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

IBM,

2 7253

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 8860

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 4672

how to pass 2 parameters from one form to other in oracle applications?

1 7710

how to pass 2 variables from one form to other form

1 4013

1.Explain the three levels with the help og a diagram.

Baidu,

1 6517

Un-Answered Questions { Oracle }

How can you find dead processes?

586

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

570

How can I see all tables in oracle?

1063

What are triggers in oracle?

1104

What do you understand from cache fusion?

how to reverse engineer views(how to load the data from views)?

586

How to import one table back from a dump file?

1091

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1130

What are the differences between char and nchar in oracle?

1148

What is the page protect in reports?

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1837

Have you created sequence? When will you use?

602

How to loop through a cursor variable?

1129

1) Does oracle have any table which contain all the exceptions and it's code internally?

1808

Give the various exception types.

1040

For More Un-Answered { Oracle } Questions Click Here