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 10572

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 8459

how to send sms to mobile phone from oracle forms.

HP, Tech Mahindra,

1 6214

how to send file attachment from oracle forms

HCL,

2547

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

6 14478

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?

2170

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

HP,

2213

how to replace not in with not exist?

IBM,

3731

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 7137

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 7131

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

2 8750

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

2 4554

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

1 7641

how to pass 2 variables from one form to other form

1 3938

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

Baidu,

1 6427

Un-Answered Questions { Oracle }

What is the data type of dual table?

991

What view would you use to determine free space in a tablespace?

2222

What is Java Pool in Oracle?

1162

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

Explain how are indexes update?

1060

How to see the table columns used in an index?

1017

Explain oracle’s server parameter file.

986

How to calculate date and time differences in oracle?

1035

Can you tell me how to add new column in existing views?how?How is possible?

1434

What degree do database administrators need?

544

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

How can you tell if an index on particular table is used or not used in 9i?

560

How to execute the package in oracle?

1078

How to define an anonymous procedure without variables?

1094

What is rac?

For More Un-Answered { Oracle } Questions Click Here