|
.Net Database Interview Questions and Answers
Describe session handling in webform. How does it
work and what are the limits?
Session management in ASP.NET can be done in two ways:
Using Cookies
Encoding of URLs with Session ID
Explain differences between framework 1.0 and framework
1.1?
1. Native Support for Developing Mobile Web Applications
2. Unified Programming Model for Smart Client
Application Development
3. Enable Code Access Security for ASP.NET Applications
4. Native Support for Communicating with ODBC and Oracle
Databases
5. Supports for IPv6
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 methods. Friend
WithEvents DataGrid1 As System.Windows.Forms.DataGrid
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.
Trace utility allows developers and administrators to
monitor the health of applications running in real-life
settings.
What are the differences between User control and Web
control and Custom control?
Answer1:
Usercontrol-> control that is created as u wish.
Web Control-> any control placed in web page (web
application page)
Custom Control-> same as user control with some
difference.
user control custome control
1.easy to create difficult
2.no full suport for customers using
Visual studio tools Full support
3. Seperate copy of the control in each
assembly only one copy in global assembly.
4. best for static layout best for dynamic layout.
Answer2
User control
1) Reusability web page
2) We can’t add to toolbox
3) Just drag and drop from solution explorer to page (aspx)
4) Good for static layout
5) Easier to create
6) Not complied into DLL
Custom controls
1) Reusability of control (or extend functionalities of
existing control)
2) We can add toolbox
3) Just drag and drop from toolbox
4) You can register user control to. Aspx page by
Register tag
5) A single copy of the control is required in each
application
6) Good for dynamic layout
7) Hard to create
8) Compiled in to dll
Custom controls
1) Reusability of control
2) Pre defined Control
3) Just drag and drop from toolbox
If I have more than one version of one assemblies, then
how will I use old version in my application? Give an
example.
Change the assembly version number in the
AssemblyInfo.vb file
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.
How will you register COM+ services?
Through X-Copy Deployment.
How do u call and execute a stored procedure in .NET?
system.Data;
system.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();
What are the different types of replication? How are
they used?
Replication is used for distributing data and the
execution of stored procedures across an enterprise. The
replication technology allows you to make duplicate
copies of your data, move those copies to different
locations, and synchronize the data automatically so
that all copies have the same data values.
The different types of replications are
a) transactional replication
b) merge replication
How do SQL Server 2000 and XML linked? What is SQL
Server agent?
Every Request or the Response to or from SQL Server is
converted into XML format. Its purpose is to ease the
implementation of tasks for the DBA, with its
full-function scheduling engine, which allows you to
schedule your own jobs and scripts.
How do you create thread in .NET?
1) Import System.Threading
2) Create a new thread using new Thread() and assign the
address of the method
3) Use Thread.Start method to start the execution
using System;
using System.Threading;
public class Test
{
static void Main()
{
ThreadStart job = new ThreadStart(ThreadJob);
Thread thread = new Thread(job);
thread.Start();
for (int i=0; i
Page Numbers :
1
2
3
4
5
Have a Question ?
post your questions here. It
will be answered as soon as possible.
Check
Microsoft .Net Interview
Questions for more Microsoft .Net Interview Questions with answers
Check
Asp .Net Interview
Questions for more Asp .Net Interview Questions with answers
Check
.Net
Deployment Interview
Questions for more .Net Deployment Interview Questions with answers
|
