Sail E0 Webinar

MCQs

Total Questions : 39 | Page 2 of 4 pages
Question 11. Which one of the following statements should be used to include a file?
  1.    #include ‘filename’;
  2.    include ‘filename’;
  3.    @include ‘filename’;
  4.    #include ;
 Discuss Question
Answer: Option B. -> include ‘filename’;
Question 12. Which one of the following methods is responsible for sending the query to the database?
  1.    query()
  2.    send_query()
  3.    sendquery()
  4.    query_send()
 Discuss Question
Answer: Option A. -> query()
Question 13. Which one of the following methods recuperates any memory consumed by a result set?
  1.    destroy()
  2.    remover()
  3.    alloc()
  4.    free()
 Discuss Question
Answer: Option D. -> free()
Question 14. Which of the methods are used to manage result sets using both associative and indexed arrays?
  1.    get_array() and get_row()
  2.    get_array() and get_column()
  3.    fetch_array() and fetch_row()
  4.    fetch_array() and fetch_column()
 Discuss Question
Answer: Option C. -> fetch_array() and fetch_row()
Question 15. Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?
  1.    num_rows()
  2.    affected_rows()
  3.    changed_rows()
  4.    new_rows()
 Discuss Question
Answer: Option B. -> affected_rows()
Question 16. Which version of MySQL introduced the prepared statements?
  1.    MySQL 4.0
  2.    MySQL 4.1
  3.    MySQL 4.2
  4.    MySQL 4.3
 Discuss Question
Answer: Option B. -> MySQL 4.1
Question 17. Which of the following methods is used to execute the statement after the parameters have been bound?
  1.    bind_param()
  2.    bind_result()
  3.    bound_param()
  4.    bound_result()
 Discuss Question
Answer: Option A. -> bind_param()
Question 18. Which one of the following methods is used to recuperating prepared statements resources?
  1.    end()
  2.    finish()
  3.    final()
  4.    close()
 Discuss Question
Answer: Option D. -> close()
Question 19. Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?
  1.    get_row()
  2.    fetch_row()
  3.    fetch()
  4.    row()
 Discuss Question
Answer: Option C. -> fetch()
Question 20. Which method rolls back the present transaction?
  1.    commit()
  2.    undo()
  3.    back()
  4.    rollback()
 Discuss Question
Answer: Option D. -> rollback()

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0