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. ALTER TABLE Production.ProductCost DROP CONSTRAINT PK_Product WITH (ONLINE = ON) GO
  2. ALTER TABLE Production.ProductCostHistory DROP CONSTRAINT PK_Product DROP INDEX Index_Product WITH (ONLINE = ON) GO
  3. DROP INDEX Index_Product ON Production.ProductCostGO
Answer: Answer is c
Further Reading:

Useful resources, Dropping Indexes


  1. Geography

  2. Longitude

  3. Altitude

  4. Geometry

  5. Latitude

Answer: Answer is a, d
Further Reading:

Useful resources, spatial data types


  1. CREATE VIEW permission in database

  2. ALTER permission on schema

  3. CONTROL permission on object

Answer: Answer is a, b
Further Reading:

Create a view requires CREATE VIEW permission in the database and ALTER permission on the schema in which the view is being created.Useful resources, CREATE VIEW


  1. When a table or index is created, data compression is set to NONE, unless otherwise specified.

  2. Nonclustered indexes inherit the compression property of the table

  3. New pages allocated in a heap as part of DML operations will not use PAGE compression until the heap is rebuilt.

  4. When you are compressing indexes, leaf-level pages can be compressed with only page compression.

Answer: Answer is a, c
Further Reading:

Useful resources,Data Compression


  1. System stored procedures

  2. Triggers

  3. SQL DDL syntax

  4. None of the above

Answer: Answer is b

  1. Extensible Key Management

  2. SOAP Security

  3. Hashing

  4. Transparent Data Encryption

Answer: Answer is a, d
Further Reading:

Useful resources, Security


  1. True

  2. False

Answer: Answer is a
Further Reading:

Useful resources,CHECK Constraints


  1. ALTER SERVER AUDIT <audit_name> WITH (ENABLE=TRUE)

  2. ALTER SERVER AUDIT <audit_name> SET (ENABLE=TRUE)

  3. ALTER SERVER AUDIT <audit_name> WITH (STATE=ON)

  4. ALTER SERVER AUDIT <audit_name> SET (STATE=ON)

Answer: Answer is c
Further Reading:

Useful resources, alter server audit


  1. 0000

  2. NULL

  3. 1234

  4. None of the above

Answer: Answer is b
Further Reading:

If the -P option is used at the end of the command prompt without a password sqlcmd uses the default password (NULL). Useful resources, sqlcmd utility


  1. Real

  2. Rowversion

  3. type_var

  4. sql_variant

  5. monetary

Answer: Answer is d
Further Reading:

Useful resources, sql_variant


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.

;