|
INTERVIEW QUESTIONS
DATABASE
SQL SERVER
DETAILS
Question: What is different between int and bint?
Answer: bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytes
int can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes
|
|
|
Category |
SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6701 users |
Added on |
4/3/2013 |
Views |
69004 |
Rate it! |
|
|
Question:
What is different between int and bint?
Answer:
bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytes
int can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes 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 |
|
How to remove duplicate records from a table?
|
View Answer
|
|
What is the difference between "procedure" and "function"?
|
View Answer
|
|
How will you copy the structure of a table without copying the data?
|
View Answer
|
|
What is DESCRIBE command in SQL Server?What is its purpose?How to use it?
|
View Answer
|
|
What are DTS subroutines? What is their use and How do you write them?
|
View Answer
|
|
What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL.
|
View Answer
|
|
What is the difference between the full, simple and bulk log recovery models?
|
View Answer
|
|
What does the Log Reader agent in SQL Server 2005 replication do?
|
View Answer
|
|
What does this return? select (1324 & 1024)
|
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
|
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
|