quiz SQL Server MCQ Practice

corporate_fare Computing and Information Technology
school B.Sc. Computer Science
30 Questions
0 Completed
0 Correct
0 of 30 completed
visibility You're studying as a guest — progress isn't saved. Sign in to track progress
help Question 1
radio_button_unchecked

What is SQL Server?

help Question 2
radio_button_unchecked

When was the first version of Microsoft SQL Server released?

help Question 3
radio_button_unchecked

Which of the following is a free database software running free SQL Server technology?

help Question 4
radio_button_unchecked

Which of the following companies originally worked together to create and market the first version of SQL Server?

help Question 5
radio_button_unchecked

What is the Codename for SQL Server 2012?

help Question 6
radio_button_unchecked

Which was the first version of SQL Server to introduce in-memory capability?

help Question 7
radio_button_unchecked

Which of the following data type is not present in SQL Server?

help Question 8
radio_button_unchecked

Which database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators?

help Question 9
radio_button_unchecked

SQL Server has mainly how many types of views?

help Question 10
radio_button_unchecked

Which of the following is not a SQL Server INFORMATION_SCHEMA view?

help Question 11
radio_button_unchecked

Which of the following joins are SQL server default?

help Question 12
radio_button_unchecked

Which of the following is not a class of constraint in SQL Server?

help Question 13
radio_button_unchecked

Which of the reasons will force you to use the XML data model in SQL Server?

help Question 14
radio_button_unchecked

What is the hybrid model in SQL Server?

help Question 15
radio_button_unchecked

Which of the following feature of SQL Server was used before XML technology for semi structured data?

help Question 16
radio_button_unchecked

Which of the following language is used for procedural flow in SQL Server?

help Question 17
radio_button_unchecked

Exception handling is possible in SQL Server using _____________

help Question 18
radio_button_unchecked

Which of the following stored procedure is already defined in SQL Server?

help Question 19
radio_button_unchecked

DML triggers in SQL Server is applicable to _____________

help Question 20
radio_button_unchecked

User defined function in SQL Server can return ____________

help Question 21
radio_button_unchecked

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

help Question 22
radio_button_unchecked

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

help Question 23
radio_button_unchecked

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

help Question 24
radio_button_unchecked

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

help Question 25
radio_button_unchecked

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

help Question 26
radio_button_unchecked

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

help Question 27
radio_button_unchecked

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

help Question 28
radio_button_unchecked

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

help Question 29
radio_button_unchecked

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

help Question 30
radio_button_unchecked

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