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
|
True
|
|
False
|
|
Either A or B
|
|
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.