Databases Handling MCQ question and answer with solution

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

A. #include ‘filename’;

B. include ‘filename’;

C. @include ‘filename’;

D. #include ;

Answer & Solution Discuss in Board Save for Later

12.
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()

Answer & Solution Discuss in Board Save for Later

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

A. destroy()

B. remover()

C. alloc()

D. free()

Answer & Solution Discuss in Board Save for Later

14.
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()

Answer & Solution Discuss in Board Save for Later

15.
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()

Answer & Solution Discuss in Board Save for Later

16.
Which version of MySQL introduced the prepared statements?

A. MySQL 4.0

B. MySQL 4.1

C. MySQL 4.2

D. MySQL 4.3

Answer & Solution Discuss in Board Save for Later

17.
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()

Answer & Solution Discuss in Board Save for Later

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

A. end()

B. finish()

C. final()

D. close()

Answer & Solution Discuss in Board Save for Later

19.
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()

Answer & Solution Discuss in Board Save for Later

20.
Which method rolls back the present transaction?

A. commit()

B. undo()

C. back()

D. rollback()

Answer & Solution Discuss in Board Save for Later

Databases Handling MCQ question and answer with solution | PHP Programming

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

14. Which of the methods are used to manage result sets using both associative and indexed arrays?

Answer & Solution

15. Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

Answer & Solution

16. Which version of MySQL introduced the prepared statements?

Answer & Solution

17. Which of the following methods is used to execute the statement after the parameters have been bound?

Answer & Solution

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

Answer & Solution

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

Answer & Solution

20. Which method rolls back the present transaction?

Answer & Solution

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

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

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

14.
Which of the methods are used to manage result sets using both associative and indexed arrays?

15.
Which one of the following method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

16.
Which version of MySQL introduced the prepared statements?

17.
Which of the following methods is used to execute the statement after the parameters have been bound?

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

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

20.
Which method rolls back the present transaction?