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

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

Hi,

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
  #2  
Old 25-12-2008
Member
 
Join Date: Dec 2008
Posts: 12
Re: sql interview questions

Hi,

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
  #3  
Old 15-01-2009
Member
 
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
  #4  
Old 23-08-2010
vegetablevn
 
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
Reply

  TechArena Community > ARENA > Education Career and Job Discussions
Tags:



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 08:54 PM.