adplus-dvertising
frame-decoration

Question

Which of the following code is used to enable the sa login?

a.

ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

b.

ALTER LOGIN sa DISABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

c.

ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN san WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

d.

None of the mentioned

Posted under SQL Server

Answer: (a).ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following code is used to enable the sa login?
Add Comment

Similar Questions

Discover Related MCQs

Q. Point out the correct statement.

View solution

Q. Which of the following feature prefers SQL Server authentication mode over windows authentication?

View solution

Q. Windows Authentication Mode is not available when an instance of SQL Server is running on ____________

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following authentication modes is more secure?

View solution

Q. By using Windows Authentication, Windows groups can be created at the _________ level.

View solution

Q. ________ optional password policies are available for SQL Server logins.

View solution

Q. Which of the following is the biggest disadvantage of SQL Server Authentication mode?

View solution

Q. The Windows password policies enforced for SQL Server logins depends upon _____________________ API.

View solution

Q. What is the syntax for HAS_PERMS_BY_NAME in SQL Server 2014?

View solution

Q. Point out the correct statement.

View solution

Q. _________ returns a list of the permissions effectively granted to the principal on a securable.

View solution

Q. What is the syntax for fn_my_permissions function in SQL Server 2014?

View solution

Q. Point out the wrong statement.

View solution

Q. The schema securable scope contains the following securable is __________

View solution

Q. Which of the following returns a row for each security principal in a SQL Server database?

View solution

Q. Any SQL Server authentication login can see ________ login name.

View solution

Q. To add or remove server role membership use ____________

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following script creates master key?

View solution
View All MCQs on SQL Server

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...