Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 4680

which is the best training centre for learning oracle?

13 19820

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

IBM,

8 12487

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

1 4878

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

5 40367

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

1 15588

What different of iner joint & outer joint with example

4 10244

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

ESS,

1 5494

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

ESS,

2364

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

IBM,

22 33425

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 7193

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

7 12448

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

2388

How to create Drill down report?

ABB, ESS, Infosys,

2188

How to call a report from Forms?

5 13320

Un-Answered Questions { Oracle }

What is Redo Log Buffer in Oracle?

1286

How to load excel data sheet to oracle database

1080

How to define an anonymous procedure with variables?

1244

What is the use of lockboxes? : oracle accounts receivable

1270

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2289

How you find which is the latest record in SCD type2 transformation?

656

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

What are the new features in release 11i?

What do you understand by oracle forms?

1116

What is flexfileds and use of flexfileds in odi?

633

What is db_recovery_file_dest in oracle? When do you need to set this value?

1172

What does sharding mean?

1058

How many types of cluster table in Oracle?

1084

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2675

What is define in oracle?

1114

For More Un-Answered { Oracle } Questions Click Here