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 4366

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

2397

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

4174

How to restrict the duplicate records in table valuesets

IBM,

2 7295

how to pass 2 variables from one form to other form

Intelligroup,

2 8048

What is Virtual Memory?

1 4048

What is the disadvantage of User defind function?

CybAge,

2292

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

2 7134

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

3 8036

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,

2216

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

HCL,

2 12598

> 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?

2030

query optmization techniques and quwry analyser+projects+ppts

2421

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 4483

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

10 12554

Un-Answered Questions { Oracle }

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

if the source have total 15 records with 2 records are updated and 3 records are newly inserted at the target side we have to load the newly changed and inserted records

550

What is the difference between pre-select and pre-query?

1219

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7972

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2906

How to run queries on external tables?

1046

What is index-organized table in Oracle?

1069

How would you differentiate between cluster and grid?

What are the data management skills?

552

How to drop an existing view in oracle?

946

What is Tax Categories?

2112

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

1020

What are the different types of database objects?

1062

What is the dba role in oracle?

577

What is an oracle wallet?

942

For More Un-Answered { Oracle } Questions Click Here