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.

Mcq Answers for SQL Server

  1. ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO

  2. ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO

  3. ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO

  4. ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO

Answer: Answer is c
Further Reading:

Useful resources, Creating Compressed Tables and Indexes


USE Person 
GO
DECLARE @p AS int
SELECT @p=10
SELECT TOP(@p)
FROM Employee
GO

What Will be the output of the above code?

  1. No output is displayed.

  2. A list of first 10 employees is displayed from the Person database.

  3. An incorrect syntax error is displayed.

  4. None of the above.

Answer: Answer is c

  1. Data Compression

  2. Resource Governor

  3. Policy-Based Management

  4. Auditing

Answer: Answer is c
Further Reading:

Policy-Based Management enables the efficient management of multiple SQL Server instances from a single location. It is easy to create policies that control security, database options, object naming conventions, and other settings at a highly granular level. Such policies can evaluate servers for compliance with a set of predefined conditions and help prevent undesirable. Useful resources, Why SQL Server May Be More Suitable For You


  1. ON

  2. OFF

  3. TRUE

  4. FALSE

Answer: Answer is b
Further Reading:

Useful resources, Create Index (Transact-SQL)


  1. DELETE To

  2. MERGE To

  3. CREATE INDEX To

  4. INSERT To

  5. UPDATE To

Answer: Answer is a, d, e

  1. Transact-SQL can be used to SELECT, INSERT, UPDATE, DELETE FILESTREAM data.

  2. The size of the stored data is limited to 2 GB.

  3. You cannot take backup of a database without the FILESTREAM data.

  4. FILESTREAM storage is best used when the BLOB file sizes average 1MB or higher.

Answer: Answer is a, d
Further Reading:

The FILESTREAM data can be accessed and manipulated in two ways – either with the standard Transact-SQL programming model, or via the Win32 streaming APIs. Both mechanisms are fully transaction-aware and support most DML operations including insert, update, delete, and select.BLOBs smaller than 256 kilobytes (KB) are better stored inside a database, and BLOBs larger than 1 megabyte (MB) are best stored outside the database. For those sized between 256 KB and 1 MB, the more efficient storage solution depends on the read vs. write ratio of the data, and the rate of “overwrite”. Storing BLOB data solely within the database (e.g., using the varbinary (max) data type) is limited to 2 gigabytes (GB) per BLOB. Useful resources, FILESTREAM Storage in SQL Server 2008


  1. Tiny Encryption Algorithm

  2. Advanced Encryption Standard(AES)

  3. Blowfish

  4. Triple Data Encryption Standard(3DES)

Answer: Answer is b, d
Further Reading:

Useful resources, Transparent Data Encryption (TDE)


  1. sp_renamedb oldname,newname

  2. sp_renamedb newname,oldname

  3. sp_dbrename oldname,newname

  4. sp_rename oldname,newname

Answer: Answer is a
Further Reading:

Useful resources,rename a SQL Server database


  1. IGNORE_DUP_KEY cannot be set to ON for XML indexes.

  2. IGNORE_DUP_KEY can be set to ON for spatial indexes.

  3. IGNORE_DUP_KEY can be set to ON for filtered indexes.

  4. IGNORE_DUP_KEY can be set to ON for XML indexes.

  5. IGNORE_DUP_KEY cannot be set to ON for indexes created on a view.

Answer: Answer is a, e
Further Reading:

IGNORE_DUP_KEY cannot be set to ON for indexes created on a view, non-unique indexes, XML indexes, spatial indexes, and filtered indexes. Useful resources, Create Index


  1. 0 and 66020

  2. 1 and 65530

  3. 0 and 65534

  4. 1 and 65535

Answer: Answer is c
Further Reading:

The login time-out must be a number between 0 and 65534. Useful resources, ssbdiagnose Utility


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.

;