Skip to main content

FAQS PART 3

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

SQL SERVER

  1. .we can minimize the selection process by using which clause?ANS: : where
  2. DATABASE METADATA STORE IN WHICH PLACE ANS: : System catalog or System Table
  3. EXTENT LENGTH  ANS: : 8 Contiguous pages(64KB)
  4. which stores the pre defined query?  ANS: : System Stored Procedure  
  5. sql server doesn't run which os? 
    1. xp 
    2. 98 
    3. 95 
    4. millineum                                    ANS: : 95
  6. we can perform insert delete update operation on?
    1. table
    2. view 
    3. trigger 
    4. index                                 ANS:  table
  7. which produces result and also non relational result
    1. compute
    2. cube
    3. rollup
    4. none                          ANS: : Compute
  8.  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

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 »