|
INTERVIEW QUESTIONS
DATABASE
SQL SERVER
DETAILS
Question: What does this return? select (1324 & 1024)
Answer: 1024 This performs a bitwise AND operation between the two integers and sets the result to this. Since 1024 is a single set bit in it's value, if the corresponding bit is set to 1, then in the result the bit is set to 1. In this case, since no other bits would generate two 1s, the result is equivalevt to the mask, or 1024.
|
|
|
Category |
SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8201 users |
Added on |
4/3/2013 |
Views |
67075 |
Rate it! |
|
|
Question:
What does this return? select (1324 & 1024)
Answer:
1024 This performs a bitwise AND operation between the two integers and sets the result to this. Since 1024 is a single set bit in it's value, if the corresponding bit is set to 1, then in the result the bit is set to 1. In this case, since no other bits would generate two 1s, the result is equivalevt to the mask, or 1024. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Where does Profiler store its temporary data in SQL Server 2005?
|
View Answer
|
|
What does this return? declare @i int select @i = -5 select +@i
|
View Answer
|
|
Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
|
View Answer
|
|
What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
|
View Answer
|
|
What does the Queue Reader Agent do in SQL Server 2005 replication?
|
View Answer
|
|
How does a differential backup know which extents have changed so that it can be very quickly run?
|
View Answer
|
|
When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
|
View Answer
|
|
What is the recommended way to send mail from SQLAgent in SQL Server 2005?
|
View Answer
|
|
How do I submit a form or a part of a form without a page refresh?
|
View Answer
|
|
In which order do you perform an upgrade to SQL Server 2005 for replicated databases?
|
View Answer
|
|
Error severity 13 indicates what?
|
View Answer
|
|
What is SQL Server ?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All SQL Server Interview Questions & Answers - Exam Mode /
Learning Mode
|