Skip to main content

FAQS

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.

 

Q 1) levels of nesting in a subquery?
     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 – 

  1. mixed extent which stores data pages belong to the different objects 
    1.  First 8 pages for the objects are stored in the mixed extents
  2.  uniform extent which stores data pages belong to the one object.
after that only uniform extents are used. blocks regardless of the type (mixed or uniform).

------------------------------------------------------------------------------------------------------------
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

Post a Comment

Popular posts from this blog

FAQS on DOTNET

Hello to every one who are fallowing my blog, today i attend one call from one Technical Recruiter (name is not required i think ) he asked some couple of question...ok i answered ....mean while  he asked one question (in my life never i feel it is relevant  for developer) who will use oops development environment? ha.. ha.. expect answer and update  to me   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 .   Q 1) levels of nesting in a subq...
Post a Comment
read more »

SQLSERVER Functions- Coalesce()

SQL  Server  built-in functions Coalesce() It is A function Is Very Much Useful at Run time When We Have Multi Value Attribute in a Table. If U Consider below facts placed in a employee table With Id, Name, ph_no, Alt_no, Office no. id Name Ph_ no Alt_ no Office no 101 Albert 999999 456453 321333 102 khan null null 123455 103 victor 112121 null null 104 lovely null null 1897321 Above Employee table may have single value are three values if it have single value then it fill null  values with remaining attributes When We Retrieve The Number from employee table That Number Should Not be Null value To get not null value from employee table We Use Coalesce() Function It Returns First Encountered Not Null Value  from employee table select id , name , coalesce ( Ph_no , Alt_no , Office_no ) as contact...
Post a Comment
read more »

OOPS-Constructors and distractor

Hi friends today we will discussed about constructors and distractor in csharp Constructors are used to memory allocation for real world entities which are created with the help of objects. When program or application is running, application required memory to save and manipulate data of that real world object/entities. Now the question is how much memory is required for that object? Frankly no one can decide how much memory is required for that application because of that all object oriented programming languages depends on heap memory. Heap memory is a logical memory in RAM (temporary memory) and size is logically infinity (physically it is limited).This memory has to be creating at run time when we are using object in our program/application. Now we have to know that what type of data members we have in object. In object we have two types of data members’ object instance  shared instance Object instance are allocated occupies object memory and...
Post a Comment
read more »