VMware Security Specialist — Question 10

Given the following query:
SELECT * FROM users WHERE UID >= 500;
Which statement is correct?

Answer options

• A. This query limits the number of columns to display in the results.
• B. This query filters results sent to the cloud.
• C. This query is missing a parameter for validity.
• D. This query returns all accounts found on systems.

Correct answer: A

Explanation

The correct answer is A because the query uses SELECT * to retrieve all columns from the 'users' table, but the WHERE clause does not limit the rows based on UID. Options B and C are incorrect as they misinterpret the purpose of the query, and D incorrectly states the scope of the results as it is based on a specific condition.