Skip to main content

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 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 ;i++) 
        {           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()  { table  tobj;    }
a) tobj will store in heap         b) tobj will store in stack
c) tobj will store in stack and point to heap      d)none


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


    • data integrity depends on

      1. data sharing
      2. accuracy
      3.  redundency
      4. 2&4                             ANS: accuracy

    • which is lightweight protocal?        ANS:soap


    1. class is which based memory     ANS: Heap
    2.  csharp code is                         ANS: managed
    3. sn.exe generates what?            ANS: Strong Name
    4. file and fileinfo classes doesn't offer the set of functionality
      1. moving
      2. creating
      3. copying 
      4. deleting                                  ANS:none of the options
    5. datareader field count return type        ANS:integer
    6. type dataset and untype dataset difference?
      1. type dataset have schema information of database(primary key and FK info)
      2. untype does not have schema information
    7. GOALS OF INTEROPERABILITY
      1. ANSWER
      2. net does not affect existing COM objects
      3. .Net and COM components interoperate with each other
      4. COM components can be upgraded into .NET components
    8. if u build the application what file with extension generated                  ANS: .exe
    9. null is a string ?                                   ANS: NO
    10. which access specifiers not hide the variables in namespace
      1. internal 
      2. protected 
      3. internal protected
      4. public                                                                              ANS:public
    11. which access modifier is specify for incomplete class  
      1. abstract
      2. virtual
      3. override
      4. sealed                                                               ANS: abstract
    12. which keyword permits to overload abstract methods? ANS: Abstract override
    13. which is not feature of c sharp                   ANS: c sharp is not a case sensitive
    14. .The class which offers storage capability    Ans:ICollection 
    15. sealed class                             ANS: We can’t further inherit the sealed class
    16. how date types are available?   ANS:   1.Value  types  2. Reference  types   3. Pointer  types
    17. which is responsible for loading data into dataset?                ANS: DataAdapter
    18. .what is cLI?   ANS:  Common Language Infrastructure
    19.  : Language Integrated Query
    20. OLEDB full form?          ANS  Object Linking and Embedding, Database,
    21. what is the backbone of disconnected model?  
    22. .AJAX full form?   ANS : Asynchronous JavaScript and XML
    23. .Full form of ccw? ANS :  COM Callable Wrapper
    24.  net doesn’t not support which web standards?    Ans: other than this  HTTP,XML,SOAP,WSDL,UDDI. 
    25. What will ICollection have?   Ans:IList and Idictionary

    27. SQL SERVER
    28. .we can minimize the selection process by using which clause?ANS: : where
    29. ANS: : System catalog or System Table
    30. EXTENT LENGTH  ANS: : 8 Contiguous pages(64KB)
    31. which stores the pre defined query?  ANS: : System Stored Procedure  
    32. sql server doesn't run which os? 
      1. xp 
      2. 98 
      3. 95 
      4. millineum                                    ANS: : 95
    33. we can perform insert delete update operation on?
      1. table
      2. view 
      3. trigger 
      4. index                                 ANS:  table
    34. which produces result and also non relational result
      1. compute
      2. cube
      3. rollup
      4. none                          ANS: : Compute
    35.  a query which relay on output of inner query
      1. correrelate subquery
      2. nested subquery
      3. inner querey 
      4. none                       ANS:  Corelated subquery




    Comments

    Post a Comment

    Popular posts from this blog

    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 »