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 4588

which is the best training centre for learning oracle?

13 19411

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

IBM,

8 12185

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

1 4806

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

5 40174

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

1 15503

What different of iner joint & outer joint with example

4 10008

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

ESS,

1 5399

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

ESS,

2303

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

IBM,

22 32730

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 7021

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

7 12209

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

2334

How to create Drill down report?

ABB, ESS, Infosys,

2124

How to call a report from Forms?

5 13137

Un-Answered Questions { Oracle }

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

How to download oracle database 10g xe?

1011

How to open a cursor variable?

1031

How to create a table in a specific tablespace?

972

What is transactional trigger property?

How to compare dates in oracle sql?

1095

is there a tool to trace queries, like profiler for sql server?

1139

Do you need a commit after ddl statements?

559

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2001

What is the implicit cursor in oracle?

1099

Can group functions be mixed with non-group selection fields?

1015

what we specify the in XML data server and parameters for to connect to xml file?

696

Is the After report trigger fired if the report execution fails ?

2911

What is max rowid in oracle?

1023

Explain an integrity constrains?

1139

For More Un-Answered { Oracle } Questions Click Here