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...


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.


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

Post New Answer

More SQL Server Interview Questions

What are filegroups in sql server?

0 Answers  


What is the difference between cartesian product and cross join?

0 Answers  


What is the difference between sdf and mdf?

0 Answers  


How to create a dynamic cursor with the dynamic option?

0 Answers  


what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


What is sql stored procedure?

0 Answers  


How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,


What is difference between count (*) and count column?

0 Answers  


How to trouble shoot if unable to connect SQL Server

0 Answers  


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  


What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  


Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,


Categories