IT 207 Quiz 4 Structured Query Language, MySQL || 100%
accurate answers.
When accessing databases with PHP, you must use a data manipulation language. correct
answers True
The WHERE keyword specifies the conditions that must be met for records to be returned from a
query. correct answers True
The INSERT keyword determines the table into which records should be inserted. correct
answers False
Most database management systems use SQL to manipulate databases. correct answers True
You do not need to know how to write SQL commands manually to access MySQL databases
from PHP scripts. correct answers False
The PHP Extension and Application Representation (PEAR) is a committee that oversees the
open source PHP code. correct answers False
One of the most popular PEAR code modules is PEAR DB, which simplies access between PHP
and a database server. correct answers True
How you enable MySQL support in PHP depends on the version of PHP and how you installed
MySQL. correct answers False
The basic syntax for the mysqli_connect() function is: $connection = mysqli_connect("host"[,
"user", "password", "database"]) correct answers True
, The mysqli_connect() function returns a negative integer if it connects to the database
successfully or zero if it doesn't. correct answers False
The mysqli_close() function is used when you edit PHP with a MySQL program. correct answers
False
The syntax for the mysqli_select_db() function is mysqli_select_db(PHP commands). correct
answers False
The mysqli_connect() function returns a positive integer if it connects to the database
successfully or false if it doesn't. correct answers True
Writing code that anticipates and handles potential problems is often called code handling.
correct answers False
Another method of bulletproofing your code is to use the error control operator (@) to suppress
error messages. correct answers True
The error control operator (!!) suppresses error messages. correct answers False
The else clause also contains a nested for statement, which executes only if the
mysqli_select_dc() function successfully opens a database. correct answers False
To terminate script execution, use the kill() function. correct answers False
The mysqli_connect_errno() function returns no error messages for debugging purposes. correct
answers False
The mysqli_connect_error() function gives the user more information about the error that
occurred. correct answers True
accurate answers.
When accessing databases with PHP, you must use a data manipulation language. correct
answers True
The WHERE keyword specifies the conditions that must be met for records to be returned from a
query. correct answers True
The INSERT keyword determines the table into which records should be inserted. correct
answers False
Most database management systems use SQL to manipulate databases. correct answers True
You do not need to know how to write SQL commands manually to access MySQL databases
from PHP scripts. correct answers False
The PHP Extension and Application Representation (PEAR) is a committee that oversees the
open source PHP code. correct answers False
One of the most popular PEAR code modules is PEAR DB, which simplies access between PHP
and a database server. correct answers True
How you enable MySQL support in PHP depends on the version of PHP and how you installed
MySQL. correct answers False
The basic syntax for the mysqli_connect() function is: $connection = mysqli_connect("host"[,
"user", "password", "database"]) correct answers True
, The mysqli_connect() function returns a negative integer if it connects to the database
successfully or zero if it doesn't. correct answers False
The mysqli_close() function is used when you edit PHP with a MySQL program. correct answers
False
The syntax for the mysqli_select_db() function is mysqli_select_db(PHP commands). correct
answers False
The mysqli_connect() function returns a positive integer if it connects to the database
successfully or false if it doesn't. correct answers True
Writing code that anticipates and handles potential problems is often called code handling.
correct answers False
Another method of bulletproofing your code is to use the error control operator (@) to suppress
error messages. correct answers True
The error control operator (!!) suppresses error messages. correct answers False
The else clause also contains a nested for statement, which executes only if the
mysqli_select_dc() function successfully opens a database. correct answers False
To terminate script execution, use the kill() function. correct answers False
The mysqli_connect_errno() function returns no error messages for debugging purposes. correct
answers False
The mysqli_connect_error() function gives the user more information about the error that
occurred. correct answers True
