gs gs116 Laying the Foundation - SQL Server Powershell - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Laying the Foundation. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following command is used to get child items in powershell?
Get-Child
Set-Alias
Get-Command
Get-ChildItem
Question 2: Point out the wrong statement.
Get-Command retrieve basic information about a command
Trace-Command trace an expression or command
Get-Content delete content from a file
None of the mentioned
Question 3: ___________ convert object properties into CSV objects.
ConvertFrom-CSV
Convert-CSV
ConvertFromCSV
All of the mentioned
Question 4: What will be the output of the following code?
PS C:\bin> notepad hello.ps1
Text editor with “Hello world” scripted
Text editor with “Hello” scripted
Text editor with no script
All of the mentioned
Question 5: Point out the wrong statement.
The first PowerShell cmdlet every administrator should learn is Get-Command
Get-Event is used to find events in the PowerShell event queue
Limit-EventLog is used to limit the size of the event log
None of the mentioned
Question 6: Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________
Get-Process
Get-Member
Get-Process | Get-Member
All of the mentioned
Question 7: Unrestricted execution policy can be set up in SQL Server can be done using __________
Set-ExecutionPolicy Unrestricted
Set-Policy Unrestricted
Set-Policy Unrestricted
None of the mentioned
Question 8: Code for creating an HTML report that lists the name of each service along with its status is __________
Get-Ser | ConvertTo-HTML -Property Name, Status > C:\services.htm
Get-Service | Property Name, Status > C:\services.htm
Get-Service | ConvertTo-HTML -Property Name, Status > C:\services.htm
All of the mentioned
Question 9: Which of the following code list all the log files in Window?
snippet Clear-Host $Directory = "C:\Windows\"` -ErrorAction SilentlyContinue snippet Clear-Host $Files = Get-Childitem $Directory -recurse -Include *.log ` -ErrorAction SilentlyContinue snippet Clear-Host $Directory = "C:\Windows\" $Files = Get-Childitem $Directory -recurse -Include *.log ` -ErrorAction SilentlyContinue
All of the mentioned
Question 10: Which of the following code snippet will return output as false?
PS C:\bin> $myData = "01/28/1969" PS C:\bin> $mydata -isdata[string] PS C:\bin> $myData = "01/28/1969" PS C:\bin> $mydata -isnot [string] PS C:\bin> $myData = "01/28/1969" PS C:\bin> $mydata -not [string] PS C:\bin> $myData = "01/28/1969" PS C:\bin> $mydata -isString [string] Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
