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)
 
 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)
 
 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)
 
 Sharepoint (65)
 
  Basic SharePoint(35)
  SharePoint Server 2003(4)
  SharePoint Server 2007(25)
 
 HR (2)
 
  Basic HR(2)
 
 Java (1)
 
  Basic Java(1)
 
 PHP (2)
 
  Basic PHP(2)
 
 Testing (15)
 
  Automation Testing(15)
 
 
  Welcome to Interviews World
 
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
 
What is the use of store procedure sp_validname?
How to connect QTP with Outlook.
What is the relationship between XAML and other transaction protocols?
How does “Side by Side” work for the .NET Framework 3.0?
Will C# 3.0, VB.NET 9.0, Atlas, or Linq be included in the .NET Framework 3.0?
Which class does the remote object has to inherit ?
If you wish to create a spatial index in SQL Server 2008, which of the following is required? (select all that apply)
We use SQL Server Profiler for performance very frequently. What are the units of the values returned in the READ and WRITE columns in SQL Server Profiler?
In SQL Server 2008's Full-text Search, when a term is found in a thesaurus, does the query recursively search for further matches on the replacement or expansion?
what is the difference between SharePoint Portal Server and Windows SharePoint Services?
What is a document workspace?
What is a site definition?
What is Microsoft Windows Services?
Can I create custom templates in sharepoint?
Can I get domain name for my Web site?
I am located outside of the United States. Are there any restrictions or requirements for accessing the Windows SharePoint Services?
Are there any browser recommendations?
What security levels are assigned to users?
How customizable is the user-to-user access?
Can SharePoint be linked to an external data source?
 
 
 
  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