SQL Server interview questions part 20
SQL Server interview questions part 20
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following column is a part of syspolicy_policies result ?
Correct Answer is : All of the mentioned
2. How many types of execution mode are present in syspolicy_policies ?
Correct Answer is : 4
3. ____________ displays the condition expressions that were executed,
Correct Answer is : syspolicy_policy_execution_history_details
4. Purpose of syspolicy_system_health_state in policy based management is :
Correct Answer is : Displays one row for each Policy-Based Management policy
5. Which of the following command is used to get child items in powershell ?
Correct Answer is : Get-ChildItem
6. Point out the wrong statement :
Correct Answer is : Get-Content delete content from a file
7. ___________ convert object properties into CSV objects.
Correct Answer is : ConvertFrom-CSV
8. The output of the following code is: PS C:\bin> notepad hello.ps1
Correct Answer is : Text editor with no script
9. Point out the wrong statement :
Correct Answer is : The first PowerShell cmdlet every administrator should learn is Get-Command
10. Syntax for viewing the methods and properties we can pipe our output to Get-Member by :
Correct Answer is : Get-Process | Get-Member
11. Unrestricted execution policy can be set up in SQL Server can be done using :
Correct Answer is : Set-ExecutionPolicy Unrestricted
12. Code for creating an HTML report that lists the name of each service along with its status is :
Correct Answer is : Get-Service | ConvertTo-HTML -Property Name, Status > C:\services.htm
13. Which of the following language is used for procedural flow in SQL Server ?
Correct Answer is : Control-of-flow language
14. Point out the correct statement :
Correct Answer is : All of the mentioned
15. Which of the following is a control flow keyword ?
Correct Answer is : GOTO
16. Point out the wrong statement :
Correct Answer is : GOTO permissions need not be granted to any user
17. Which of the following two Transact-SQL statements are commonly used with WHILE ?
Correct Answer is : BREAK and CONTINUE
18. Which of the following scenario makes use of BEGIN..END keyword redundant ?
Correct Answer is : when an IF statement controls the execution of only one Transact-SQL statement
19. The BEGIN and END statements are used when:
Correct Answer is : All of the mentioned
20. Which of the following components constitutes use CASE expression ?
Correct Answer is : The CASE keyword
