Oracle Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17064

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

Wipro, BeBo Technologies,

7 62531

What are inner join and outer join?

3 8759




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 62941

what are Triggers?

TCS,

5 9068

what are stored procedures?

TCS, Wells Fargo,

6 7328

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

TCS, Green Info Solutions,

7 12374

what are views?

TCS,

7 13902

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

Oracle, i2,

2 15100

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

CA,

1 2780

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

2 3351

For web applications from which version of Oracle is suitable?

1 3340

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

1 3167

What is Statement Auditing ?

2 2660

What are the use of Roles ?

3 3013







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

3033


i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

888


What is the recommended interval at which to run statspack snapshots, and why?

1701


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

829


How to handle data if f table are more than one and each table contain thousands of entries?

923






what is Single Byte Overhead...?

1361


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1333


How to create Drill down report?

1057


20. Using a set operator, display the client number of all clients who have never placed an order.

1157


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

2600


a text item is there what r the different types of triggers associated with it

957


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1294


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?

914


Explain how you would restore a database using RMAN to Point in Time?

995


Which is better Oracle or MS SQL? Why?

4135