Question 1

A result pointer is a special type of ____ that refers to the currently selected row in a resultset.

Accepted Answer

A result pointer is a variable that holds the memory address of the currently selected row in a resultset. It is used by database programming languages like SQL and is essential for navigating and manipulating data in a resultset. Options, functions, and commands do not refer to result pointers.

Question 2

The mysql_connect() function returns a ____________________ as an integer if it connects successfully to a database or a Boolean FALSE if it doesn't.

Accepted Answer

The answer of The mysql_connect() function returns a ____________________ as...

Question 3

Use the ___ function to return the number of fields in a query result.

Accepted Answer

The correct function to use in order to return the number of fields in a query result is mysql_num_fields(). This function takes a parameter representing the result set from the query and returns the number of fields in that result set. The other options provided (mysql_return_fields(), mysql_count_fields(), and mysql_field_results()) are not valid MySQL functions.

Question 4

When a query modifies a table but does not return a result, you use the ___ function to determine how many rows/records were affected.

Accepted Answer

The function to determine how many rows/records were affected after modifying a table is mysql_affected_rows(). The other options (A, C, D) are not valid functions in MySQL.

Question 5

The mysql_info() function only returns query information when you add ___ records with the INSERT keyword.

Accepted Answer

The mysql_info() function returns query information only when more than one record is added with the INSERT keyword.

Question 6

To change records in a table, use the UPDATE keyword to specify the name of the table to update and the ___ keyword to specify the value to assign to the fields in the records that match the condition in the WHERE keyword.

Accepted Answer

The keyword to use to specify the value to assign to the fields in the records is SET. Therefore, the correct choice is D. A - CHANGE is not a keyword used to update records in SQL. B - INSERT is used to insert new records, not change existing ones. C - PUT is not a keyword used in SQL for modifying records.

Question 7

With an INSERT query, the ___ function returns the number of records added and duplicated along with the number of warnings.

Accepted Answer

The mysql_info() function returns information about the most recently executed query, including the number of records inserted or affected by the query, the number of warnings generated, and any messages generated by triggers. It does not return information about duplicate records.

Question 8

The mysqli (____________________) package became available with PHP 5 and is designed to work with MySQL version 4.1.3 and above.

Accepted Answer

The answer of The mysqli (____________________) package became available with...

Question 9

Although they perform similar functions, PEAR DB is designed specifically to work with PHP and ____________________ is a more generic protocol used by many programming languages and database management systems.

Accepted Answer

The answer of Although they perform similar functions, PEAR DB...

Question 10

The ___ keyword is often used with the primary key to generate a unique id for each new row in a table.

Accepted Answer

The AUTO_INCREMENT keyword is used with the primary key to generate a unique id for each new row in a table. This ensures that each row has a unique identifier and makes it easier to identify individual records in the database.

Question 11

To add multiple records to a database from an external file, you use the ____ statement with the name of the local text file that contains the records you want to add.

Accepted Answer

The correct statement to use is LOAD DATA, followed by the keyword INFILE and the name of the local text file containing the records to be added. This is a commonly used method for bulk importing data into a database. INSERT DATA and INSERT RECORDS are not valid SQL statements, and UPLOAD RECORDS is not a standardized command.

Question 12

To close the resultset, use ____.

Accepted Answer

mysql_free_result() is used to free up the memory used by the result set. This function should be used to close the result set after it has been completely processed or if it is no longer needed, to avoid memory leaks. The other options (A, B, and C) are not used for closing result sets.

Question 13

The ___ keyword, often used with the primary key, requires that the field include a value.

Accepted Answer

The NOT NULL keyword is used to specify that a column must contain a value and cannot be left blank or empty.

Question 14

PEAR stands for ________________________________________.

Accepted Answer

The answer of PEAR stands for ________________________________________....

Question 15

When ,mysql_query() returns a resultset, you use the ____ function to determine the number of records in the resultset.

Accepted Answer

When mysql_query() returns a resultset, mysql_num_rows() function is used to determine the number of records in the resultset. This function returns the number of rows in the resultset, which can then be used to loop through and fetch each row using functions like mysql_fetch_assoc() or mysql_fetch_array(). The other options presented are not valid functions for determining the number of records in a resultset.

Question 16

The function ____ returns the fields in the current row of a resultset into an associative array and moves the result pointer to the next row.

Accepted Answer

mysql_fetch_assoc() returns the fields in the current row of a resultset into an associative array and moves the result pointer to the next row. The other options (mysql_fetch_lengths(), mysql_fetch_rows(), mysql_fetch_array()) have different functionality or do not exist in the MySQLi extension.

Question 17

The function ____ returns the fields in the current row into an indexed array.

Accepted Answer

The function mysql_fetch_row() returns the fields in the current row into an indexed array.

Question 18

The list of records that is returned from a mysql_query() is a called a ____.

Accepted Answer

The term commonly used in MySQL for the list of records returned from a query is "resultset". Therefore, the best choice is B, "resultset".

Question 19

The ____ command with a mysql_query() function executes successfully if the table already exists.

Accepted Answer

The SHOW TABLES LIKE command with a mysql_query() function can be used to check if a table already exists in the database. It will return a result set with a list of tables that match the specified pattern. If the table we are checking for is included in the result set, then we know that the table already exists in the database.

Question 20

To delete records in a table, use the keywords ____.

Accepted Answer

The correct keywords to use when deleting records in a table are "DELETE" and "WHERE". The "WHERE" keyword is used to specify the condition or criteria that determine which records will be deleted. The other options are not valid keywords for deleting records in SQL.

Quiz 8: Manipulating Mysql Databases With Php