SQL Server interview questions part 2
SQL Server interview questions part 2
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Fill From Example tool also produces a patterns report similar to :
Correct Answer is : Analyze Key Influencers
2. Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table ?
Correct Answer is : Highlight Exceptions
3. Scenario Analysis tool allows you to model _______ types of scenarios.
Correct Answer is : 2
4. In order to use the Analyze in Excel feature, you must have ___________ installed on the system.
Correct Answer is : SSDT
5. The _________ wizard helps you build a classification model based on existing data in an Excel table.
Correct Answer is : Classify
6. Which of the following code is used to enable the sa login ?
Correct Answer is : ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '' ;
GO
7. Point out the correct statement :
Correct Answer is : Microsoft’s best practice recommendation is that you use Windows authentication mode whenever possible
8. Which of the following feature prefers SQL Server authentication mode over windows authentication?
Correct Answer is : Backward compatibility
9. Windows Authentication Mode is not available when an instance of SQL Server is running on :
Correct Answer is : Windows 98
10. Point out the wrong statement :
Correct Answer is : Account administration details in windows mode is stored in passive directory
11. Which of the following authentication modes is more secure ?
Correct Answer is : Windows Authentication
12. By using Windows Authentication, Windows groups can be created at the _________ level.
Correct Answer is : Domain
13. ________ optional password policies are available for SQL Server logins.
Correct Answer is : 3
14. Which of the following is the biggest disadvantage of SQL Server Authentication mode ?
Correct Answer is : SQL Server Authentication cannot use Kerberos security protocol
15. The Windows password policies enforced for SQL Server logins depends upon _____________________ API.
Correct Answer is : NetValidatePasswordPolicy
16. Backing up your SQL Server database is essential for _______ your data.
Correct Answer is : protecting
17. Point out the correct statement :
Correct Answer is : Using differential backups can save available space
18. How many types of backups are provided by SQL Server ?
Correct Answer is : 8
19. Features provided by SQL Server backups include :
Correct Answer is : All of the mentioned
20. Point out the wrong statement :
Correct Answer is : SQL Server 2008 Enterprise and later versions support compressing backups
