COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
There are two levels at which you configure Azure Firewall Rules:Server and Database.
|
|
|
You can only reset passwords using the ALTER LOGIN Transact-SQL statement.
|
|
|
The trusted server application model is commonly used in large-scale enterprise applications, websites, and Internet services.
|
|
|
In a Windows-based environment, administrators can enable policies for Windows users that enforce password complexity and expiration. SQL Server can enforce similar restrictions for SQL Server logins.
|
|
|
To connect to SQL Server, the principal must supply information that matches the credential data held by SQL Server.
|
Detailed explanation-1: -So to change a password in SQL Server, you need to execute the ALTER LOGIN statement.
Detailed explanation-2: -The correct answer to the question “Which of the SQL statements is correct” is option (b). SELECT Username, Password FROM Users. And all the other options are incorrect.
Detailed explanation-3: -To change the name of a user requires the ALTER ANY USER permission. To change the target login of a user requires the CONTROL permission on the database. To change the user name of a user having CONTROL permission on the database requires the CONTROL permission on the database.
Detailed explanation-4: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.