|
.Net Database Interview Questions and Answers
What is indexing?
If we give proper indexes on a table so that any queries
written against this table can run efficiently. As your
data sets grow over time, SQL Server will continue to
rebuild indexes and move data around as efficiently as
possible. This property is known as Indexing.
Explain differences between Server.Transfer and
server.execute method?
Answer1:
server.transfer-> transfers the server’s control to the
requested page given in the parameter.
server.Execute-> executes the requested page from the
current page itself, with no change in the address bar.
after execution the next line of code is executed in the
current page.
Answer2.
Execute method returns control to the page in which it
is called once the page specified in the Execute method
finishes processing, the Transfer method does not return
control to the calling page.
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 eliminated.
De-normalization can improve efficiency and performance
by reducing complexity in a data warehouse schema.
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 98, and Windows
Millennium Edition. It also runs on all editions of
Microsoft Windows NT version 4.0. The database engine is
a robust server that can manage terabyte-sized databases
accessed by thousands of users. Availability - SQL
Server 2000 can maintain the extremely high levels of
availability required by large Web sites and enterprise
systems. Integration -The SQL Server 2000 TCP/IP Sockets
communications support can be integrated with Microsoft
Proxy Server to implement secure Internet and intranet
communications.
What is DataWarehousing?
A data warehouse is a collection of data gathered and
organized so that it can easily by analyzed, extracted,
synthesized, and otherwise be used for the purposes of
further understanding the data.
What is OLAP?
OLAP is an acronym for On Line Analytical Processing. It
is an approach to quickly provide the answer to
analytical queries that are dimensional in nature.
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.
Click Yes, upgrade my to start the upgrade process, and
then click Next. The upgrade runs until finished.
In the Connect to Server dialog box, select an
authentication mode, and then click Next.
If you are not sure which mode to use, accept the
default: The Windows account information I use to log on
to my computer with (Windows). In Start Copying Files
dialog box, click Next.
Now your Sql Server would be upgraded.
What is job?
It can be defined as a task performed by a computer
system. For example, printing a file is a job. Jobs can
be performed by a single program or by a collection of
programs.
What is Task?
Whenever you execute a program, the operating system
creates a new task for it. The task is like an envelope
for the program: it identifies the program with a task
number and attaches other bookkeeping information to it.
How do you find the error, how can you know the number
of rows affected by last SQL Statement?
Answer1
@@errors->give the last error occurred in the current DB.
Ans. select @@rowcount
Answer2.
Use @@ERROR which returns the error number for the last
Transact-SQL statement executed fro knowing the error.
Use @@ROWCOUNT which returns the number of rows affected
by the last statement for finding the no of rows
affected.
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 in the history.
Advantages - On ordinary Web Forms pages, their view
state is sent by the server as a hidden variable in a
form, as part of every response to the client, and is
returned to the server by the client as part of a
postback. However, to reduce bandwidth demand when using
mobile controls, ASP.NET does not send a page’s view
state to the client. Instead, the view state is saved as
part of a user’s session on the server. Where there is a
view state, a hidden field that identifies this page’s
view state is sent by the server as part of every
response to the client, and is returned to the server by
the client as part of the next request.
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
|
