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
-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
Thanks for this interview questions about SQL.
ReplyDeleteInterview Questions
This is the right webpage for anyone who hopes to understand this topic.
ReplyDeleteYou 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
My spouse and I stumbled over here by a different web page and thought I might
ReplyDeleteas 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
Howdy just wanted to give you a quick heads up and let you
ReplyDeleteknow 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
When someone writes an paragraph he/she maintains the thought of a user in his/her brain that how a user can understand it.
ReplyDeleteSo that's why this article is great. Thanks!
Here is my site: best home gym
I every time emailed this webpage post page to all my contacts, since if like to
ReplyDeleteread it next my contacts will too.
Feel free to surf to my web-site best jig saw
Hi just wanted to give you a quick heads up and let
ReplyDeleteyou 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
I’m not that much of a internet reader to be honest but your sites really nice, keep it up!
ReplyDeleteI'll go ahead and bookmark your site to come back down the
road. All the best
My webpage - best charcoal grill
I am now not positive the place you're getting your info, but great topic.
ReplyDeleteI 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
I believe what you said was actually very reasonable.
ReplyDeleteBut, 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
Having read this I thought it was very enlightening.
ReplyDeleteI 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
We'гe ɑ bunch of volunteers and openinǥ a neww scheme iin our community.
ReplyDeleteYour ԝ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
Wonderful article! This is the kind of information that are
ReplyDeletesupposed 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, ,
This paragraph offers clear idea in favor of the new users of blogging, that genuinely how to do blogging.
ReplyDeleteAlso visit my blog :: new launches in singapore (jogyundang.com)
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.
ReplyDeleteThe 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 ()
You may also use a search engine and type in the keyword stated above.
ReplyDeleteespecially 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
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.
ReplyDeleteHoweveг, 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
After looking over a handful of the blog posts on your website, I truly
ReplyDeletelike 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, ,
If yоu are interested in curing reflux at home, there iѕ no better time than to start today.
ReplyDeleteYou 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
Start the game and make sure you are on the "Interact" slot.
ReplyDeleteSims 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 - -
It's appropriate time to make a few plans for the future and it's
ReplyDeletetime 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
Everything is very open with a precise explanation of the issues.
ReplyDeleteIt was really informative. Your website is very useful.
Many thanks for sharing!
My web page: home security systems reviews
Need to explain the topics in depth so that the SQL concepts would be more clear and understandable.
ReplyDeleteSQL Queries Interview Questions and Answers