1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


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 3731

which is the best training centre for learning oracle?

 13 15922

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

IBM,

8 9827

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

 1 4066

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

 5 38135

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

 1 14670

What different of iner joint & outer joint with example

 4 8574

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

ESS,

1 4569

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

ESS,

1794

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

IBM,

22 26835

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 5802

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

 7 9785

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

 1816

How to create Drill down report?

ABB, ESS, Infosys,

1682

How to call a report from Forms?

 5 11451

Un-Answered Questions { Oracle }

What is sequence?

618

Which files are vital that should be backed up?

297

When configuring sqlnet on the server what files must be set up?

272

what is the odi console?

314

Have you attended the client meetings?

305




What are dml statements in oracle?

608

What are the attributes of the cursor?

545

How to invoke the data pump import utility?

638

How are extents allocated to a segment?

566

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.

3322

Explain the types of exception?

641

What is a named program unit?

568

What are the different editions of oracle?

582

What are the common oracle dba tasks?

615

How to display row numbers with the records?

574

For More Un-Answered { Oracle } Questions Click Here