You friend is trying to familiarize herself with the DBCC commands with SQL server. Which command can she/he use to check if indexes are in the proper sorted order and if page offsets are reasonable?
DBCC CHECKDB
DBCC NEWALLOC
DBCC CHECKALLOC
DBCC CHECKCATALOG