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 3725

which is the best training centre for learning oracle?

 13 15901

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

IBM,

8 9820

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

 1 4062

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

 5 38131

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

 1 14660

What different of iner joint & outer joint with example

 4 8565

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

ESS,

1 4562

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

ESS,

1791

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

IBM,

22 26807

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 5799

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

 7 9775

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

 1814

How to create Drill down report?

ABB, ESS, Infosys,

1680

How to call a report from Forms?

 5 11440

Un-Answered Questions { Oracle }

How to define a specific record type?

601

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1430

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1570

Mention what is cluster?

1

What is the usage of control file in oracle?

592




What is a partition in oracle?

534

How to use "startup" command to start default instance?

530

What skills do you need to be an administrator?

273

What are the different types of backups that are available in oracle?

1

What are the four Oracle system processes that must always be up and running for the database to be useable?

579

What does database administrator do?

247

Which profile required to access solution in Designer tool?

283

Explain a segment?

602

Which environment variables are absolutely critical in order to run the OUI?

1637

Why cursor variables are easier to use than cursors?

557

For More Un-Answered { Oracle } Questions Click Here