dot Net Database Interview Preparation Guide
Strengthen your dot Net Database interview skills with our collection of 23 important questions. Each question is designed to test and expand your dot Net Database expertise. Suitable for all experience levels, these questions will help you prepare thoroughly. Dont miss out on our free PDF download, containing all 23 questions to help you succeed in your dot Net Database interview. Its an invaluable tool for reinforcing your knowledge and building confidence.23 dot Net Database Questions and Answers:
1 :: What is State?
Four type of states are as under:
1.Application state
2.Session state
3.Cookie state
4.View state.
1.Application state
2.Session state
3.Cookie state
4.View state.
2 :: What is 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
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
3 :: Explain What are the types of cookies are there?
There are two types of cookies
1)Persistance
2)Impersistance
1)Persistance
2)Impersistance
4 :: Explain 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.
5 :: Explain What is indexing?
An index
1. is sorted by key values, (that need not be the same as those of the table)
2. is small, has just a few columns of the table.
3. refers for a key value to the right block within the table.
4. speeds up reading a row, when you know the right search arguments.
1. is sorted by key values, (that need not be the same as those of the table)
2. is small, has just a few columns of the table.
3. refers for a key value to the right block within the table.
4. speeds up reading a row, when you know the right search arguments.
6 :: Explain atleast three methods of response object other than Redirect?
a) Response.Clear( )
Clears the content of the current output stream.
b) Response.Close( )
Closes the network socket for the current response.
c) Response.End( )
Stops processing the current request and sends all buffered content to the client immediately.
Clears the content of the current output stream.
b) Response.Close( )
Closes the network socket for the current response.
c) Response.End( )
Stops processing the current request and sends all buffered content to the client immediately.
7 :: How to deploy an asp.net application?
We can deploy an ASP.NET Web application using any one of the following three deployment options.
a) Deployment using VS.NET installer
b) Using the Copy Project option in VS .NET
c) XCOPY Deployment
a) Deployment using VS.NET installer
b) Using the Copy Project option in VS .NET
c) XCOPY Deployment
8 :: Explain What is the maximum length of a varchar in SQL Server?
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.
Null-terminated Unicode character string of length n,
with a maximum of 255 characters. If n is not supplied, then 1 is assumed.
9 :: Explain an execution plan? When would you use it? How would you view the execution plan?
The Query Analyzer has a feature called Show Execution Plan. This option allows you to view the execution plan used by SQL Servers Query Optimizer to actually execute the query. This option is available from the Query menu on the main menu of Query Analyzer, and must be turned on before the query is executed. Once the query is executed, the results of the execution plan are displayed in graphical format in a separate window, available from a tab that appears below the query results window on the screen.
10 :: Explain atleast two methods of response object other than Transfer?
a) Response.ClearContent( )
Clears the content of the current output stream.
b) Response.ClearHeaders( )
Clears the HTTP headers from the current output stream.
Clears the content of the current output stream.
b) Response.ClearHeaders( )
Clears the HTTP headers from the current output stream.