|
Joydeep
|
Posted: Friday 16, May 2008 01:35:23 PM
|
|
|
Those are few question asked to me by 3i-Infotech people during
my Interview Process
1. What is .NET Framework?
2. Different types of Assembly and Framework?
3. Types of Assembly?
4. Function Overloading.
5. Concept of OOPS.
6. Diff between Abstract class and interface.
7. What is sn.exe?
8. Describe ADO.net
9. What is Execute Non Query and Execute Scalar
10. What is the diff between DataSet and DataReader
11. Which is faster
12. What is Indexes
13. What is Stored Procedure?
14. What is Triggers?
15. What is Views?
16. What is Cursor?
17. What is boxing and unboxing?
18. Difference between Primary Key and Foreign Key?
19. Difference between dll and ocx file?
20. What are User Control and System Control?
21. Difference between Module and Class?
22. What is String Builder?
Hope this will help anyone...
|
|
Back to Top
^ |
|
| AJProfessionals | Posted: Friday 16, May 2008 02:20:40 PM | | 1. What is .NET Framework?
.NET Framework is run time engine for .NET Application. It has
two part CLR and base class library.
.NET framework control the execution, support the class library
, security of the application.
2. Different types of Assembly?
There are three type of assembly, Private assembly which is cre
ated by default. Second is Shared assembly which we can share i
n different application. For creating shared assembly we need t
o assign assembly with strong name and install assembly to GAC.
And third type of assembly known as Satellite assembly it dose
not hold any executable code, it stored the resource file only
.
4. Function Overloading.
Function overloading is used to create different function with
same name by creating different signature, means creating diffe
rent no of argument, different data type and different return t
ype. We can create function overloading by using overloads keyw
ord.
5. Concept of OOPS.
OOPS means Object Oriented Programming System, Its start with c
lass. class is the template of objects. Objects is the instance
of the class. There is so many advantages of OOPS like code re
usability, abstraction, encapsulation, inheritance, polymorphis
m.
6. Diff between Abstract class and interface.
Abstract class contain method definition and implementation how
ever interface contain only method signature, for using abstrac
t class we use inheritance and for using interface we use imple
ments.
7. What is sn.exe?
It create strong name for the assembly, it produce 128 bit publ
ic private key pair. We need to pass this key to sign an assemb
ly if we want to share the assembly and install it into GAC.
8. Describe ADO.net
ADO.NET is data connectivity architecture used in .NET Framewor
k, It has three type of data connectivity architecture first Di
sconnected architecture in this we use datatable, datacolumn, d
atarow and dataset. Second connected architecture here we use c
ommand, datareader and last one is XMLbased data architecture h
ere we use System.XML namespace and class like XMLDocument, XPa
thQuery used to serialize the dataset into stream.
| | Back to Top ^ | | |
| AtanuMaity | Posted: Saturday 17, May 2008 03:15:47 AM | | 9. What is Execute Non Query and Execute Scalar
ExecuteNonQuery execute DML Query and return no of rows effecte
d by the query, whereas ExecuteScaler return only first column
of first row of the result set, its is help full to use when we
have single value.
10. What is the diff between DataSet and DataReader
Data set represent sub set of database, include multiple tables
, constraints, relations. It is disconnected architecture, howe
ver datareader represent only single result set, it is forward
and read only result set and connected architecture.
| | Back to Top ^ | | |
| ankhi | Posted: Saturday 09, July 2011 07:08:01 AM | | ans 13:Stored procedure is set of SQL statements with an assign
ed name and it is stored in database as compiled form so that i
t can be shared by number of programs.
| | Back to Top ^ | | |
|