SQL Server MCQs with answers Page - 3

Dear candidates you will find MCQ questions of SQL Server here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the stored procedure is used to test the SQL injection attack?

  • (A) xp_reg
  • (B) xp_write
  • (C) xp_regwrite
  • (D) all of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. Which is the default field terminator for bulk insert in SQL Server?

  • (A) Brackets
  • (B) Parenthesis
  • (C) Full stop
  • (D) Comma

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following is the main feature of dotConnect for SQL Server?

  • (A) Supports the latest versions of SQL Server
  • (B) Extra data binding capabilities
  • (C) Ability of monitoring query execution
  • (D) All of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following is used to overcome the Replication in SQL Server?

  • (A) Availability problems
  • (B) Maintenance problems
  • (C) Performance problems
  • (D) All of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data

  • (A) unlink
  • (B) import
  • (C) link
  • (D) all of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following SQL Server tools is used to enhance data management and governance?

  • (A) SSDT
  • (B) OBEII
  • (C) SSIT
  • (D) All of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. Backing up your SQL Server database is essential for _______ your data.

  • (A) replication
  • (B) protecting
  • (C) preventing
  • (D) none of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following is the instance of SQL Server that is your production server in log shipping?

  • (A) secondary server
  • (B) primary server
  • (C) secondary database
  • (D) primary database

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following pair of technology is supported in SQL Server?

  • (A) Mirroring and Clustering
  • (B) Mirroring and Log Shipping
  • (C) Mirroring and Replication
  • (D) All of the mentioned

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following is the biggest disadvantage of SQL Server Authentication mode?

  • (A) Allows SQL Server to support Web-based applications where users create their own identities
  • (B) Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication
  • (C) SQL Server Authentication cannot use Kerberos security protocol
  • (D) None of the mentioned

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.