hi TECHKEYS............
So far we received
many request for FAQs on CSHARP, ASP.NET
AND SQLSERVER for fresher who are in finishing schools. We are actively
working with these Technologies to bring
KEY Resources for TECHIES.
you are
interested in helping others bring TECHKEYS to your Friends through
Social Media, please Leave the Comment to us to improve our work and subscribe for more information.
a)2 b)6 c)32 d)64
------------------------------------------------------------------------------------------------------------
Q 2) static method correct syntax:
a.private static main() b.public static main()
c.public static int main() d.public static void main()
------------------------------------------------------------------------------------------------------------
Q 3) AJAX full form?
answer: asynchronous javascript and xml.
------------------------------------------------------------------------------------------------------------
Q 4) public static void main(){
int x=1;
for(int i=0;i<5 data-blogger-escaped-i="" data-blogger-escaped-p=""> { int y=x + ++x;
console.write("value of y is:"y.ToString())
}
console.writeline("new value of x is:"+x);
}
tell the output?
------------------------------------------------------------------------------------------------------------Q 5) class table{ }
public static void Main() { tobj; }
a) tobj will store in heap b) tobj will store in stack
c) tobj will store in heap and point to stack d)--
------------------------------------------------------------------------------------------------------------
Q 6) which is not a collection type?
a.list b.arraylist c.array d.heaplist
------------------------------------------------------------------------------------------------------------
Q7) what is base class for serialization?
a.System.serialization b.Sytem.formatters.serialization
c.system.runtime.serialization
------------------------------------------------------------------------------------------------------------
Q 8) which authentication is done by developers and professional?
a.windows authentication b.server authentication
c.both a and b d.none of these
------------------------------------------------------------------------------------------------------------
Q 9)which is a light weight protocol?
A.SOAP B.XML C.HTTP D.HTML
------------------------------------------------------------------------------------------------------------
Q 10) which model is better for enterprise work?
a.relational b.hierarchical c.network
------------------------------------------------------------------------------------------------------------
Q 11) operator used for conversion of data type?
A.is B.as C.typeof
------------------------------------------------------------------------------------------------------------
Q 12) which access specifier has less scope than internal?
a.private b.public c.protected
------------------------------------------------------------------------------------------------------------
Q 13) which of them are executed first in a program?
a.namespace b.directives c.main()
------------------------------------------------------------------------------------------------------------
Q 14) goes to operator is used in which?
a.lambda expression b.delegates c.events
------------------------------------------------------------------------------------------------------------
Q 15) SGAM full form?
ans. secondary global allocation map
------------------------------------------------------------------------------------------------------------Q 16) size of Extent?
answer:64 KB
------------------------------------------------------------------------------------------------------------Q 17) how data will store in sqlserver
in sql server everything is stored on 8K data pages (8060 bytes are technically available).
------------------------------------------------------------------------------------------------------------Q 18) how many data pages is equal to one data extent?
8 data pages (each size is 8K and total 64K) .
------------------------------------------------------------------------------------------------------------
Q 19) how many types of extents in sql server
All space allocation is done based on extents – 64K There are 2 types of extents –
- mixed extent which stores data pages belong to the different objects
- First 8 pages for the objects are stored in the mixed extents
- uniform extent which stores data pages belong to the one object.
------------------------------------------------------------------------------------------------------------
Q 20) what do you know about ALLOCATION MAPs
- ALLOCATION MAPs are a few special data pages types in SQLServer which is used to track extents allocation. Those pages are basically bitmaps and each bit handles one extent.(each page handles 64,000 extents or almost 4Gb of data).
Q 21) WHAT IS GAM
- GAM – Global Allocation Map – tracks if extent are available for allocation or already in use.
Q 22) SGAM –
Shared Global Allocation Map – tracks if extents are mixed extent and have at least one data page available for use.
------------------------------------------------------------------------------------------------------------Q 23) IAM
Index Allocation Map – tracks if extents are used by specific table/index.
------------------------------------------------------------------------------------------------------------Q 24) what is PFS
Page Free Space – it will check and track free space available on a page approximately. One PFS page covers 8,088 pages or about 64Mb of data.
For More FAQs
Comments