PHP Database Connection

1.		Which of the following functions is used to retrieve the error message associated with the most recent database operation in PHP?

mysql_error()

mysqli_error()

pdo_error()

None of the above

2.		Which of the following functions is used to select a database in PHP?

my_sqli_select_db()

mysql_select_db()

pdo_select_db()

mysqli_select_db()

3.		Which of the following functions is used to retrieve the current character set for the database connection in PHP?

mysqli_character_set_name()

mysql_character_set_name()

pdo_character_set_name()

None of the above

4.		Which of the following functions is used to free up memory associated with a result set in PHP?

pdo_free_result()

mysql_free_result()

mysqli_free_result()

None of the above

5.		Which of the following functions is used to set the character set for the database connection in PHP?

pdo_set_charset()

mysql_set_charset()

mysqli_set_charset()

None of the above

6.		What is the function used to establish a connection to a MySQL database in PHP?

my_sqli_connect()

mysql_connect()

pdo_connect()

mysqli_connect()

7.		Which of the following functions is used to check if a database connection is still active in PHP?

mysql_ping()

mysqli_ping()

pdo_ping()

None of the above

8.		Which of the following functions is used to close a database connection in PHP?

mysqli_close()

mysql_close()

pdo_close()

None of the above

9.		Which of the following functions is used to return the number of rows in a result set in PHP?

mysqli_num_rows()

mysql_num_rows()

pdo_num_rows()

None of the above

10.		Which of the following functions is used to retrieve information about the most recent query performed on the database connection in PHP?

mysqli_info()

mysql_info()

pdo_info()

None of the above