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

what is the diffrence between before parameter form triger & formate trigger

2 4375

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2401

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4178

How to restrict the duplicate records in table valuesets

IBM,

2 7301

how to pass 2 variables from one form to other form

Intelligroup,

2 8053

What is Virtual Memory?

1 4055

What is the disadvantage of User defind function?

CybAge,

2296

Please explan Why static query is more faster than dynamic query ?

2 7141

i want print character reports in 10g application reports pl help me my id is yoga.roh@gmail.com

3 8040

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

Intelligroup, TTPL,

2217

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

HCL,

2 12608

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2035

query optmization techniques and quwry analyser+projects+ppts

2425

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 4493

how to find the n'th highest salary from emp ?

10 12574

Un-Answered Questions { Oracle }

How to join two tables in a single query using oracle?

1000

What are the five functions of a database?

611

How to get maxsal , minsal, ename department wise in single query

1552

what are the tools used for oracle 10g in real time.

2444

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

What is program global area (pga) in oracle?

1034

What do you mean by oracle database?

579

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2473

what is load plans and types of load plans?

622

How is mapping of name of dll and function done?

What is odi studio?

595

What is the difference between substr & instr functions?

1233

What is an Oracle database Partial Backup?

1167

What is a user role in oracle?

1133

What is an oracle user account?

996

For More Un-Answered { Oracle } Questions Click Here