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,

2311

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

IBM,

22 32800

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 7038

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

7 12230

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

2339

How to create Drill down report?

ABB, ESS, Infosys,

2127

How to call a report from Forms?

5 13151

Un-Answered Questions { Oracle }

How can you find your id on a system?

566

What is truncate oracle?

971

What is table partitioning and why is it required?

How to write date and time literals in oracle?

1002

What are the goals of dba?

558

What is required by oracle rac database to connect to a network?

What are the attributes of the cursor?

1004

How to delete a column in an existing table?

1076

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

Which is faster join or subquery in oracle?

995

What is memo?

637

How to use "in out" parameter properly?

1048

How would you go about verifying the network name that the local_listener is currently using?

2049

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1024

What is the difference between sharding and replication?

1048

For More Un-Answered { Oracle } Questions Click Here