SQL Server MCQ Questions with answers and solutions Page 22

Q. Code for creating an HTML report that lists the name of each service along with its status is __________

(A) Get-Ser | ConvertTo-HTML -Property Name, Status > C:\services.htm
(B) Get-Service | Property Name, Status > C:\services.htm
(C) Get-Service | ConvertTo-HTML -Property Name, Status > C:\services.htm
(D) All of the mentioned

✅ Correct Answer: (C) Get-Service | ConvertTo-HTML -Property Name, Status > C:\services.htm

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:35 pm in SQL Server

Q. Which of the following code list all the log files in Window?

(A) snippet Clear-Host $Directory = "C:\Windows\"` -ErrorAction SilentlyContinue
(B) snippet Clear-Host $Files = Get-Childitem $Directory -recurse -Include *.log ` -ErrorAction SilentlyContinue
(C) snippet Clear-Host $Directory = "C:\Windows\" $Files = Get-Childitem $Directory -recurse -Include *.log ` -ErrorAction SilentlyContinue
(D) All of the mentioned

✅ Correct Answer: (C) snippet Clear-Host $Directory = "C:\Windows\" $Files = Get-Childitem $Directory -recurse -Include *.log ` -ErrorAction SilentlyContinue

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:36 pm in SQL Server

Q. Syntax for creating views is __________

(A) CREATE VIEW AS UPDATE
(B) DROP VIEW AS SELECT
(C) CREATE VIEW AS UPDATE
(D) CREATE VIEW AS SELECT

💬 Discuss

✅ Correct Answer: (D) CREATE VIEW AS SELECT

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:36 pm in SQL Server

Q. You can delete a view with ___________ command.

(A) TRUNCATE VIEW
(B) REMOVE VIEW
(C) DELETE VIEW
(D) DROP VIEW

💬 Discuss

✅ Correct Answer: (D) DROP VIEW

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:37 pm in SQL Server

Q. What is SCHEMABINDING a VIEW?

(A) These are used to show database self describing information
(B) These types of view are defined by users on a specified schema
(C) These are stored only in the Master database
(D) Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view

💬 Discuss

✅ Correct Answer: (C) These are stored only in the Master database

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:37 pm in SQL Server

Q. ___________ is stored only in the Master database.

(A) Database-scoped Dynamic Management View
(B) Complex View
(C) Catalog View
(D) None of the mentioned

💬 Discuss

✅ Correct Answer: (D) None of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:38 pm in SQL Server

Q. If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.

(A) Primary key
(B) Avg
(C) Count
(D) Distinct

💬 Discuss

✅ Correct Answer: (D) Distinct

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:39 pm in SQL Server

Q. All aggregate functions except __________ ignore null values in their input collection.

(A) Sum
(B) Avg
(C) Count(*)
(D) Count(attribute)

💬 Discuss

✅ Correct Answer: (D) Count(attribute)

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:40 pm in SQL Server

Q. A Boolean data type that can take values true, false, and ____________

(A) 0
(B) 1
(C) Null
(D) Unknown

💬 Discuss

✅ Correct Answer: (D) Unknown

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:40 pm in SQL Server

Q. The phrase “greater than at least one” is represented in SQL by ___________

(A) > some
(B) > all
(C) < some
(D) < all

💬 Discuss

✅ Correct Answer: (A) > some

Published by Ram Sharma ⭐ 193.88K Points at 23-Jun-2022 09:41 pm in SQL Server

SQL Server MCQs with answers Page - 22

Q. Code for creating an HTML report that lists the name of each service along with its status is __________

Q. Which of the following code list all the log files in Window?

Q. Syntax for creating views is __________

Q. You can delete a view with ___________ command.

Q. What is SCHEMABINDING a VIEW?

Q. ___________ is stored only in the Master database.

Q. If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.

Q. All aggregate functions except __________ ignore null values in their input collection.

Q. A Boolean data type that can take values true, false, and ____________

Q. The phrase “greater than at least one” is represented in SQL by ___________

Programming Categories

📱 Download Our App