Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 16570

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 61776

What are inner join and outer join?

3 8522

What are many types of joins are there?

Amdocs, CSC, TCS,

29 62193

what are Triggers?


5 8678

what are stored procedures?


6 6996

what are many types of index's are there and what are they?

TCS, Green Info Solutions,

7 12001

what are views?


7 13525

what is the difference between oracle 81,91,11i

i2, Oracle,

2 14900

How client makes connection with server in client/server architecture?


1 2610

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 3195

For web applications from which version of Oracle is suitable?

1 3208

What are the main diff. between oracle 7.3 and oracle 8i?

1 3057

What is Statement Auditing ?

2 2565

What are the use of Roles ?

3 2881

Un-Answered Questions { Oracle }

why should i declare foreign key constraint as self relation instead of binary relation in tables ?


what is reindexing?


Could you please let me know the interfaces in OM / FA??


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


please explain.. DB architecture ...


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?


i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........


What are joins, explain all types of joins?


query optmization techniques and quwry analyser+projects+ppts


8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?


IS it possible to built the oracle database without setting the kernal parameters?


Query to retrieve record for a many to many relationship ?


how the indexes are stored in the Oracle Database?


Can any one send me oracle form and reports tutorials from which i may get me on my mail


What are the package used in DBMS ?