Multiple Choice Questions on SQL Data Types









1. Out of the below data types which can be used for Date & time type?







a)     Date



b)     Datetimeoffset



c)     Time



d)     All







2. What is the ISO synonym for ntext data type?







a)     New text



b)     Next text



c)     National Text



d)     None of the above







3. Which data type is used to store binary data up to the limit of 2,147,483,647?







a)     Image



b)     Text



c)     Ntext



d)     None of the above







4. Which data type can be used to represent position in a hierarchy?







a.     Hierarchy



b.     Hierarchyid



c.     Nhierarchyid



d.     None of the above







5. What is the storage size of smallmoney data type?







a)     3 bytes



b)     2 bytes



c)     4 bytes



d)     8 bytes







6.  What is the range of TinyInt data type in SQL Server?







a)     0-10



b)     0-255



c)     -2^15 to 2^15-1



d)     None of the above







7. Which data type in SQL server can be used to store time in the table?







a)     Timeonly



b)     OnlyTime



c)     Time



d)     DateTime







8. What is the ISO synonym for real data type in SQL server?







a)     Float(24)



b)     Float(8)



c)     Float(16)



d)     None of the above







9. What is the default size of n in a column which is defined as VARCHAR(n)?







a)     NULL



b)     0



c)     1



d)     None of the above







10. Which data type is used for assigning GUID value?







a)     UNIQUE



b)     UNIQUEIDENTYFIER



c)     GUID



d)     None of the above












Answers



1) d, 2) c, 3) a, 4) b, 5) c, 6) b, 7) c, 8) a, 9) c, 10) b



































Comments

Post a Comment

Popular posts from this blog

Write a Program to Add two 3x3 Matrix using C

Image
#include<stdio.h> void main () { int a [ 3 ][ 3 ], b [ 3 ][ 3 ], s [ 3 ][ 3 ], i , j ; printf ( "Enter the values of 1st matrix" ); for ( i = 0 ; i < 3 ; i ++ ) { for ( j = 0 ; j < 3 ; j ++ ) { scanf ( "%d" , & a [ i ][ j ]); } } printf ( "Enter the values of 2nd matrix" ); for ( i = 0 ; i < 3 ; i ++ ) { for ( j = 0 ; j < 3 ; j ++ ) { scanf ( "%d" , & b [ i ][ j ]); } } for ( i = 0 ; i < 3 ; i ++ ) { for ( j = 0 ; j < 3 ; j ++ ) { s [ i ][ j ] = a [ i ][ j ] + b [ i ][ j ]; } } printf ( " \n The Sum is : \n " ); for ( i = 0 ; i < 3 ; i ++ ) { printf ( " \n\n " ); for ( j = 0 ; j < 3 ; j ++ ) { printf ( " \t %d" , s [ i ][ j ]); } ...
Read more

C program for Unit Conversion

Image
/* Convert Celsius to Fahrenheit */ #include<stdio.h> void main() {     float c,f;     printf("Enter the temperature in Celcius: ");     scanf("%f",&c);     f = c * 9/5 + 32;     printf("Temperature in Farenheit: %f",f); } /* Convert Farenheit to Celcius */ #include<stdio.h> void main() {     float c,f;     printf("Farenheit : ");     scanf("%f",&f);     c = (f - 32) * 5/9;     printf("Celcius: %f",c);  } /*Convert Meter to Feet*/ #include<stdio.h> void main() {     float m,f;     printf("Meter : ");     scanf("%f",&m);     f = 3.2808399 * m;     printf("Feet: %f",f); } /* Convert Feet to Meter */ #include<stdio.h> void main() {     float m,f;     printf("Feet : ");     scanf("%f",&f);     m = f / 3.2808399;     printf("Meter: %f",m); } /*Convert...
Read more

Write a Program to Add two 5x5 Matrix using C

Image
#include<stdio.h> void main() {   int a[5][5],b[5][5],c[5][5];   int i,j;   for(i=0;i<5;i++)   {     printf("\nEnter elements of %d row of first Matrix: ",i+1);     for(j=0;j<5;j++)       scanf("%d",&a[i][j]);   }   for(i=0;i<5;i++)   {     printf("\nEnter elements of %d row of second Matrix: ",i+1);     for(j=0;j<5;j++)       scanf("%d",&b[i][j]);   }   printf("\nSum of Matrix:\n\n");   for(i=0;i<5;i++)   {     for(j=0;j<5;j++)     {       c[i][j]=a[i][j]+b[i][j];       printf("%3d ",c[i][j]);     }     printf("\n");   } }
Read more