nerdexam
Oracle

1Z0-882 · Question #29

The friends table has the columns and contents as shown: Mysql> SELECT * FROM friends; This statement was executed: SELECT AVG (age) FROM friends What value is returned?

The correct answer is C. 20. See the full explanation below for the reasoning.

Question

The friends table has the columns and contents as shown:

Mysql> SELECT * FROM friends; This statement was executed:

SELECT AVG (age) FROM friends What value is returned?

Exhibit

1Z0-882 question #29 exhibit

Options

  • ANULL
  • B10
  • C20
  • D0

How the community answered

(62 responses)
  • A
    11% (7)
  • B
    3% (2)
  • C
    81% (50)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice