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

Mcq Answers for SQL Server

  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. True

  2. False

Answer: Answer is a
Further Reading:

Useful resources,CHECK Constraints





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

  1. The number of columns must be same in all queries.

  2. The order of columns must be same in all queries.

  3. The data types of the columns of the queries must be compatible.

  4. There should be at least one common column in the tables which are part of the UNION operation.

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

Useful resources, union


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.