News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Online Test Knowledge of SQL Server 2008 Skills

  1. With DDL, you can create and remove tables, schemas, domains, indexes and views.

  2. SELECT, INSERT and UPDATE are DCL commands.

  3. GRANT and REVOKE are DML commands.

  4. COMMIT and ROLLBACK are DCL commands.

Answer: Answer is a

  1. It checks the allocation of all the objects in the specified database.

  2. It checks the structural integrity of all the objects in the specified database.

  3. It checks for consistency in and between system tables in the specified database.

  4. It checks the consistency of disk space allocation structures of a specified database.

Answer: Answer is a, b, d
Further Reading:

DBCC CHECKALLOC - Checks the consistency of disk space allocation structures for a specified database.

DBCC CHECKTABLE- Checks the integrity of all the pages and structures that make up the table or indexed view.

DBCC CHECKCATALOG-Checks for catalog consistency within the specified database. The database must be online.

Useful resources,DBCC CHECKDB, DBCC CHECKDB


Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;