Forum Resources Mentors Projects Entrance Exams Question Papers Colleges Courses Universities Make Money
Members Bookmarks Fresher Jobs Funny Pictures MCA Projects New Member FAQ  



My Profile
Active Members
TodayLast 7 Days more...



Awards & Gifts
Online Exams

Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian cities including Bangalore, Chennai, Hyderabad, Pune or Kochi

Resources
Find educational articles, blogs, discussion threads and other resources.

Colleges
Find details about any college in India or search for courses.

Paid Surveys


website counter


Database Interview Questions


Posted Date: 22 Apr 2008    Resource Type: Articles/Knowledge Sharing    Category: Jobs & Interviews
Posted By: umang garg       Member Level: Gold
Rating:     Points: 6



1. What are the different types of joins?
2. Explain normalization with examples.
3. What cursor type do you use to retrieve multiple recordsets?
4. Diffrence between a "where" clause and a "having" clause
5. What is the difference between "procedure" and "function"?
6. How will you copy the structure of a table without copying the data?
7. How to find out the database name from SQL*PLUS command prompt?
8. Tadeoffs with having indexes
9. Talk about "Exception Handling" in PL/SQL?
10. What is the diference between "NULL in C" and "NULL in Oracle?"
11. What is Pro*C? What is OCI?
12. Give some examples of Analytical functions.
13. What is the difference between "translate" and "replace"?
14. What is DYNAMIC SQL method 4?
15. How to remove duplicate records from a table?
16. What is the use of ANALYZing the tables?
17. How to run SQL script from a Unix Shell?
18. What is a "transaction"? Why are they necessary?
19. Explain Normalizationa dn Denormalization with examples.
20. When do you get contraint violtaion? What are the types of constraints?
21. How to convert RAW datatype into TEXT?
22. Difference - Primary Key and Aggregate Key
23. How functional dependency is related to database table design?
24. What is a "trigger"?
25. Why can a "group by" or "order by" clause be expensive to process?
26. What are "HINTS"? What is "index covering" of a query?
27. What is a VIEW? How to get script for a view?
28. What are the Large object types suported by Oracle?
29. What is SQL*Loader?
30. Difference between "VARCHAR" and "VARCHAR2" datatypes.
31. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
32. Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
33. How to create a database link ?




Responses
Author: umang garg    22 Apr 2008Member Level: Gold   Points : 1
THESE QUESTION ARE VERY GOOD AND HELPFUL I CRACK MY INTERVIEW WITH HELP OF THESE QUESTION.


Feedbacks      
Popular Tags   What are tags ?   Search Tags  
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: interview question of world wide web(www).
Previous Resource: MANAGEMENT INTERVIEW QUESTIONS.
Return to Discussion Resource Index
Post New Resource
Category: Jobs & Interviews


Post resources and earn money! 		 
Related Resources


Contact Us    Privacy Policy    Terms Of Use   

SpiderWorks Technologies Pvt Ltd. 2006 - 2007 All Rights Reserved.