SQL SERVER INTERVIEW QUESTION & ANSWERS
| 46. |
How many ways are there to create a new database in SQL SERVER 2008? |
| |
We can create a new database using either Management Studio or Transact-SQL. To create a new database using Management Studio,
- Open SQL Server Management Studio and connect the Object Explorer to the database engine on SQL Server where you want to create the database.
- Right-click the Databases folder and select New Database.
- Enter the name for the new database in the Database Name text box.
- Click the OK button to create the new database.
In Transact-SQL, select New Query in Management Studio type and execute the statement like CREATE DATABASE Database_Name.
|
| 47. |
What do you know about FilestReam? |
| |
Filestream storage is a new feature of SQL Server 2008 that integrates the database engine with the NTFS file system. Data that is stored in a column that is defined as FILESTREAM can be accessed by retrieving a file handle and using that file handle with Win32 API calls. Columns using the varbinary(max) data type with the FILESTREAM column attribute can provide access to the data using traditional methods or as files on the file system. Applications may modify the files as needed, while continuing to maintain transactional consistency.
|
| 48. |
How to set the read-only state to a perticular database? |
| |
- Select properies using Mouse right click on a selected database in Management Studio.
- Go to option and change the status for read-only.
|
| 49. |
How to remove a database from an instance without deleting? |
| |
- Open SQL Server Management Studio, and in the Object Explorer view, connect to the server that contains the database we would like to detach. Expand the Databases folder, and find the database to detach.
- Right-click on the database, and choose Tasks -> Detach from the context menu and click the OK button to remove a database from an instance.
|
| 50. |
How to attach a database using SQL Server Management Studio? |
| |
- Open SQL Server Management Studio, and in the Object Explorer view, connect to the server that we would like to attach the database to.
- Right-click the Databases folder, and choose Attach from the context menu.
- In the Attach Databases window, click the Add button, and choose the primary data file of the database you would like to attach
- Verify that any secondary database files and log files are in the appropriate path
- Click OK to attach the database.
|
