Home / CSE / PHP - CS :: Databases Handling

CSE :: PHP - CS

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

  2. A.

     Oracle Database

    B.

     SQL

    C.

     SQL+

    D.

     MySQL

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  4. A.

     MySQL

    B.

     mysql

    C.

     mysqli

    D.

     mysqly

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  6. A.

     extension=php_mysqli.dll

    B.

     extension=mysql.dll

    C.

     extension=php_mysqli.dl

    D.

     extension=mysqli.dl

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  8. A.

     PHP 5.0

    B.

     PHP 5.1

    C.

     PHP 5.2

    D.

     PHP 5.3

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  10. 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);

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which one of the following statements instantiates the mysqli class?

  12. A.

     mysqli = new mysqli()

    B.

     $mysqli = new mysqli()

    C.

     $mysqli->new.mysqli()

    D.

     mysqli->new.mysqli()

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  14. A.

     $mysqli=select_db(‘databasename’);

    B.

     mysqli=select_db(‘databasename’);

    C.

     mysqli->select_db(‘databasename’);

    D.

     $mysqli->select_db(‘databasename’);

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  16. A.

     connect_errno()

    B.

     connect_error()

    C.

     mysqli_connect_errno()

    D.

     mysqli_connect_error()

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  18. A.

     errno()

    B.

     errnumber()

    C.

     errorno()

    D.

     errornumber()

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  20. A.

     TRUE

    B.

     FALSE

    C.

     Empty String

    D.

     0

    View Answer

    Workspace

    Discuss Discuss in Forum