nerdexam
Broadcom-VMware

5V0-91.20 · Question #11

Given the following query SELECT hostname, cpu_type, cpu_brand, cpu_physical_cores, cpu_logical_cores, cpu_microcode, (1.0 physical_memory / (10001000*1000)) AS physical_mem_gb, hardware_vendor…

The correct answer is C. This query is missing a filter option. See the full explanation below for the reasoning.

Question

Given the following query SELECT hostname, cpu_type, cpu_brand, cpu_physical_cores, cpu_logical_cores, cpu_microcode, (1.0 * physical_memory / (100010001000)) AS physical_mem_gb, hardware_vendor, hardware_model, hardware_version, hardware_serial FROM system_info; Which statement Is correct?

Options

  • AThis query customizes data from several different tables.
  • BThis query customizes the results returned by the system.
  • CThis query is missing a filter option.
  • DThis query shows data from the physical_mem_gb column.

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    17% (5)
  • C
    72% (21)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 5V0-91.20 Practice