Broadcom-VMware
5V0-91.20 · Question #108
An administrator ran the following query. SELECT name, VERSION, install_location, install_source, publisher, install_date, uninstall_string FROM programs WHERE publisher = "Microsoft Corporation"…
The correct answer is A. Edit the WHERE clause to remove the quotes. See the full explanation below for the reasoning.
Question
An administrator ran the following query.
SELECT name, VERSION, install_location, install_source, publisher, install_date, uninstall_string
FROM programs WHERE publisher = "Microsoft Corporation".
The administrator notices a lot of installed programs are not returned.
How can the administrator alter the query to see all results?
Options
- AEdit the WHERE clause to remove the quotes
- BRemove the WHERE clause
- CReplace the = with LIKE
- DChange the WHERE clause to = ""
How the community answered
(40 responses)- A73% (29)
- B3% (1)
- C18% (7)
- D8% (3)
Community Discussion
No community discussion yet for this question.