|
6.) Difference between temporary table and derived table?
|
7.)View state how u make that so that view state in page can not be tampered?
Administrator wants to make a security check that no one has tampered with ViewState, how can we ensure this? Microsoft has provided two mechanisms for increasing the security of ViewState. Machine Authentication Check (MAC)
- tamper-proofing <%@ Page EnableViewStateMac="true"%>
Encrypting the ViewState This encryption can only be applied at the machine.config level, as follows: <machineKey validation='3Des' />
8.)which session state mode you used in your current project?why?
it depends on your project . by default InProc mode.
9.) Diffrences between UDF and Stored procedures?
Procedure can return zero or n values whereas function can return one value which is mandatory.
Procedures can have input,output parameters for it whereas functions can have only input parameters.
Procedure allow select as well as DML statement in it whereas function allow only select statement in it.
Functions can be called from procedure whereas procedures cannot be called from function.
Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
We can go for transaction management in procedure whereas we can't go in function.
Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
10.) CCW,RCW why to use com components when we can manage everything with dlls?
We can't manage Everthing with dlls .becz few problems will face when handling with dlls Forex: DLL hell and etc. so, A .NET component, however, is a pre-compiled class module with a .DLL (dynamically-linked library) extension. At run time, a .NET component is invoked and loaded into memory to be used by some consumer application. You may have a single DLL that supports error handling in your applications. In this case, the DLL exposes a single ErrorHandler class that performs all of the error handling required by consumer applications. So,.Net Components can't communicate with Com directly,so we can do using RCW (Runtime callable Wrapper) and CCW .
Administrator wants to make a security check that no one has tampered with ViewState, how can we ensure this? Microsoft has provided two mechanisms for increasing the security of ViewState. Machine Authentication Check (MAC)
- tamper-proofing <%@ Page EnableViewStateMac="true"%>
Encrypting the ViewState This encryption can only be applied at the machine.config level, as follows: <machineKey validation='3Des' />
8.)which session state mode you used in your current project?why?
it depends on your project . by default InProc mode.
9.) Diffrences between UDF and Stored procedures?
Procedure can return zero or n values whereas function can return one value which is mandatory.
Procedures can have input,output parameters for it whereas functions can have only input parameters.
Procedure allow select as well as DML statement in it whereas function allow only select statement in it.
Functions can be called from procedure whereas procedures cannot be called from function.
Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
We can go for transaction management in procedure whereas we can't go in function.
Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
10.) CCW,RCW why to use com components when we can manage everything with dlls?
We can't manage Everthing with dlls .becz few problems will face when handling with dlls Forex: DLL hell and etc. so, A .NET component, however, is a pre-compiled class module with a .DLL (dynamically-linked library) extension. At run time, a .NET component is invoked and loaded into memory to be used by some consumer application. You may have a single DLL that supports error handling in your applications. In this case, the DLL exposes a single ErrorHandler class that performs all of the error handling required by consumer applications. So,.Net Components can't communicate with Com directly,so we can do using RCW (Runtime callable Wrapper) and CCW .