Home / CSE / PHP - CS :: Databases Handling

CSE :: PHP - CS

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

  2. A.

     #include ‘filename’;

    B.

     include ‘filename’;

    C.

     @include ‘filename’;

    D.

     #include ;

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  • A.

     query()

    B.

     send_query()

    C.

     sendquery()

    D.

     query_send()

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  • A.

     destroy()

    B.

     remover()

    C.

     alloc()

    D.

     free()

    View Answer

    Workspace

    Discuss Discuss in Forum


  • 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()

    View Answer

    Workspace

    Discuss Discuss in Forum


  • 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()

    View Answer

    Workspace

    Discuss Discuss in Forum


  • Which version of MySQL introduced the prepared statements?

  • A.

     MySQL 4.0

    B.

     MySQL 4.1

    C.

     MySQL 4.2

    D.

     MySQL 4.3

    View Answer

    Workspace

    Discuss Discuss in Forum


  • 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()

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  • A.

     end()

    B.

     finish()

    C.

     final()

    D.

     close()

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  • A.

     get_row()

    B.

     fetch_row()

    C.

     fetch()

    D.

     row()

    View Answer

    Workspace

    Discuss Discuss in Forum


  • Which method rolls back the present transaction?

  • A.

     commit()

    B.

     undo()

    C.

     back()

    D.

     rollback()

    View Answer

    Workspace

    Discuss Discuss in Forum