Interviews World
Home  |  Contact Us |  Sitemap | 
 .Net (166)
 
  .Net Framework(43)
  .Net Memory Management(2)
  .Net Web Service(6)
  .Net Remoting(30)
  .Net Security(2)
  .Net Threading(8)
  .Net Architecture(2)
  Basic C#(33)
  VB.Net(2)
  .Net Window Service(3)
  .Net Window Forms(14)
  Advanced C#(25)
  Visual Studio 2003(2)
  Visual Studio 2005(2)
  Visual Studio 2008(2)
  Visual Studio 2010(2)
 
 ASP.Net (49)
 
  ASP.NET General(7)
  ASP.NET Caching(9)
  ASP.NET Ajax(13)
  ASP.NET Session(7)
  ASP.NET Localisation(2)
  ASP.NET 1.1(2)
  ASP.NET 2.0(2)
  ASP.NET 3.5(11)
  ASP.NET 4.0(2)
 
 Database (88)
 
  SQL Server 2000(20)
  SQL Server 2005(24)
  SQL Server 2008(42)
 
 ADO.Net (7)
 
  General ADO.NET(7)
 
 Object Oriented (27)
 
  Basic Object Oriented(19)
  Advanced Object Oriented(8)
 
 XML (24)
 
  Basic XML(24)
 
 MS Dynamics (1)
 
  MS Dynamics GP 9(2)
  MS Dynamics GP 10(1)
  MS Dynamics Soloman(2)
  MS Dynamics CRM 3.0(2)
  MS Dynamics CRM 4.0(2)
  MS Dynamics CRM 5.0(2)
 
 Sharepoint (65)
 
  Basic SharePoint(35)
  SharePoint Server 2003(4)
  SharePoint Server 2007(25)
  SharePoint Server 2010(2)
 
 HR (2)
 
  Basic HR(2)
 
 Java (1)
 
  Basic Java(1)
 
 PHP (2)
 
  Basic PHP(2)
 
 Testing (15)
 
  Automation Testing(15)
 
 
  Welcome to Interviews World
 
$5 .COM Black Friday Sale!
Question : On a computer running Windows Server 2003 or later hosting a SQL Server instance, which of the following password policies are checked for a SQL Server login when CHECK_POLICY is ON and CHECK_EXPIRATION is OFF?
Answer :

 

  • Enforce password history
  • Minimum password age
  • Minimum password length
  • Password must meet complexity requirements

There is nothing written specifically indicating which policies are checked by CHECK_POLICY. The answer was determined by experimentation (SQL Server 2005 SP2 on Vista). A SQL Server login was created, then a query window was opened with the connection made using that login. ALTER LOGIN WITH PASSWORD = ''OLD_PASSWORD'' was run when various policies were applied.

 
 
  Website Highlights
 
How does “Side by Side” work for the .NET Framework 3.0?
How does servicing work for the .NET Framework 3.0? If I install the .NET Framework 3.0, can I get service updates for the .NET Framework 2.0?
What’s the difference between System.String and System.StringBuilder classes?
What’s the difference between Cache object and application object ?
7. C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write?
What’s the top .NET class that everything is derived from?
What’s the .NET datatype that allows the retrieval of data by a unique key?
What is the relationship between Microsoft SharePoint Portal Server and Microsoft Windows Services?
How does “Side by Side” work for the .NET Framework 3.0?
What are the advantages and disadvantages of viewstate?
What’s a Windows process?
How’s anchoring different from docking?
How many events (including user-configurable) are available to be monitored using Profiler?
What’s an abstract class?
What operating systems will the .NET Framework 3.0 be available for?
What’s the difference between Java and .NET garbage collectors?
What’s the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception?
How many files are involved with SQL Server Extended Events Targets?
What is a meeting workspace?
Can each user have access to their own calendar?
 
 
 
  Newsleter
 
Enter your Email:
Newsletter
 

©2007-2008 interviewsworld.com All Rights Reserved. | About Us | Contact Us | Disclaimer | Privacy Policy | Terms Of Service
User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License