i am getting some consistency error in one of my database, what may be the options to correct the inconsistencies?
Run this:
USE [your_db_name_that_has_the_errors]
DBCC CHECKDB () WITH NO_INFOMSGS
Then, if there are errors on an index number higher than 1, script out the index(es), drop them, then recreate them.
If the index # is 1 (or 0), that is the table itself, and you'll have to look at using one of the REPAIR options.