ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to restart SQL Server in single user mode? How to start 
SQL Server in minimal configuration mode?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Answer
# 1		 
Sql Server can be started from command line, using the 
Sqlserver.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
 
Is This Answer Correct ?    6 Yes 4 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How reterive duplicate value in SQL?  5
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person  7
What are the types of model in sql server and explain TCS1
what is web server? Satyam3
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?  1
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?  4
What is blocking and how would you troubleshoot it?  1
create index a on employee(dno) In this,which index was created?  2
What is Schema? and why we use schemas?  1
What are mdf,ndf,ldf files and how to see the data in those files? Accenture5
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000  11
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18  2
How To delete duplicate record from a particular table? eXensys10
could u plz explain about joins and views?  2
Which databases are part of SQL server default installation? Explain the usage of each? Accenture2
Can you give an example of Stored Procedure?  2
What is indexed views? plz explain with example?  1
What is the datatype returned by count(*) Asian-CERC18
What are the types of backup and tell me the difference between full and differential backup? TCS3
how to find nth highest salary NexGen30
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com