70-243 · Question #69
Your network contains a System Center 2012 Configuration Manger environment. You wirte the following query: select SYS.Name from SMS_R_System SYS join SMS_G_System_ADD_REMOVE_PROGRAMS ARP on…
The correct answer is C. where ARP.DisplayName like "Microsoft Office%". For relational operators that perform LIKE comparisons ("is like" or "is not like"), you can use wildcard characters within the string. You can use the following wildcards. Wildcard Description Any string of zero or more characters Any single character Any single character…
Question
Your network contains a System Center 2012 Configuration Manger environment. You wirte the following query:
select SYS.Name from SMS_R_System SYS join SMS_G_System_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = SYS.ResourceId You need to create a list of all the client computers that have a version of Microsoft Office installed. What should you add to the query?
Options
- Awhere ARP.DisplayName like "Microsoft Office*"
- Bwhere ARP.DisplayName = "Microsoft Office*"
- Cwhere ARP.DisplayName like "Microsoft Office%"
- Dwhere ARP.DisplayName = "%Microsoft Office"
How the community answered
(35 responses)- A9% (3)
- B17% (6)
- C71% (25)
- D3% (1)
Explanation
For relational operators that perform LIKE comparisons ("is like" or "is not like"), you can use wildcard characters within the string. You can use the following wildcards. Wildcard Description Any string of zero or more characters Any single character Any single character within the range or set (for example [a-f] or [abcdef]) [^] Any single character not within the specified range (for example [^a-f] or [^abcdef])
Topics
Community Discussion
No community discussion yet for this question.