Questions Shared by Arvind Kumar Rathour
Coalesce function return not null value. It is more power full than ISNULL. ISNULL takes two parameters while coalesce can take n number of parameters. This function returns left most non null value. If all arguments are null than coalesce returns null. You can not pass single parameter in coalesce., this will give compile time error
SELECT COALESCE(NULL, NULL, 'foo',NULL,NULL,NULL)
Output : foo
SELECT ISNULL(NULL, 'foo')
Output : foo
SELECT ISNULL(NULL, 'foo',’fop’)
Error : The isnull function requires 2 argument(s).
ASP .Net
- Difference between asp and asp.net
- How do you do exception management?
- If you are using components in your application, how can you handle exceptions raised in a component?
- Can we throw exception from catch block?
- How do you relate an .aspx page with its code behind page?
- What are the types of assemblies and where can u store them and how?
- What is difference between value and reference types?
- Is array reference type / value type?
- Is string reference type / value type?
- What is web.config. How many web.config files can be allowed to use in an application?
- What is difference between machine.config and web.config?
- What is shared and private assembly?
- What are asynchronous callbacks?
- How to write unmanaged code and how to identify whether the code is managed / unmanaged?
- How to authenticate users using web.config?
- What is strong name and which tool is used for this?
- What is gacutil.exe. Where do we store assemblies?
- Should sn.exe be used before gacutil.exe?
- What does assemblyinfo.cs file consists of?
- What is boxing and unboxing?
- Types of authentications in ASP.NET?
- Difference between Trace and Debug?
- Difference between Dataset and DataReader.
- What is custom tag in web.config?
- How do you define authentication in web.Config?
- What is sequence of code in retrieving data from database?
- About DTS package.
- What provider ADO.net use by default?
- Where does web.config info stored? Will this be stored in the registry?
- How do you register the dotnet component or assembly?
- What is stateless asp or asp.net?
- Authentication mechanism in dotnet
- State management in asp.net
- Types of values mode can hold session state in web.config
- About WebService
- What are Http handler?
- What is view state and how this can be done and was this there in asp?
- Types of optimization and name a few and how do u do?
- About DataAdapters
- Features of a Dataset
- How do you do role based security?
- Difference between Response.Expires and Expires.Absolute?
- Types of object in asp.
- About duration in caching technique.
- Types of configuration files and the differences.
- Difference between ADO and ADO.net.
- About Postback.
- If you are calling three SPs from a window application how do u check for the performance of the SPS?
#61607;Database
- What is normalization?
- What is an index and types of indexes. How many number of indexes can be used per table?
- What is a constraint. Types of constraints?
- What are code pages?
- What is referential integrity?
- What is a trigger?
- What are different types of joins?
- What is a self join?
- Authentication mechanisms in Sql Server.
- What are user defined stored procedures?
- What is INSTEAD OF trigger?
- Difference between SQL server 7.0 and 2000?
- How to optimize a query that retrieves data by joining 4 tables?
- Usage of DTS.
- How to disable an index using select query?
- Is non-clustered index faster than clustered index?
- Types of optimization in queries?
- Difference between ISQL and OSQL?
- How you log an exception directly into sql server what is used for this?
- About Replication in Database.
- What is the default optimization done in oracle and sql server?
- How can i make a column as unique?
- How many no of tables can be joined in same sql server?
- How many column can exist per table?
- About Sql Profiler usage?
• Technical
#61607; .NET-
- How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
- What are different authentication types. How do you retrieve user id in case of windows authentication
- For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
- What is custom control. What is the difference between custom control and user control
- What is the syntax for datagrid and specifying columns
- How do you add a javascript function for a link button in a datagrid.
- Does C# supports multi-dimensional arrays
- How to transpose rows into columns and columns into rows in a multi-dimensional array
- What are object oriented concepts
- How do you create multiple inheritance in C#
-- Features and disadvantages of dataset
- What is the difference between and ActiveX dll and control
- How do you perform validations
- What is reflection and disadvantages of reflection
- What is boxing and how it is done internally
- Types of authentications in IIS
- What are the security issues if we send a query from the application
- Difference between ByVal and ByRef
- Disadvantages of COM components
- How do we invoke queries from the application
- What is the provider and namespaces being used to access oracle database
- How do you load XML document and perform validation of the document
- How do you access elements in XML document
- What is ODP.NET
- Types of session management in ASP.NET
- Difference between data reader and dataset
- What are the steps in connecting to database
- How do you register a .NET assembly
- Usage of web.config
- About remoting and web services. Difference between them
- Caching techniques in .NET
- About CLS and CTS
- Is overloading possible in web services
- Difference between .NET and previous version
- Types of caching. How to implement caching?
- Features in ASP.NET.
- How do you do validations. Whether client-side or server-side validations are better?
- How do you implement multiple inheritance in .NET?
- Difference between multi-level and multiple inheritance?
- What are runtime hosts?
- What is an application domain?
- What is viewstate?
- About CLR, reflection and assemblies?
- Difference between .NET components and COM components?
- What does assemblyinfo.cs consists?
- Types of objects in ASP?
Thanks Arvind.
Coalesce function return not null value. It is more power full than ISNULL. ISNULL takes two parameters while coalesce can take n number of parameters. This function returns left most non null value. If all arguments are null than coalesce returns null. You can not pass single parameter in coalesce., this will give compile time error
SELECT COALESCE(NULL, NULL, 'foo',NULL,NULL,NULL)
Output : foo
SELECT ISNULL(NULL, 'foo')
Output : foo
SELECT ISNULL(NULL, 'foo',’fop’)
Error : The isnull function requires 2 argument(s).
ASP .Net
- Difference between asp and asp.net
- How do you do exception management?
- If you are using components in your application, how can you handle exceptions raised in a component?
- Can we throw exception from catch block?
- How do you relate an .aspx page with its code behind page?
- What are the types of assemblies and where can u store them and how?
- What is difference between value and reference types?
- Is array reference type / value type?
- Is string reference type / value type?
- What is web.config. How many web.config files can be allowed to use in an application?
- What is difference between machine.config and web.config?
- What is shared and private assembly?
- What are asynchronous callbacks?
- How to write unmanaged code and how to identify whether the code is managed / unmanaged?
- How to authenticate users using web.config?
- What is strong name and which tool is used for this?
- What is gacutil.exe. Where do we store assemblies?
- Should sn.exe be used before gacutil.exe?
- What does assemblyinfo.cs file consists of?
- What is boxing and unboxing?
- Types of authentications in ASP.NET?
- Difference between Trace and Debug?
- Difference between Dataset and DataReader.
- What is custom tag in web.config?
- How do you define authentication in web.Config?
- What is sequence of code in retrieving data from database?
- About DTS package.
- What provider ADO.net use by default?
- Where does web.config info stored? Will this be stored in the registry?
- How do you register the dotnet component or assembly?
- What is stateless asp or asp.net?
- Authentication mechanism in dotnet
- State management in asp.net
- Types of values mode can hold session state in web.config
- About WebService
- What are Http handler?
- What is view state and how this can be done and was this there in asp?
- Types of optimization and name a few and how do u do?
- About DataAdapters
- Features of a Dataset
- How do you do role based security?
- Difference between Response.Expires and Expires.Absolute?
- Types of object in asp.
- About duration in caching technique.
- Types of configuration files and the differences.
- Difference between ADO and ADO.net.
- About Postback.
- If you are calling three SPs from a window application how do u check for the performance of the SPS?
#61607;Database
- What is normalization?
- What is an index and types of indexes. How many number of indexes can be used per table?
- What is a constraint. Types of constraints?
- What are code pages?
- What is referential integrity?
- What is a trigger?
- What are different types of joins?
- What is a self join?
- Authentication mechanisms in Sql Server.
- What are user defined stored procedures?
- What is INSTEAD OF trigger?
- Difference between SQL server 7.0 and 2000?
- How to optimize a query that retrieves data by joining 4 tables?
- Usage of DTS.
- How to disable an index using select query?
- Is non-clustered index faster than clustered index?
- Types of optimization in queries?
- Difference between ISQL and OSQL?
- How you log an exception directly into sql server what is used for this?
- About Replication in Database.
- What is the default optimization done in oracle and sql server?
- How can i make a column as unique?
- How many no of tables can be joined in same sql server?
- How many column can exist per table?
- About Sql Profiler usage?
• Technical
#61607; .NET-
- How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
- What are different authentication types. How do you retrieve user id in case of windows authentication
- For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
- What is custom control. What is the difference between custom control and user control
- What is the syntax for datagrid and specifying columns
- How do you add a javascript function for a link button in a datagrid.
- Does C# supports multi-dimensional arrays
- How to transpose rows into columns and columns into rows in a multi-dimensional array
- What are object oriented concepts
- How do you create multiple inheritance in C#
-- Features and disadvantages of dataset
- What is the difference between and ActiveX dll and control
- How do you perform validations
- What is reflection and disadvantages of reflection
- What is boxing and how it is done internally
- Types of authentications in IIS
- What are the security issues if we send a query from the application
- Difference between ByVal and ByRef
- Disadvantages of COM components
- How do we invoke queries from the application
- What is the provider and namespaces being used to access oracle database
- How do you load XML document and perform validation of the document
- How do you access elements in XML document
- What is ODP.NET
- Types of session management in ASP.NET
- Difference between data reader and dataset
- What are the steps in connecting to database
- How do you register a .NET assembly
- Usage of web.config
- About remoting and web services. Difference between them
- Caching techniques in .NET
- About CLS and CTS
- Is overloading possible in web services
- Difference between .NET and previous version
- Types of caching. How to implement caching?
- Features in ASP.NET.
- How do you do validations. Whether client-side or server-side validations are better?
- How do you implement multiple inheritance in .NET?
- Difference between multi-level and multiple inheritance?
- What are runtime hosts?
- What is an application domain?
- What is viewstate?
- About CLR, reflection and assemblies?
- Difference between .NET components and COM components?
- What does assemblyinfo.cs consists?
- Types of objects in ASP?
Thanks Arvind.
No comments:
Post a Comment