Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

Ques 11. Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message?

When you try to install SQL Server 2005 Express Edition, you may get a Microsoft SQL Server 2005 Setup error box with this message: "The Microsoft .Net Framework 2.0 in not installed. Please install before running setup."
You are getting this error, because .NET Framework 2.0 is not installed on your system yet. Read the next tutorial to download and install .NET Framework 2.0.

Is it helpful? Add Comment View Comments
 

Ques 12. How to rename databases in MS SQL Server?

If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax:

ALTER DATABASE database_name
MODIFY NAME = new_database_name

The tutorial example below shows you how change the database name from "withoutbookdb" to "withoutbook":

ALTER DATABASE withoutbookdb
MODIFY NAME = withoutbook
GO

The database name 'withoutbook' has been set.

Is it helpful? Add Comment View Comments
 

Ques 13. How to download and install Microsoft .NET Framework Version 2.0?

.NET Framework Version 2.0 is required by many Microsoft applications like SQL Server 2005. If you want download and install .NET Framework Version 2.0, you should follow this tutorial:

1. Go to the Microsoft .NET Framework Version 2.0 Redistributable Package (x86) page.

2. Click the Download button. Save the download file dotnetfx.exe to c:temp.

3. Look at and compare the downloaded file properties with:

Name: dotnetfx.exe
Location: C:temp
Size: 23,510,720 bytes
Version: 2.0.50727.42

4. Close all IE (Internet Explorer) windows.

5. Double click the downloaded file: to c:tempdotnetfx.exe. The Microsoft .NET Framework 2.0 Setup windows shows up. Follow the instructions to finish the installation.

Is it helpful? Add Comment View Comments
 

Ques 14. Why I am getting this error when renaming a database in MS SQL Server?

If you are trying to rename a database that is in use, you will get an error message like this: "The database could not be exclusively locked to perform the operation."

Before renaming a database, you must stop all client sessions using this database. Otherwise, you will get an error as shown in this tutorial example:

1. Launch one instance of SQL Server Management Studio and run:

USE withoutbook
GO

2. Keep the first instance running and launch another instance of SQL Server Management Studio:

ALTER DATABASE withoutbook
MODIFY NAME = withoutbookdb
GO
Msg 5030, Level 16, State 2, Server LOCALHOSTSQLEXPRESS
The database could not be exclusively locked to perform
the operation.

Obviously, the first instance is blocking the "ALTER DATABASE" statement.

Is it helpful? Add Comment View Comments
 

Ques 15. What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN?

Process mscorsvw.exe is installed as a system service as part of the .NET Framework 2.0. You can disable it, if you are not using any applications that require .NET Framework 2.0.

mscorsvw.exe process and program file info:

CPU usage: 00%
Memory usage: 2,704K
Launching method: System Service
Directory:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727
File name: mscorsvw.exe
Description: .NET Runtime Optimization Service
Size: 66,240 bytes
Date: Friday, September 23, 2005, 7:28:56 AM
Version: 2.0.50727.42
Company name: Microsoft
System essential: No
Virus/Spyware/Adware: No

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

©2024 WithoutBook