Database,SQLServer,SQLServer Interview Questions and Answers,SQLServer Questions and Answers,ALL-Interview.com

Database>>SQLServer
\| \| \|
Welcome to SQLServer interview questions and answers.


Answered SQLServer Questions
what are different types of triggers
What is a bit datatype?.What is it used for?
What is defaults in Sql Server and types of Defaults ?
Can we call extended procedure from User define functions.
What is the use of DBCC commands?
What is difference between OSQL and Query Analyzer ?
tell me about join query
what is the meaning of * in sql ?
What are types of Locks ?
what is the maximum number of tables can i use to join in a single query ?
what is the difference between sql and sql server?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
Query To find the second highest salary of employee table.
When do you use SQL Profiler?
what is trigger? how many type of trigger
SQL Server runs on which TCP/IP port and From where can you change the default port?
What do you mean by Extents and types of Extends ?
What do u mean by Extents and types of Extends ?
which is faster join or subquery
What is Log Shipping and its purpose ?

Open SQLServer Questions
what is the output for this query select * from employee where 1=1;
how many types of store procedure in sqlserver 2000?
What does -g mean in the sql startup parameter?
What is Stuff in sql server?
How to retrieve data from log files in SQL SERVER ?
What is the use of MOVE keyword in restore command
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
what is stored procedure?Its significance with example?
explain different types of joins with examples briefly?
Type of integrity ? Entity, Referential, Domain ?
What is database replication? What are the different types of replication you can set up in SQL Server?
explain about simple recovery,full recovery,bulk logged recovery where can use?
what is Archive old data?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular locations we need....(after deleting and rollback )
what is package and it uses and how can u call a package
How will you configure AWE memory?
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENEFIT?
how to take backup bcp out for a column in table in sql server?
What is SQL Injection Attack ?

Common Interview Questions

what is your expected salary

If you get a Opportunity to go with a reputed company which is ready to pay more than what we r going to pay here.Will you quit the job from here or what?

what are the challenges you faced in previous job?

Can you work well under deadlines or pressure?How?

Why do you think you do well?

What motivates you to do a good job?

Describe any happy moment in your life?

How do you plan to achieve these goals?

what is your goal of life?

What is more important to you: the money or the work?

Tell me about an experience in which you had to use tact?

Tell me about your current job and responsibility

Why did you left the previous organization

when the interviewer asks, what is the Architecture of your project what we have to answer... plz provide the answer with the example

How to describe our city(Hyderabad) in a topic round during the interview time?

Please explain to us one conflict situation that you have experienced in your work life and how did you solve it

Could you please introduce yourself?

what is the best dress code for interview

Tell me about your dream job.

How shall i react if i do not like some people in our office

ASK a Question
1.Please post one question at a time,do not post duplicate questions 2.We have right to delete/modify/publish your question anywhere anytime. 3.Questions with no proper category and poor English will be rejected.
Enter Your Question:
Categorize:
Your Name:
EmailId:
Receive All-interview.com Updates

Time2Ask.com-Daily life questions & answers
Time2shaadi.com-matrimonials
MainCityMain.com-Free Online Classifieds
© 2008-2010.All-Interview does not guarantee the accuracy of any All-Interview.com content.All product names are trademarks of their respective companies.We are not endorsed by or affiliated with any company listed at this site and any other company.

Welcome to SQLServer interview questions and answers.