gs gs116 Security - SQL Server Authentication - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Security. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following code is used to enable the sa login?
ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ; GO ALTER LOGIN sa DISABLE ; GO ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ; GO ALTER LOGIN sa ENABLE ; GO ALTER LOGIN san WITH PASSWORD = '<enterStrongPasswordHere>' ; GO
None of the mentioned
Question 2: Point out the correct statement.
SQL Server 2008 offers three authentication mode options
Microsoft’s best practice recommendation is that you use Windows authentication mode whenever possible
If you use mixed authentication mode, you should enable the DBA’s Windows account
None of the mentioned
Question 3: Which of the following feature prefers SQL Server authentication mode over windows authentication?
Backward compatibility
Forward compatibility
Security
All of the mentioned
Question 4: Windows Authentication Mode is not available when an instance of SQL Server is running on ____________
Windows 98
Windows 7
Windows 95
All of the mentioned
Question 5: Point out the wrong statement.
Windows authentication mode dramatically reduces the chances of error or oversight
Account administration details in windows mode is stored in passive directory
The sa account is a well-known SQL Server account and it is often targeted by malicious users
All of the mentioned
Question 6: Which of the following authentication modes is more secure?
SQL Server Authentication
Windows Authentication
Mixed Mode
All of the mentioned
Question 7: By using Windows Authentication, Windows groups can be created at the _________ level.
Login
Domain
User
None of the mentioned
Question 8: ________ optional password policies are available for SQL Server logins.
2
3
5
All of the mentioned
Question 9: Which of the following is the biggest disadvantage of SQL Server Authentication mode?
SQL Server Authentication cannot use Kerberos security protocol
Allows SQL Server to support Web-based applications where users create their own identities
Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication
None of the mentioned
Question 10: The Windows password policies enforced for SQL Server logins depends upon _____________________ API.
NetValidate
NetValidatePasswordPolicy
NetValidatePolicy
ValidatePasswordPolicy
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
