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                      
tip   To Refer this Site to Your Friends   Click 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 do you use DBCC statements to monitor various aspects of
a SQL server installation?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you use DBCC statements to monitor various aspects of a SQL server installation?
Answer
# 1		 
DBCC stands for database consistency checker. We use these 
commands to check the consistency of the databases, i.e., 
maintenance, validation task and status checks.DBCC 
CHECKDB - Ensures that tables in the db and the indexes are 
correctly linked.and DBCC CHECKALLOC To check that all 
pages in a db are correctly allocated. DBCC SQLPERF - It 
gives report on current usage of transaction log in 
percentage. DBCC CHECKFILEGROUP - Checks all tables file 
group for any damage.
 
Is This Answer Correct ?    0 Yes 0 No
Thiyagaraj.ramaswamy
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
please tell me the query to get details of the employee having the second largest salary 247Customer8
How to Debug a Stored Procedure? Allianz4
How to retrieve data from log files in SQL SERVER ?????  1
How do you find the number of rows in a table?  5
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?  9
write the query for taking database restore in sql?  2
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  4
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.  1
What are functions  3
How are SQL Server databases physically stored under Windows 2000?  1
what is the query and condition to delete datas in sql server.  2
What is a sub-query? When would you use one?  3
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
WHAT IS UNIQUE IDENTIFIER DATA TYPE? Sparsh2
how to get the rowid/rownumbes of a table in sqlserver IBM5
what is normalization? what is denormalization? Satyam5
how to get 25th row in any table in sqlserver can u tell me syntax  4
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
What are SQL Jobs, please mention the use of it and how to create them. 247Customer1
 
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