Go Back   TechArena Community > ARENA > Education Career and Job Discussions
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Thread Tools Search this Thread
Old 25-12-2008
Join Date: Dec 2008
Posts: 13
sql interview questions


I had just completed my Graduation and now searching for the job.
i am searching the job as database admin in sql.
will u please give me some basic interview questions of sql.
Reply With Quote
Old 25-12-2008
Join Date: Dec 2008
Posts: 12
Re: sql interview questions


According to me the following questions are normally asked in sql interview

1) What is the difference between a "where" clause and a "having" clause?
2) What is the basic form of a SQL statement to read data out of a table?
3) What is a "join"?
4) What is "normalization"? "Denormalization"? Why do you sometimes want
to denormalize?
5) What is a "primary key"?
6) What is a "constraint"?
Reply With Quote
Old 15-01-2009
Join Date: Jan 2008
Posts: 56
Re: sql interview questions

1. What is normalization? Explain different levels of normalization?
2. What is denormalization and when would you go for it?
3. How do you implement one-to-one, one-to-many and many-to-many
relationships while designing tables?
4. What are user defined datatypes and when you should go for them?
5. What is bit datatype and what's the information that can be stored
inside a bit column?
6. Define candidate key, alternate key, composite key.
7. What are defaults? Is there a column to which a default can't be bound?
8. What is a transaction and what are ACID properties?
9. Explain different isolation levels
10. What's the maximum size of a row?
11. Explain the architecture of SQL Server
12. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
13. What are the new features introduced in SQL Server 2000 (or the latest
release of SQL Server at the time of your interview)? What changed
between the previous version of SQL Server and the current version?
14. What are constraints? Explain different types of constraints.
15. Difference between nested query,sub query and nested query?
Reply With Quote
Old 23-08-2010
Posts: n/a
Re: sql interview questions

Thanks very much for this comment. It help me to think about my ideals.

Tks again and pls keep posting.
Reply With Quote

  TechArena Community > ARENA > Education Career and Job Discussions

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "sql interview questions"
Thread Thread Starter Forum Replies Last Post
How will be the Finance Interview Questions Svana Education Career and Job Discussions 7 03-05-2012 11:51 AM
Interview Questions for ASP.Net hemant.G Software Development 3 05-01-2012 04:26 PM
Interview Questions akbar Active Directory 1 04-09-2010 01:24 PM
Where can I get struts Interview questions? geekboy Education Career and Job Discussions 3 04-08-2009 11:47 PM
Interview Questions DiyaG Education Career and Job Discussions 3 26-09-2008 07:05 PM

All times are GMT +5.5. The time now is 10:06 PM.