Dot Net
Can we have shared events ?
Dec 13th
Yes, you can have shared event’s note only shared methods can raise shared events.
What is the software you have used for project management?
Dec 13th
Many companies have there own software defined. There are many project management software available at this moment in market but this can vary from company to company, worst it can very from project to project. But Microsoft project is the most used software at this moment.So just brush your skills on Microsoft project , its used heavily across industry.
What are static variables?
Dec 11th
Variables that have only one copy per class are known as static variables. They are not attached to a particular instance of a class but rather belong to a class as a whole. They are declared by using the static keyword as a modifier.
static type varIdentifier;
where, the name of the variable is varIdentifier and its data type is specified by type. Note: Static variables that are not explicitly initialized in the code are automatically initialized with a default value. The default value depends on the data type of the variables.
What is normalization? What are different types of normalization?
Dec 9th
It is set of rules that have been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is known as Normalization.
Benefits of normalizing your database will include:
- Avoiding repetitive entries
- Reducing required storage space
- Preventing the need to restructure existing tables to accommodate new data.
- Increased speed and flexibility of queries, sorts, and summaries.
Note :- During interview people are expect to answer maximum of three normal forms and that’s what is expected practically. Actually you can normalize database to fifth normal form. But believe this book will answer three normal forms that will More >
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
Dec 9th
Following are some major differences between a stored procedure and user defined functions:-
- UDF can be executed using the “SELECT” clause while SP’s can not be.
- UDF can not be used in XML FOR clause but SP’s can be used.
- UDF does not return output parameters while SP’s return output parameters.
- If there is an error in UDF its stops executing. But in SP’s it just ignores the error and moves to the next statement.
- UDF can not make permanent changes to server environments while SP’s can change some of the server environment.
What is the main difference between MSML and .NET Framework XML classes?
Dec 9th
MSXML supports XMLDOM and SAX parsers while .NET framework XML classes support XML DOM and XML readers and writers.
MSXML supports asynchronous loading and validation while parsing. For instance you can send synchronous and asynchronous calls to a remote URL. But as such there is not direct support of synchronous and asynchronous calls in .NET framework XML. But same can be achieved by using “System.Net” namespaces.
How is static variable stored in the memory?
Dec 9th
C++ uses name mangling when storing both local and global static varibales at the same place. The local static variables have function name and the global variables will have file name. Essentially the compiler uses namespace to distinguish between local and global static variables.
What Is a Session?
Dec 7th
A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests.
There is only one session object available to your PHP scripts at any time. Data saved to the session by a script can be retrieved by the same script or another script when requested from the same visitor.
Sessions are commonly used to store temporary data to allow multiple PHP pages to offer a complete functional transaction for the same visitor.
