Working with Databases-2 MCQ

Test your knowledge with important Working with Databases-2 MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Working with Databases-2 MCQs on Bissoy. Bissoy App

• Which method rolls back the present transaction?
  ক

  commit()

  খ

  undo()

  গ

  mysqli_rollback()

  ঘ

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

  get_row()

  খ

  fetch_row()

  গ

  fetch()

  ঘ

  mysqli_fetch_row()
• Which one of the following methods is used to recuperating prepared statements resources?
  ক

  end()

  খ

  finish()

  গ

  mysqli_close()

  ঘ

  close()
• Which of the following methods is used to execute the statement after the parameters have been bound?
  ক

  bind_param()

  খ

  bind_result()

  গ

  bound_param()

  ঘ

  bound_result()
• Which version of MySQL introduced the prepared statements?
  ক

  MySQL 4.0

  খ

  MySQL 4.1

  গ

  MySQL 4.2

  ঘ

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

  num_rows()

  খ

  affected_rows()

  গ

  changed_rows()

  ঘ

  mysqli_affected_rows()
• Which of the methods are used to manage result sets using both associative and indexed arrays?
  ক

  get_array() and get_row()

  খ

  get_array() and get_column()

  গ

  fetch_array() and fetch_row()

  ঘ

  mysqli_fetch_array() and mysqli_fetch_row()
• Which one of the following methods recuperates any memory consumed by a result set?
  ক

  destroy()

  খ

  mysqli_free_result()

  গ

  alloc()

  ঘ

  free()
• Which one of the following methods is responsible for sending the query to the database?
  ক

  query()

  খ

  send_query()

  গ

  sendquery()

  ঘ

  mysqli_query()
• Which one of the following statements should be used to include a file?
  ক

  #include ‘filename’;

  খ

  include ‘filename’;

  গ

  @include ‘filename’;

  ঘ

  #include <filename>;