Php Databases Handling(Engineering > Computer Science And Engineering > Php ) Questions and answers for exam Preparation

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

MySQL
mysqly
mysql
mysqli

Explanation:-

Answer: Option D. -> mysqli

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

PHP 5.1
PHP 5.2
PHP 5.3
PHP 5.0

Explanation:-

Answer: Option C. -> PHP 5.3

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

CREATE table_name (column_type column_name);
CREATE TABLE table_name (column_name column_type);
CREATE table_name (column_name column_type);
CREATE TABLE table_name (column_type column_name);

Explanation:-

Answer: Option B. -> CREATE TABLE table_name (column_name column_type);

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

extension=mysql.dll
extension=php_mysqli.dl
extension=mysqli.dl
extension=php_mysqli.dll

Explanation:-

Answer: Option D. -> extension=php_mysqli.dll

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

MySQL
SQL+
SQL
Oracle Database

Explanation:-

Answer: Option A. -> MySQL

Question 6. Which one of the following statements instantiates the mysqli class?

mysqli = new mysqli()
$mysqli->new.mysqli()
mysqli->new.mysqli()
$mysqli = new mysqli()

Explanation:-

Answer: Option D. -> $mysqli = new mysqli()

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

0
FALSE
TRUE
Empty String

Explanation:-

Answer: Option D. -> Empty String

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

mysqli_connect_error()
mysqli_connect_errno()
connect_errno()
connect_error()

Explanation:-

Answer: Option B. -> mysqli_connect_errno()

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

$mysqli=select_db(‘databasename’);
mysqli=select_db(‘databasename’);
$mysqli->select_db(‘databasename’);
mysqli->select_db(‘databasename’);

Explanation:-

Answer: Option C. -> $mysqli->select_db(‘databasename’);

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

errorno()
errnumber()
errno()
errornumber()

Explanation:-

Answer: Option C. -> errno()