Multiple choice technology web technology

Which of the following are valid statements to obtain the number of row returned by a sql query (It could be from any DBMS)

  1. pg_numrows($result)

  2. postregSQL_numRows($result)

  3. mysql_num_rows($result)

  4. ora_num_rows
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

pg_numrows() is the PostgreSQL function to get the number of rows in a result set. mysql_num_rows() is the MySQL equivalent. Options B and D are incorrect function names - postregSQL_numRows has a typo and ora_num_rows is not the correct Oracle function name.

Keep practicing — related questions