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

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2348

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

Mastek,

2507

How we can migrate the 6i report to 10g reports. What steps need to reuired?

ABC,

2 11473

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2383

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3106

After using set unused can we enable the column again to use? Please give me some answers....

Maveric,

1 4896

what is the difference between no rows returned and null returned?

2 5699

how to genarate random numbers in oracle for particular row?

3 7861

What is use of oracle?

Satyam,

2 5595

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2567

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 10357

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2049

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

Infosys,

1 4516

interview questions with answer for cts

Cognizant,

2641

What is the difference between alert log file and trace file ?

1 26945

Un-Answered Questions { Oracle }

What is an oracle data file?

1165

Explain the characteristics of oracle dba?

1180

What operator tests column for the absence of data?

643

Mention what is split brain syndrome in rac?

What are the common oracle dba tasks?

1205

What is Memos?

634

Is there any function in oracle similar like group_concat of mysql?

1113

Explain temporal data types in oracle

1135

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2066

How to increment dates by 1 in oracle?

1140

You see multiple fragments in the system tablespace, what should you check first?

627

What is integrity and what is constraint??Explain with example

2347

Can i create more than one Master Repository in ODI?

655

What is call form stack?

What is the difference between oracle media recovery and crash recovery?

1217

For More Un-Answered { Oracle } Questions Click Here