MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
True or False? The following code can be used to add SalesMan1 to the master database:USE master GOCREATE USER SalesMan1 WITH PASSWORD = ‘Pa55w.rd’ GO
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Explanation: Master database includes information about the file locations of the user databases, as well as logon accounts, server configuration settings, and a number of other items such as linked servers and startup stored procedures.

Detailed explanation-2: -A trigger is a database object that runs automatically when an event occurs.

Detailed explanation-3: -You can configure server-level IP firewall rules by using the Azure portal, PowerShell, or Transact-SQL statements. The maximum number of server-level IP firewall rules is limited to 128 when configuring using the Azure portal.

There is 1 question to complete.