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

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

IBM, Oracle,

1 4597

which is the best training centre for learning oracle?

13 19444

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

8 12218

what is difference between table and view? where to use views? thanks in advance!

1 4811

What is the difference between Outer join and Full outer join?

5 40204

how to insert data into partitioned table partition done by Range partition

1 15515

What different of iner joint & outer joint with example

4 10031

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

ESS,

1 5414

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

ESS,

2310

how will I find the first 5 highest salaried employees in each dept in oracle.

IBM,

22 32799

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 7037

How many types of trigger can be used in a table at a time ?

7 12227

how to clone 9i Database on to 10g Database.

2338

How to create Drill down report?

ABB, ESS, Infosys,

2127

How to call a report from Forms?

5 13151

Un-Answered Questions { Oracle }

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2999

Difference between negative and positive adjustments : oracle accounts receivable

1104

What are summary column and placeholder column in reports?

What are operators in oracle?

1055

What is SQL Tuning Advisor in Oracle?

1179

Query to retrieve record for a many to many relationship ?

2519

Explain the use of file option in exp command.

1129

How to initialize variables with default values?

1243

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

Explain what are clusters?

1108

How to create a new table in oracle?

1155

When using oracle export/import what character set concerns might come up? How do you handle them?

595

definition of cluster and non-clustered index?

3035

What is the max number of columns in an oracle table?

999

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

For More Un-Answered { Oracle } Questions Click Here