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

what is null value?

9 10606

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 8483

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6219

how to send file attachment from oracle forms

HCL,

2551

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

6 14500

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?

2185

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

HP,

2216

how to replace not in with not exist?

IBM,

3737

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 7154

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 7141

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

2 8758

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

2 4562

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

1 7650

how to pass 2 variables from one form to other form

1 3943

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

Baidu,

1 6438

Un-Answered Questions { Oracle }

What is SQL access advisor in Oracle?

1189

State any two functions of oracle?

1046

What is the finger command?

584

What are the uses of Database Trigger ?

1720

What is the difference between truncate and delete? How would a full table scan behave after?

552

How to drop an existing view in oracle?

946

How to loop through data rows in the implicit cursor?

1073

Mention what is oracle real application clusters?

What do you understand by a database object? Can you list a few of them?

1018

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7671

What do you mean by cdb and pdb in oracle 12c?

1059

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3935

How to create an oracle database manually?

1085

Is primary key indexed by default in oracle?

987

How to define Data Block size in Oracle?

1110

For More Un-Answered { Oracle } Questions Click Here