Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can you give me some DBCC command options?(Database
consistency check) - 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.

Question Posted / guest

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is a heap?

0 Answers  

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

What do you mean by recursive stored procedure?

0 Answers  

Why we use the openxml clause?

0 Answers  

What is the size of transaction log file?

0 Answers  

Is truncate autocommit?

0 Answers  

Explain the phases a transaction has to undergo?

0 Answers  

difference between sql server2000 and sql server2005

1 Answers   KPMG,

How to find the service pack installed? : sql server database administration

0 Answers  

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

Find nth lowest salary or get nth lowest salary?

0 Answers  

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories