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

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

2 4471

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

2444

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

4238

How to restrict the duplicate records in table valuesets

IBM,

2 7379

how to pass 2 variables from one form to other form

Intelligroup,

2 8156

What is Virtual Memory?

1 4118

What is the disadvantage of User defind function?

CybAge,

2347

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

2 7251

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

3 8166

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,

2301

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

HCL,

2 12701

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

2097

query optmization techniques and quwry analyser+projects+ppts

2470

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 4595

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

10 12849

Un-Answered Questions { Oracle }

What is your favorite tool for day-to-day oracle operation?

587

What is the anchoring in reports?

What operator tests column for the absence of data?

643

What is a cognitive schema?

1035

Explain overloading. Can functions be overloaded?

1049

What is the use of Oracle Control File?

1119

What are the different types of partitions in oracle?

1038

Explain the various types of canvas in form.

what is dynamic SGA and static SGA

4495

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

570

What is a named program unit?

1140

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

711

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1839

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2085

How can you determine if an index needs to be dropped and rebuilt?

605

For More Un-Answered { Oracle } Questions Click Here