.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 35 36 37 38 39 40 41 >   Sort: Date

ADO.NET features? Benefits? Drawbacks?
ADO.NET features? Benefits? Drawbacks? Answer 1: 1. Data will be retrieved through Datasets 2. Scalability Answer 2: 1. Disconnected Data Architecture 2. Data cached in Datasets 3. Data transfer in XML format 4. Interaction with the database is done through data commands 2013-12-10, 1484👍, 0💬

State True or False: Static method cannot be overridden: * True or * False
State True or False: Static method cannot be overridden: * True or * False True 2014-06-20, 1481👍, 0💬

A Few of the Namespaces that get imported by default in an ASPX file are ...
A Few of the Namespaces that get imported by default in an ASPX file are ... A Few of the Namespaces that get imported by default in an ASPX file are * System, System.Data, System.Drawing, System.Globalization * System, System.IO, System.Management, System.Globalization * System, System.Collections,... 2014-08-20, 1479👍, 0💬

How does VB.NET/C# achieve polymorphism?
How does VB.NET/C# achieve polymorphism? By using Abstract classes/functions. 2014-01-22, 1479👍, 0💬

What are the advantages/disadvantages of viewstate?
What are the advantages/disadvantages of viewstate? Disadvantages - Because the view state for a given page must be kept on the server, it is possible for the current state to be out of synchronization with the current page of the browser, if the user uses the Back feature on the browser to go back ... 2014-11-05, 1472👍, 0💬

What is de-normalization? When do you do it and how?
What is de-normalization? When do you do it and how? De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It’s used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be el... 2014-10-27, 1466👍, 0💬

How to find the SQL server version from Query Analyser
How to find the SQL server version from Query Analyser Answer1 To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement: SELECT SERVERPROPERTY(’productversi on’),SERVE... 2014-10-08, 1466👍, 0💬

How do you define an integer in SQL Server?
How do you define an integer in SQL Server? We define integer in Sql server as var_name int 2014-09-17, 1462👍, 0💬

What are the different methods to access Database in .NET ?
What are the different methods to access Database in .NET ? What are the different methods to access Database in .NET ? * OleDB,ODBC,SQLClient * OleDB, JDBC, SQLServer * ODBC-JDBC, DataSet, SQLClient * Datasource, DataSet, DSN OleDB,ODBC,SQLClient 2014-07-17, 1459👍, 0💬

What are cursors? Name four type of cursors and when each one would be applied?
What are cursors? Name four type of cursors and when each one would be applied? Opening a cursor on a result set allows processing the result set one row at a time. The four API server cursor types supported by SQL Server are: a) Static cursors b) Dynamic cursors c) Forward-only cursors d) Keyset-dr... 2014-10-17, 1453👍, 0💬

What are good ADO.NET object(s) to replace the ADO Recordset object?
What are good ADO.NET object(s) to replace the ADO Recordset object? The differences includes In ADO, the in-memory representation of data is the recordset. In ADO.net, it is the dataset A recordset looks like a single table in ADO In contrast, a dataset is a collection of one or more tables in ADO.... 2014-09-08, 1452👍, 0💬

What will be output for the given code?
What will be output for the given code? What will be output for the given code? Dim I as integer = 5 Do I = I + 2 Response.Write (I &amp; " ") Loop Until I &gt; 10 * 5 8 * 5 7 9 * 7 9 11 * Errors out 7 9 11 (if corrected) 2014-09-02, 1446👍, 0💬

What does it mean to have quoted_identifier on? What are the implications of having it off?
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-92 rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transa... 2014-10-15, 1442👍, 0💬

How do we upgrade SQL Server 7.0 to 2000?
How do we upgrade SQL Server 7.0 to 2000? Run the installation of the SQL Server 2000 In the Existing Installation dialog box, click Upgrade your existing installation, and then click Next. In the Upgrade dialog box, you are prompted as to whether you want to proceed with the requested upgrade. Clic... 2014-10-31, 1433👍, 0💬

What does Server.MapPath do?
What does Server.MapPath do? Answer1 srver.mappath() maps the path given in the argument to the server’s physical path. Answer2 It returns the complete(absolute) path of the file used in parameter. Answer3 It returns a string containing the physical path in the server’s file system that corres... 2014-09-29, 1427👍, 0💬

A new server-side control can be created by implementing the class ___________
A new server-side control can be created by implementing the class ___________ A new server-side control can be created by implementing the class ___________ * System.Web.WebControl * System.Web.UI.WebControl * System.Web.UI.WebControls.WebC ontrol* Any one of the above System.Web.UI.WebControls.Web. .. 2014-06-27, 1424👍, 0💬

How do you call and execute a Stored Procedure in.NET? Give an example.
How do you call and execute a Stored Procedure in.NET? Give an example. Answer1 ds1=new DataSet(); sqlCon1=new SqlConnection(connectionstring );String strCom1=”byroyalty”; sqlCom1=new SqlCommand(strCom1,sqlCon1); sqlCom1.CommandType=CommandTyp e.StoredProcedure;sqlDa1=new SqlDataAdapter(sqlCom... 2014-09-15, 1422👍, 0💬

How does you handle this COM components developed in other programming languages in.NET?
How does you handle this COM components developed in other programming languages in.NET? Answer1: add the component in add reference window, click .NETCOM tab. Answer1: While adding the refferences we can handle the COM components in other .Net programming languages. 2014-11-12, 1414👍, 0💬

What is the maximum length of a varchar in SQL Server?
What is the maximum length of a varchar in SQL Server? Answer1 VARCHAR[(n)] Null-terminated Unicode character string of length n, with a maximum of 255 characters. If n is not supplied, then 1 is assumed. Answer2 8000 Answer3 The business logic is the aspx.cs or the aspx.vb where the code is being w... 2014-09-15, 1390👍, 0💬

How do you find the error, how can you know the number of rows affected by last SQL Statement?
How do you find the error, how can you know the number of rows affected by last SQL Statement? Answer1 @@errors-&gt;give the last error occured in the current DB. Ans. select @@rowcount Answer2. Use @@ERROR which returns the error number for the last Transact-SQL statement executed fro knowing t... 2014-11-03, 1388👍, 0💬

What is the STUFF function and how does it differ from the REPLACE function?
What is the STUFF function and how does it differ from the REPLACE function? Answer1: stuff-&gt; inserts into it without removing any thing. Replace-&gt;replace the given text with the new one. Answer2: STUFF - it deletes a specified length of characters and inserts another set of characters... 2014-10-13, 1384👍, 0💬

Which of the following is the C# escape character for Null?
Which of the following is the C# escape character for Null? Which of the following is the C# escape character for Null? * \n * \0 * \f * \v \0 2014-08-06, 1382👍, 0💬

Explain features of SQL Server like Scalibility, Availability, Integration with Internet.
Explain features of SQL Server like Scalibility, Availability, Integration with Internet. Scalibility - The same Microsoft SQL Server 2000 database engine operates on Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, Windows 98, and Windows M... 2014-10-27, 1362👍, 0💬

What is the use of trace utility?
What is the use of trace utility? Tracing is a very important monitoring and debugging tool for distributed, multitier applications. Such applications often contain problems that can only be observed when the application is under a heavy load and the inherent randomness of a real-life environment. T... 2014-11-10, 1357👍, 0💬

<< < … 35 36 37 38 39 40 41 >   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML