nerdexam
Microsoft

70-433 · Question #135

You have a database that contains two tables named ProductCategory and ProductSubCategory. You need to write a query that returns a list of product categories that contain more than ten sub…

The correct answer is C. SELECT [Name]. See the full explanation below for the reasoning.

Question

You have a database that contains two tables named ProductCategory and ProductSubCategory. You need to write a query that returns a list of product categories that contain more than ten sub- categories. Which query should you use?

Options

  • ASELECT [Name]
  • BSELECT [Name]
  • CSELECT [Name]
  • DSELECT [Name]

How the community answered

(41 responses)
  • A
    12% (5)
  • B
    10% (4)
  • C
    73% (30)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice