25 December, 2011

sql interview questions and answers

What is sql?
-Structured Query Language (SQL) is a language that provides an interface to relational database systems.


Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
-Data Definition Language (DDL)

Which TCP/IP port does SQL Server run on? How can it be changed?
-SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

What is the difference between UNION and UNION ALL in SQL?
-UNION is an SQL keyword used to merge the results of two or more tables using a Select statement, containing the same fields, with removed duplicate values. UNION ALL does the same, however it persists duplicate values.


What operator performs pattern matching?
-LIKE operator

What are the difference between clustered and a non-clustered index?
-A clustered index is a special type of index that reorders the way records in the table are physically stored.
-A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk.


What is the difference between IN and BETWEEN, that are used inside a WHERE clause?The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.

What are the wildcards used for pattern matching?
_ for single character substitution and % for multi-character substitution


What is Online Transaction Processing (OLTP) ?
-Online transaction processing systems relational database design use the discipline of data modeling and generally follow the Codd rules of data normalization in order to ensure absolute data integrity.

What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all

Whats the capacity of the image data type in MS SQL?
-Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes.

What is difference between DELETE and TRUNCATE commands?
-Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.

What command is used to get back the privileges offered by the GRANT command?
-REVOKE

What are the authentication modes in SQL Server?
-Windows mode and Mixed Mode - SQL and Windows. How 2 change it-To change authentication mode in SQL Server click Start, Programs, Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group. Select the server then from the Tools menu select SQL Server Configuration Properties, and choose the Security page.


What’s the difference between a primary key and a unique key?
-Both Primary key and Unique key enforce the uniqueness of a column on which they are defined. However, a Primary key does not allow nulls, whereas unique key allow nulls.

What is a transaction and ACID?
-Transaction - A transaction is a logical unit of work. All steps must be committed or rolled back.
ACID - Atomicity, Consistency, Isolation and Durability, these are the unique entities of a transaction.


References:
http://www.pinaldave.com/sql-download/SQLServer2008InterviewQuestionsAnswers.pdf

http://r4r.co.in/sql/sql_Interview_Questions_and%20Answers/SQL_Interview_Questions_And_Answers.php

http://www.allinterview.com/Interview-Questions/SQL-PLSQL.html

http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/

http://www.techinterviews.com/sql-interview-questions-and-answers

23 comments:

  1. This is the right webpage for anyone who hopes to understand this topic.
    You know a whole lot its almost hard to argue with
    you (not that I actually would want to…HaHa). You certainly put a new spin on a subject that's been written about for
    ages. Wonderful stuff, just wonderful!

    Look at my weblog - Elevate GF

    ReplyDelete
  2. My spouse and I stumbled over here by a different web page and thought I might
    as well check things out. I like what I see so now i'm following you.

    Look forward to looking at your web page again.

    Review my blog post - Max Shred review

    ReplyDelete
  3. Howdy just wanted to give you a quick heads up and let you
    know a few of the images aren't loading properly.
    I'm not sure why but I think its a linking issue. I've tried it in two different
    browsers and both show the same outcome.



    my weblog: google advertising programs

    ReplyDelete
  4. When someone writes an paragraph he/she maintains the thought of a user in his/her brain that how a user can understand it.
    So that's why this article is great. Thanks!

    Here is my site: best home gym

    ReplyDelete
  5. I every time emailed this webpage post page to all my contacts, since if like to
    read it next my contacts will too.

    Feel free to surf to my web-site best jig saw

    ReplyDelete
  6. Hi just wanted to give you a quick heads up and let
    you know a few of the pictures aren't loading correctly.
    I'm not sure why but I think its a linking issue. I've tried it
    in two different web browsers and both show the same results.


    Here is my page best tankless water heater

    ReplyDelete
  7. I’m not that much of a internet reader to be honest but your sites really nice, keep it up!
    I'll go ahead and bookmark your site to come back down the
    road. All the best

    My webpage - best charcoal grill

    ReplyDelete
  8. I am now not positive the place you're getting your info, but great topic.
    I must spend a while learning more or understanding more.
    Thank you for excellent information I used to be in search of this info for my mission.


    Also visit my site; best adjustable dumbbells

    ReplyDelete
  9. I believe what you said was actually very reasonable.
    But, what about this? what if you added a little information?
    I am not suggesting your content isn't good, but what if you added a post title to maybe grab
    a person's attention? I mean "sql interview questions and answers" is a
    little plain. You could glance at Yahoo's front page and watch how they create
    article headlines to grab people to open the links.
    You might try adding a video or a related pic or two to
    get people interested about what you've written. Just my opinion,
    it could bring your blog a little bit more interesting.

    Also visit my page - best carpet cleaner

    ReplyDelete
  10. Having read this I thought it was very enlightening.
    I appreciate you finding the time and energy to put this content together.
    I once again find myself spending way too much time both reading and leaving comments.
    But so what, it was still worthwhile!

    my webpage :: best pressure washer

    ReplyDelete
  11. We'гe ɑ bunch of volunteers and openinǥ a neww scheme iin our community.
    Your ԝebsite offered us wth valuable іnfo to ѡirk on.
    You have dome an impressivе joЬ and our whɦolе community can be gгatеful tto
    you.

    Feel free to visit my webpage; garcinia cambogia gnc

    ReplyDelete
  12. Wonderful article! This is the kind of information that are
    supposed to be shared around the net. Disgrace on the seek engines for not positioning this put
    up higher! Come on over and seek advice from
    my site . Thank you =)

    Also visit my web blog ... herpes cure news, ,

    ReplyDelete
  13. This paragraph offers clear idea in favor of the new users of blogging, that genuinely how to do blogging.


    Also visit my blog :: new launches in singapore (jogyundang.com)

    ReplyDelete
  14. When you are getting bored at your office desk, you can take off with this app, check out our galaxy, and even travel through time.

    The result is a digital representation of an Ocarina that has seen great success in both sales and critical reception.
    Then these apps go to iPhone apps store and anybody according to his want can pick any of them.


    My webpage - iphone app developer india ()

    ReplyDelete
  15. You may also use a search engine and type in the keyword stated above.
    especially for warmer water baits and through into the autumn
    time. Sometimes bait substances work despite a very great degree of lack of proven scientific information on why
    this is.

    Here is my web page - big fish casino hack

    ReplyDelete
  16. You can uѕe it to disϲover whߋ is the phone nսmber owner who left an anonymouѕ missed cаll on your cell phone.
    Howeveг, the question numerous for all tіme desire to
    discover answers to is; is it probablе to conduct free reverse cell
    phone lookup. So comparing theѕе two services which one should ƴou pay for reverse cell
    phone lookup.

    Here is my ƅlօg post: Free Services To Lookup Cell Numbers

    ReplyDelete
  17. After looking over a handful of the blog posts on your website, I truly
    like your way of blogging. I book-marked it to my bookmark webpage list and
    will be checking back soon. Take a look at my website as well
    and tell me your opinion.

    Visit my web page The Commodity Robot Review, ,

    ReplyDelete
  18. If yоu are interested in curing reflux at home, there iѕ no better time than to start today.
    You will be capable of getting a hand of the Turbulence Training manual
    and instructional video bү going onlіne. Use a leɑn ρork
    fіllet and flash fry in grounԀnut oil and add mіnced
    ցarlic and soy.

    Also visit my paցe ... Turbulence Training download

    ReplyDelete
  19. Start the game and make sure you are on the "Interact" slot.
    Sims of all ages except the toddlers can participate in Classic
    Dance or Jump rope. If you were to ask someone who doesn't speak
    your language a question, you wouldn't get an answer.


    Also visit my site; the sims freeplay cheats for
    money - -

    ReplyDelete
  20. It's appropriate time to make a few plans for the future and it's
    time to be happy. I have read this publish and if
    I may just I want to suggest you few attention-grabbing things or tips.
    Perhaps you can write next articles relating to this article.
    I want to learn even more issues approximately it!



    Here is my page: best lawn tractor

    ReplyDelete
  21. Everything is very open with a precise explanation of the issues.
    It was really informative. Your website is very useful.
    Many thanks for sharing!

    My web page: home security systems reviews

    ReplyDelete
  22. Need to explain the topics in depth so that the SQL concepts would be more clear and understandable.

    SQL Queries Interview Questions and Answers

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.