MySql with PHP Basic MCQ - Quiz

Q: The updated MySQL extension released with PHP 5 is typically referred to as..

A. MySQL
B. mysql
C. mysqli
D. mysqly

Correct Option: C
Explanation: The updated MySQL extension with PHP 5 is known as MySQL and typically referred to as mysqli.

Q: Which one of the following methods can be used to diagnose and display information about a MySQL connection error?

A. connect_errno()
B. connect_error()
C. mysqli_connect_errno()
D. mysqli_connect_error()

Correct Option: C
Explanation: The mysqli extension includes a few features that can be used to capture error messages or alternatively you can use exceptions.

Q: Which one of the following methods is used to recuperating prepared statements resources?

A. end()
B. finish()
C. final()
D. close()

Correct Option: D
Explanation: Once you’ve finished using a prepared statement, the resources it requires can be recuperated with the close() method.

Q: Which of the methods are used to manage result sets using both associative and indexed arrays?

A. get_array() and get_row()
B. get_array() and get_column()
C. fetch_array() and fetch_row()
D. fetch_array() and fetch_column()

Correct Option: C
Explanation:

Their prototype is as follows-

calss mysqli_result{

mixed fetch_array ([int resulttype])

}

calss mysqli_result{

mixed fetch_row()

}

Q: Which version of MySQL introduced the prepared statements?

A. MySQL 4.0
B. MySQL 4.1
C. MySQL 4.2
D. MySQL 4.3

Correct Option: B
Explanation: When the query() method is looped repeatedly it comes at a cost of both overhead, because of the need to repeatedly parsing of the almost identical query for validity, and coding convenience, because of the need to repeatedly reconfigure the query using the new values for each iteration. To help resolve the issues incurred by repeatedly executed queries, MySQL introduced prepared statements.

Q: In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?

A. PHP 5.0
B. PHP 5.1
C. PHP 5.2
D. PHP 5.3

Correct Option: D
Explanation: PHP required that MySQL client library be installed on the server from which PHP was communicating with MySQL, whether the MySQL server also happened to reside locally or elsewhere. PHP 5.3 removes this problem by introducing MySQL Native Driver.

Q: Which of the following methods is used to execute the statement after the parameters have been bound?

A. bind_param()
B. bind_result()
C. bound_param()
D. bound_result()

Correct Option: A
Explanation: Once the statement has been prepared, it needs to be executed. Exactly when it’s executed depends upon whether you want to work with bound parameters or bound results. In the case of bound parameters, you’d execute the statement after the parameters have been bound with the bind_param() method.

Q: Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

A. num_rows()
B. affected_rows()
C. changed_rows()
D. new_rows()

Correct Option: B
Explanation:

The method num_rows() is only useful for determining the number of rows retrieved by a SELECT query. But to retrieve the number of rows affected by INSERT, UPDATE, or DELETE query, use affected_rows().

Q: Which one of the following databases has PHP supported almost since the beginning?

A. Oracle Database
B. SQL
C. SQL+
D. MySQL

Correct Option: D
Explanation: MySQL

Q: Which one of the following statements is used to create a table?

A. CREATE TABLE table_name (column_name column_type);
B. CREATE table_name (column_type column_name);
C. CREATE table_name (column_name column_type);
D. CREATE TABLE table_name (column_type column_name);

Correct Option: A
Explanation: CREATE TABLE table_name (column_name column_type);