Sign Up Login


  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

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

What is a Trace frag?Where can we use this?

1 Answers  

Can we insert data into a view?

0 Answers  

what are the advanced features in sql 2008?

2 Answers   Wipro,

Display a roll having miminum marks in two subjects?

7 Answers   Patni,




Can we call future method from trigger?

0 Answers  

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

What is the default value of an integer data type in sql server 2005?

0 Answers  

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

What have included columns when we talk about sql server indexing?

0 Answers  

Which data type columns are the best candidates for full-text indexing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories