nerdexam
PostgreSQL_CE

PGCES-02 · Question #90

The "sample" table consists of the following data: SELECT * FROM sample WHERE v ~ 'ab'; How many rows are returned by executing the following SQL statement?

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

Question

The "sample" table consists of the following data:

SELECT * FROM sample WHERE v ~ 'ab'; How many rows are returned by executing the following SQL statement?

Options

  • A0 rows
  • B1 row
  • C2 rows
  • D3 rows
  • E4 rows

How the community answered

(55 responses)
  • A
    2% (1)
  • B
    7% (4)
  • C
    84% (46)
  • D
    2% (1)
  • E
    5% (3)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice