PHP Database Connection

1.		Which of the following functions is used to begin a transaction in PHP?

mysqli_begin()

mysql_begin()

pdo_begin()

None of the above

2.		Which of the following functions is used to fetch a row as an object from a result set in PHP?

mysqli_get_object()

mysql_fetch_object()

pdo_fetch_object()

mysqli_fetch_object()

3.		the following functions is used to escape special characters in a string for use in an SQL statement in PHP?

mysqli_real_escape_string()

mysql_real_escape_string()

pdo_real_escape_string()

None of the above

4.		Which of the following is the correct syntax to connect to a MySQL database in PHP?

$conn = mysqli_connect("localhost", "username", "password", "database_name");

$conn = mysql_connect("localhost", "username", "password", "database_name");

$conn = pdo_connect("localhost", "username", "password", "database_name");

None of the above

5.		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

6.		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

7.		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()

8.		Which of the following functions is used to commit a transaction in PHP?

mysqli_commit()

mysql_commit()

pdo_commit()

None of the above

9.		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

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

mysqli_close()

mysql_close()

pdo_close()

None of the above