1Z0-909 practice question 12 of 15
You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?
Full set: 65 questionsIn MySQLi the default behaviour of mysqliquery() is MYSQLISTORERESULT, which is a buffered-result mode. Buffered mode moves the complete result set from the MySQL server to the client (the PHP process) and stores it in the client’s memory; nothing is sent directly to the browser. Because the entire set is copied, very large results increase network traffic and can consume large amounts of PHP memory, degrading performance.
A. Blocking the next statement until the current result is released applies to unbuffered mode (mysqliuseresult), not to the default buffered mode.
B. Data are transferred to the PHP client, not to the browser.
D. For an unknown or very large result, unbuffered mode is recommended to avoid high memory use; buffered mode is not “should” in this case.
F. mysqliuseresult() activates UNbuffered mode; buffered mode needs no explicit call.
1. PHP Manual – “mysqli quickstart: buffered result sets”, § Introduction, para 1-2 (php.net/manual/en/mysqli.quickstart.buffered.php)
2. PHP Manual – “mysqliuseresult”, Remarks, para 1-2 (php.net/manual/en/mysqli.use-result.php)
3. MySQL 8.0 Reference Manual – “C API Example Programs / mysqlstoreresult()”, § 23.8.6.10, para 1-3 (Oracle, 2023)
4. MySQL 8.0 Reference Manual – “Buffering Results”, § 23.8.5, para 1 (Oracle, 2023)
Keep practicing
Take the free 1Z0-909 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-909 practice questions
- Question 3Examine these commands which execute successfully: mYsql> CREATE TABLE income (acct_num I…
- Question 4Examine this statement which executes successfully: CREATE TABLE 'fshop’ ('product' JSON …
- Question 5Which two statements are true about aggregate functions?
- Question 6Examine this statement and output: CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(…
