MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Database Mail is not solely used for sending alerts and notifications to administrators; when Database Mail is configured, you can send email from Transact-SQL code
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -SQL Server Agent uses the Windows Management Instrumentation Query Language (WQL) statement provided to identify the specific event.

Detailed explanation-2: -Right-click SQL Server Agent, and then select Properties. Select Alert System. Select Enable Mail Profile. In the Mail system list, select Database Mail.

Detailed explanation-3: -Procedure. Using Object Explorer in SQL Server Management Studio, connect to an instance of SQL Server Database Engine where Database Mail is configured, expand Management, right-click Database Mail, and then select Send Test E-Mail.

Detailed explanation-4: -Database Mail is a feature in SQL Server that allows database applications to send email via SMTP.

There is 1 question to complete.
Previous
Next