Vidyalelo
PHP · all questions

Databases Handling
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

39

Questions

1/2

Page

Pick an option on a question to see the right answer and solution.

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

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Which one of the following statements instantiates the mysqli class?

Select an option to see the answer and solution.

Which one of the following statements can be used to select the database?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Which method returns the error code generated from the execution of the last MySQL function?

Select an option to see the answer and solution.

If there is no error, then what will the error() method return?

Select an option to see the answer and solution.

Which one of the following statements should be used to include a file?

Select an option to see the answer and solution.

Which one of the following methods is responsible for sending the query to the database?

Select an option to see the answer and solution.

Which one of the following methods recuperates any memory consumed by a result set?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Which version of MySQL introduced the prepared statements?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?

Select an option to see the answer and solution.

Which method rolls back the present transaction?

Select an option to see the answer and solution.