MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
SQL Server automatically creates some system credentials that are associated with specific endpoints. These automatically created system credentials have names that are prefixed with which signs. Choose the correct answer
A
two hash signs (##)
B
two question mark signs (??)
C
two-dollar signs ($$)
D
None of the above
Explanation: 

Detailed explanation-1: -A credential is a record that contains the authentication information (credentials) required to connect to a resource outside SQL Server. This information is used internally by SQL Server. Most credentials contain a Windows user name and password.

Detailed explanation-2: -SQL Server supports two authentication modes, Windows authentication mode and mixed mode. Windows authentication is the default, and is often referred to as integrated security because this SQL Server security model is tightly integrated with Windows.

Detailed explanation-3: -When a user connects with a specified login name and password from a non-trusted connection, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded.

There is 1 question to complete.
Previous
Next