Sail E0 Webinar

MCQs

Total Questions : 39 | Page 1 of 4 pages
Question 1. Which one of the following databases has PHP supported almost since the beginning?
  1.    Oracle Database
  2.    SQL
  3.    SQL+
  4.    MySQL
 Discuss Question
Answer: Option D. -> MySQL
Question 2. The updated MySQL extension released with PHP 5 is typically referred to as.
  1.    MySQL
  2.    mysql
  3.    mysqli
  4.    mysqly
 Discuss Question
Answer: Option C. -> mysqli
Question 3. Which one of the following lines need to be uncommented or added in the php.ini file so as to enable mysqli extension?
  1.    extension=php_mysqli.dll
  2.    extension=mysql.dll
  3.    extension=php_mysqli.dl
  4.    extension=mysqli.dl
 Discuss Question
Answer: Option A. -> extension=php_mysqli.dll
Question 4. In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?
  1.    PHP 5.0
  2.    PHP 5.1
  3.    PHP 5.2
  4.    PHP 5.3
 Discuss Question
Answer: Option D. -> PHP 5.3
Question 5. Which one of the following statements is used to create a table?
  1.    CREATE TABLE table_name (column_name column_type);
  2.    CREATE table_name (column_type column_name);
  3.    CREATE table_name (column_name column_type);
  4.    CREATE TABLE table_name (column_type column_name);
 Discuss Question
Answer: Option A. -> CREATE TABLE table_name (column_name column_type);
Question 6. Which one of the following statements instantiates the mysqli class?
  1.    mysqli = new mysqli()
  2.    $mysqli = new mysqli()
  3.    $mysqli->new.mysqli()
  4.    mysqli->new.mysqli()
 Discuss Question
Answer: Option B. -> $mysqli = new mysqli()
Question 7. Which one of the following statements can be used to select the database?
  1.    $mysqli=select_db(‘databasename’);
  2.    mysqli=select_db(‘databasename’);
  3.    mysqli->select_db(‘databasename’);
  4.    $mysqli->select_db(‘databasename’);
 Discuss Question
Answer: Option D. -> $mysqli->select_db(‘databasename’);
Question 8. Which one of the following methods can be used to diagnose and display information about a MySQL connection error?
  1.    connect_errno()
  2.    connect_error()
  3.    mysqli_connect_errno()
  4.    mysqli_connect_error()
 Discuss Question
Answer: Option C. -> mysqli_connect_errno()
Question 9. Which method returns the error code generated from the execution of the last MySQL function?
  1.    errno()
  2.    errnumber()
  3.    errorno()
  4.    errornumber()
 Discuss Question
Answer: Option A. -> errno()
Question 10. If there is no error, then what will the error() method return?
  1.    TRUE
  2.    FALSE
  3.    Empty String
  4.    0
 Discuss Question
Answer: Option C. -> Empty String

Latest Videos

Latest Test Papers