Practice 1000 Sql Server Multiple Choice Questions with Answers Quiz-2

Q.1.

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

Explanation

Q.2.

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

a) Brackets
b) Parenthesis
c) Full stop
d) Comma

Explanation

Q.3.

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

Explanation

Q.4.

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

Explanation

Q.5.

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

Explanation

Q.6.

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

Explanation

Q.7.

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

a) replication
b) protecting
c) preventing
d) none of the mentioned

Explanation

Q.8.

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

Explanation

Q.9.

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

Explanation

Q.10.

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

Explanation

Q.11.

Which of the following operation requires to run the SQL Server Setup on the node?

a) Update
b) Add
c) Remove
d) All of the mentioned

Explanation

Q.12.

Which of the following tool is used for purpose of data auditing for SQL Server only?

a) Idera
b) ApexSQL
c) SQL Ninja
d) SQL Audit

Explanation

Q.13.

Which of the following is the benefit of SQL Server Profiler?

a) Correlating performance counters to diagnose problems
b) Capturing the series of Transact-SQL statements that lead to a problem
c) Finding and diagnosing slow-running queries
d) All of the mentioned

Explanation

Q.14.

Which of the following catalog view is used for SQL Server Extended Events?

a) sys.server_event_session_actions
b) sys.server_sessions
c) sys.server_event_sess
d) all of the mentioned

Explanation

Support mcqgeeks.com by disabling your adblocker.