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 joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 62193

what are Triggers?

TCS,

5 8678

what are stored procedures?

TCS,

6 6996

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

TCS, Green Info Solutions,

7 12001

what are views?

TCS,

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?

CA,

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 ?

844


what is reindexing?

417


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

1006


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

868


please explain.. DB architecture ...

880






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?

972


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

724


What are joins, explain all types of joins?

929


query optmization techniques and quwry analyser+projects+ppts

1151


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?

873


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

1081


Query to retrieve record for a many to many relationship ?

1433


how the indexes are stored in the Oracle Database?

1079


Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1021


What are the package used in DBMS ?

1341