Top 33 Asp Dot Net Database Interview Questions
Q1. Explain Features Of Sql Server Like Scalability , Availability, Integration With Internet?
Scalability:The same Microsoft SQL Server 2000 database engine operates on Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, Windows ninety eight, and Windows Millennium Edition. It also runs on all editions of Microsoft Windows NT version 4.@The database engine is a sturdy server which could manage terabyte-sized databases accessed with the aid of lots of users.
Availability:SQL Server 2000 can hold the extremely excessive stages of availability required by using large Web sites and employer structures.
Integration:The SQL Server 2000 TCP/IP Sockets communications guide may be included with Microsoft Proxy Server to enforce secure Internet and intranet communications.
Q2. What Is State?
It is the belongings of the internet bureaucracy.
ASP.NET affords four styles of state:
Application nation
Session kingdom
Cookie nation
View nation.
Q3. Which Dll File Is Needed To Be Registered For Asp?
The dll wished for the ASP.Net is SYSTEM.WEB.Dll
Q4. Explain Differences Between Framework 1.Zero And Framework 1.1?
Native Support for Developing Mobile Web Applications
Unified Programming Model for Smart Client Application Development
Enable Code Access Security for ASP.NET Applications
Native Support for Communicating with ODBC and Oracle Databases
Supports for IPv6
Q5. How Do We Upgrade Sql Server 7.Zero To 2000?
Run the set up of the SQL Server 2000
In the Existing Installation dialog field, click on Upgrade your existing set up, and then click Next.
In the Upgrade conversation field, you are induced as to whether or not you want to proceed with the requested upgrade. Click Yes, improve my to start the improve procedure, and then click on Next. The improve runs until finished.
In the Connect to Server dialog container, pick out an authentication mode, after which click on Next.
If you are not certain which mode to apply, receive the default: The Windows account records I use to go online to my computer with (Windows). In Start Copying Files conversation container, click on Next.
Now your Sql Server would be upgraded.
Q6. How Do You Use Dbcc Statements To Monitor Various Aspects Of A Sql Server Installation?
Database Consistency Checker (DBCC) - Is a declaration used to test the logical and physical consistency of a database, check memory utilization, decrease the scale of a database, take a look at performance facts, and so forth. Database consistency checker (DBCC) guarantees the bodily and logical consistency of a database, but isn't always corrective. DBCC can help in repairing or checking the set up in case of any failure.
Q7. If We Write Any Code For Datagrid Methods, What Is The Access Specifier Used For That Methods In The Code Behind File And Why And How? Give An Example?
We use Friends Modifer for the dataGrid techniques. Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
Q8. What Is The Purpose Of Using Collate In A Query?
Collation refers to a hard and fast of regulations that decide how information is looked after and as compared. Character facts is looked after using policies that define the perfect man or woman series, with alternatives for specifying case-sensitivity, accessory marks, kana man or woman sorts and person width.
Q9. What Are The Types Of Cookies Are There?
Two kind of cookeies.
1 unmarried valued
Example: request.Cookies(?UserName?).Fee=?Mahesh?
2 Multivalued cookies.
These are used in the way collections are used.
Example:
request.Cookies(?CookiName?)(?UserName?)=?Mahesh?
Request.Cookies(?CookiName?)(?UserID?)=?ABC003?
Rember no price approach in multivalued cookie
Q10. What Is Task?
Whenever you execute a software, the running device creates a brand new venture for it. The challenge is like an envelope for the program. It identifies the program with a undertaking range and attaches other bookkeeping facts to it.
Q11. What Is De-normalization? When Do You Do It And How?
De-normalization is the system of trying to optimize the performance of a database by means of adding redundant facts. It's used To introduce redundancy right into a desk that allows you to incorporate facts from a associated desk. The related desk can then be removed. De-normalization can enhance efficiency and overall performance through reducing complexity in a information warehouse schema.
Q12. Name Atleast Two Methods Of Response Object Other Than Trfer?
A) Response.ClearContent( ):
Clears the content of the present day output movement.
B) Response.ClearHeaders( ):
Clears the HTTP headers from the contemporary output circulation.
Q13. What Is The Stuff Function And How Does It Differ From The Replace Function?
STUFF - It deletes a distinct period of characters and inserts every other set of characters at a designated start line.
REPLACE - Replaces all occurrences of a specified string value with any other string cost.
Q14. What Is An Execution Plan? When Would You Use It? How Would You View The Execution Plan?
The Query Analyzer has a function referred to as Show Execution Plan. This alternative lets in you to view the execution plan used by SQL Server's Query Optimizer to definitely execute the query. This option is to be had from the Query menu on the main menu of Query Analyzer, and have to be turned on before the query is carried out. Once the query is carried out, the outcomes of the execution plan are displayed in graphical layout in a separate window, to be had from a tab that appears underneath the question consequences window at the screen.
Q15. How Do You Create Thread In .Internet?
Import System.Threading
Create a new thread using new Thread() and assign the deal with of the approach
Use Thread.Start technique to begin the execution
using System;
the use of System.Threading;
public magnificence Test
static void Main()
ThreadStart process = new ThreadStart(ThreadJob);
Thread thread = new Thread(activity);
thread.Start();
for (int i=zero; i
Q16. What Are The Differences Between User Control And Web Control And Custom Control?
Usercontrol-> manage that is created as u desire.
Web Control-> any manipulate located in internet page (net software page)
Custom Control-> equal as consumer manipulate with a few distinction.
Person control custome control
smooth to create hard
no full suport for customers the use of
Visual studio equipment Full help
Seperate copy of the manage in every meeting most effective one replica in international assembly.
Great for static layout excellent for dynamic layout.
Q17. How Can You Deploy An Asp.Net Application ?
You can set up an ASP.NET Web software the usage of any one of the following three deployment options.
Deployment using VS.NET installer
Using the Copy Project choice in VS .NET
XCOPY Deployment
Q18. What Are Cursors? Name Four Type Of Cursors And When Each One Would Be Applied?
Opening a cursor on a end result set lets in processing the result set one row at a time.
The four API server cursor sorts supported with the aid of SQL Server are:
Static cursors
Dynamic cursors
Forward-most effective cursors
Keyset-driven cursors
Q19. What Does It Mean To Have Quoted_identifier On? What Are The Implications Of Having It Off?
SET QUOTED_IDENTIFIER ON- Causes SQL Server to follow the SQL-ninety two regulations regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited through double quotation marks can be either Tract-SQL reserved key phrases or can comprise characters no longer typically allowed by using the Tract-SQL syntax rules for identifiers.
Q20. If There Is A Calendar Control To Be Included In Each Page Of Your Application, And And We Do Not Intend To Use The Microsoft-provided Calendar Control, How Do You Develop It? Do You Copy And Paste Th
Create the Calendar User Control
The manage we are able to create will comprise a calendar control and a label which has the corresponding date and time written
Steps are:-
Creating a CalenderControl
To begin, open Visual Studio .NET and begin a brand new C# Windows Control Library.
You may also call it anything you like, for this pattern the undertaking call can be CalenderControl
Using the Calender Control in a Windows Application
It's just like adding any other control like a button or a label.
First, create a brand new Windows Application challenge named: CustomControl.
Add a reference to the Calender Control DLL named: CalenderControl.Dll.
Now you a can customize the Toolbox:
Right-Click the Toolbox> .NET Framework Components> Browse> choose the CalenderControl.Dll.
The Calender Control is now brought to the Toolbox and can be inserted in Windows Form as another manipulate. The manage itself will deal with the date show
Q21. What Are Good Ado.Net Object(s) To Replace The Ado Recordset Object?
The variations consists of
In ADO, the in-memory illustration of information is the Recordset.In ADO.Internet, it's miles the dataset
A recordset seems like a unmarried desk in ADO.In contrast, a dataset is a set of 1 or extra tables in ADO.Internet
ADO is designed basically for linked get entry to,ADO.Internet the disconnected get right of entry to to the database is used
In ADO you communicate with the database by way of making calls to an OLE DB company.
In ADO.NET you talk with the database through a facts adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter item), which makes calls to an OLE DB provider or the APIs furnished by using the underlying information supply.
In ADO you cant replace the database from the recordset. ADO.NET the information adapter permits you to manipulate how the modifications to the dataset are trmitted to the database.
Q22. How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?
Use @@ERROR which returns the mistake variety for the remaining Tract-SQL statement performed fro knowing the error.
Use @@ROWCOUNT which returns the wide variety of rows affected by the remaining announcement for locating the no of rows affected.
Q23. How Does You Handle This Com Components Developed In Other Programming Languages In .Internet?
While adding the refferences we can deal with the COM components in other .Net programming languages.
Q24. What Are The Different Types Of Replication? How Are They Used?
Replication is used for distributing statistics and the execution of saved procedures throughout an enterprise. The replication era lets in you to make duplicate copies of your records, move the ones copies to unique locations, and synchronize the facts automatically so that all copies have the same records values.
The one of a kind types of replications are:
tractional replication
merge replication
Q25. How Do U Call And Execute A Stored Procedure In .Internet?
Gadget.Data;
gadget.Data.SqlClient;
SqlConnection sqCon = new SqlConnection(?Connection string);
SqlCommand sqCmd = new SqCmd();
sqCmd.Connection = sqCon;
sqCmd.CommandText = procedure_name;
sqCmd.CommandType = CommandType.StoredProcedure;
sqComd.ExecuteReader();
Q26. How Do Sql Server 2000 And Xml Linked? What Is Sql Server Agent?
Every Request or the Response to or from SQL Server is transformed into XML layout. Its cause is to ease the implementation of responsibilities for the DBA, with its complete-feature scheduling engine, which allows you to schedule your very own jobs and scripts.
Q27. What Is The Use Of Trace Utility?
Tracing is a completely important monitoring and debugging tool for dispensed, multitier programs. Such programs often contain issues that could simplest be observed whilst the application is below a heavy load and the inherent randomness of a actual-lifestyles surroundings. Trace software permits builders and directors to display the fitness of programs running in actual-existence settings.
Q28. What Is Referential Integrity And How Can We Achieve It?
Referential integrity preserves the described relationships among tables whilst facts are entered or deleted. In SQL Server, referential integrity is primarily based on relationships among overseas keys and number one keys or between foreign keys and precise keys. Referential integrity ensures that key values are steady across tables. Such consistency calls for that there be no references to nonexistent values and that if a key cost changes, all references to it exchange always for the duration of the database. We can gain this by way of the usage of foreign key.
Q29. What Is The Purpose Of Update Statistics?
UPDATE STATISTICS- it updates records about the distribution of key values for one or more information organizations (collections) in the precise table or listed view.
Q30. What Is Indexing?
If we deliver proper indexes on a desk in order that any queries written against this desk can run successfully. As your records units develop over the years, SQL Server will maintain to rebuild indexes and flow facts round as correctly as viable. This property is known as Indexing.
Q31. Explain Differences Between Server.Trfer And Server.Execute Method?
Server.Trfer-> trfers the server's control to the requested web page given in the parameter.
Server.Execute-> executes the asked page from the contemporary page itself, with out a alternate within the deal with bar. After execution the subsequent line of code is achieved inside the present day page.
Q32. Describe Session Handling In Webform. How Does It Work And What Are The Limits?
Session management in ASP.NET can be completed in ways:
Using Cookies
Encoding of URLs with Session ID
Q33. What Is The Maximum Length Of A Varchar In Sql Server?
8000
