SQL Server MCQ Questions with answers and solutions Page 25

Q. The Packages of SQL Server Extended Events consist of

(A) Predicates
(B) Types
(C) Events
(D) All of the above

💬 Discuss

✅ Correct Answer: (D) All of the above

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:11 am in SQL Server

Q. Which of these fields has a varbinary data type in the case of cdc.lsn_time_mapping?

(A) tran_id
(B) start_lsn
(C) tran_begin_time
(D) all of the above

💬 Discuss

✅ Correct Answer: (A) tran_id

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:11 am in SQL Server

Q. Which of these identifies a query plan uniquely for any batch that has been executed and whose plans reside in our plan cache?

(A) sql_handle
(B) pool_name
(C) plan_handle
(D) none of the above

💬 Discuss

✅ Correct Answer: (C) plan_handle

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:11 am in SQL Server

Q. Which of these backups are taken in full recovery models only or in bulk?

(A) Active
(B) Log
(C) Replica
(D) Passive

💬 Discuss

✅ Correct Answer: (B) Log

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:12 am in SQL Server

Q. Which of these would cause a server to raise a certain error whenever the MS SQL Server Analysis Services also finds an error in the MDX script?

(A) IgnoreNone
(B) IgnoreAll
(C) Ignore
(D) All of the above

💬 Discuss

✅ Correct Answer: (A) IgnoreNone

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:12 am in SQL Server

Q. Which of these tools analyse as well as highlights those data rows that do NOT match the general patterns of the rest of the table?

(A) Highlight
(B) Exceptions
(C) Highlight Exceptions
(D) Scenario Analysis

💬 Discuss

✅ Correct Answer: (C) Highlight Exceptions

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:12 am in SQL Server

Q. What is the Space Requirement for the SQL Server 2012 R2 Hard Disk for the database engines?

(A) 511 MegaBytes
(B) 611 MegaBytes
(C) 711 MegaBytes
(D) 811 MegaBytes

💬 Discuss

✅ Correct Answer: (D) 811 MegaBytes

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:13 am in SQL Server

Q. Which of these would hold some set of temporary data?

(A) Msdb
(B) Tempdb
(C) Master
(D) Northwind

💬 Discuss

✅ Correct Answer: (B) Tempdb

Published by Vinay Kumar ⭐ 8.55K Points at 23-Jul-2022 07:13 am in SQL Server

Q. How do we delete a login ?

(A) DELETE LOGIN login_name
(B) DROP LOGIN login_name
(C) A login cannot be deleted but only disabled
(D) DISABLE LOGIN login_name

💬 Discuss

✅ Correct Answer: (B) DROP LOGIN login_name

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:15 pm in SQL Server

Q. In which database state, the database is in single-user mode and may be repaired or restored.

(A) OFFLINE
(B) SUSPECT
(C) EMERGENCY
(D) All of the above

💬 Discuss

✅ Correct Answer: (C) EMERGENCY

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:15 pm in SQL Server

SQL Server MCQs with answers Page - 25

Q. The Packages of SQL Server Extended Events consist of

Q. Which of these fields has a varbinary data type in the case of cdc.lsn_time_mapping?

Q. Which of these identifies a query plan uniquely for any batch that has been executed and whose plans reside in our plan cache?

Q. Which of these backups are taken in full recovery models only or in bulk?

Q. Which of these would cause a server to raise a certain error whenever the MS SQL Server Analysis Services also finds an error in the MDX script?

Q. Which of these tools analyse as well as highlights those data rows that do NOT match the general patterns of the rest of the table?

Q. What is the Space Requirement for the SQL Server 2012 R2 Hard Disk for the database engines?

Q. Which of these would hold some set of temporary data?

Q. How do we delete a login ?

Q. In which database state, the database is in single-user mode and may be repaired or restored.

Programming Categories

📱 Download Our App