DBA > Interview Resource

Microsoft SQL Server interview questions for DBA

Part:   1  2  3  4  5  6  7  8  9 

(Continued from previous part...)

Database administration (3)


Explain CREATE DATABASE syntax

Many of us are used to craeting databases from the Enterprise Manager or by just issuing the command: CREATE DATABAE MyDB.


Let’s assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?

You have to use transfer command.


But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%?

That's why being a DBA you should be familiar with the CREATE DATABASE syntax.


When you create a database how is it stored?

It is stored in two separate files: one file contains the data, system tables, other database objects, the other file stores the transaction log.


How to determine the service pack currently installed on SQL Server?

The global variable @@Version stores the build number of the sqlservr.exe, which is used to determine the service pack installed. To know more about this process visit SQL Server service packs and versions.


What is new philosophy for database devises for SQL Server 7.0?

There are no devises anymore in SQL Server 7.0. It is file system now.


Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

Types of backups you can create in SQL Sever 7.0+ are Full database backup, differential database backup, transaction log backup, filegroup backup. Check out the BACKUP and RESTORE commands in SQL Server books online. Be prepared to write the commands in your interview. Books online also has information on detailed backup/restore architecture and when one should go for a particular kind of backup.


What is a default TCP/IP socket assigned for SQL Server?

1433

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9