How to restart SQL Server in single user mode? H

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

SQL Server can be started from command line, using the SQLSERVR.EXE. This EXE has some very important parameters with which a DBA should be familiar with. -m is used for starting SQL Server in single user mode and -f is used to start the SQL Server in minimal confuguration mode.

(Continued on next question...)

Other Job Interview Questions

• How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
• Is SQL Server implemented as a service or an application?
• What is the difference between them (Ethernet networks and token ring networks)?
• Database design - What is normalization? Explain different levels of normalization?
• What is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. What are the advantages and disadvantages of this approach?
• What is a default TCP/IP socket assigned for SQL Server?
• What protocol both networks use?
• What's SQL Server
• What is the system function to get the current user's user id?
• What is a default TCP/IP socket assigned for SQL Server?
• More...