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
Q.2
Which is the default field terminator for bulk insert in SQL Server?
  • a) Brackets
  • b) Parenthesis
  • c) Full stop
  • d) Comma
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
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
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
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
Q.7
Backing up your SQL Server database is essential for _______ your data.
  • a) replication
  • b) protecting
  • c) preventing
  • d) none of the mentioned
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
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
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
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
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
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
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
0 h : 0 m : 1 s