Question 1

You can suppress error message by using the error control operator (%).

Accepted Answer

A) True 
 B)False

Question 2

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 3

The mysql_query() function returns a result pointer that represents the query results when the SELECT or SHOW statement which returns a resultset.

Accepted Answer

A) True 
 B)False

Question 4

When you add records to a table that includes an AUTO_INCREMENT field, you omit the column name and value from the lists.

Accepted Answer

A) True 
 B)False

Question 5

With queries that return results, such as SELECT queries, you can use the mysql_num_rows() function to find the number of records returned from a query.

Accepted Answer

A) True 
 B)False

Question 6

How you enable MySQL support in PHP depends on the version of PHP and how you installed MySQL.

Accepted Answer

A) True 
 B)False

Question 7

The mysql_errno() function returns the ____________________ code of an error.

Accepted Answer

The answer of The mysql_errno() function returns the ____________________ code...

Question 8

To return information about the MySQL database server version, use the ____ function.

Accepted Answer

A)  mysql_get_client_info() 
B)  mysql_host_info(connection) 
C)  mysql_get_proto_info(connection) 
D)  mysql_get_server_info(connection) 
A)  mysql_get_client_info() 
B)  mysql_host_info(connection) 
C)  mysql_get_proto_info(connection) 
D)  mysql_get_server_info(connection)

Question 9

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

A)  mysql_rows_affected() 
B)  mysql_affected_rows() 
C)  mysql_affected_records() 
D)  mysql_records_affected() 
A)  mysql_rows_affected() 
B)  mysql_affected_rows() 
C)  mysql_affected_records() 
D)  mysql_records_affected()

Question 10

You can use the mysql_select_db() function to select a database or change to a different database.

Accepted Answer

A) True 
 B)False

Question 11

To delete a database, you use the ____________________ function.

Accepted Answer

The answer of To delete a database, you use the...

Question 12

The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.

Accepted Answer

A) True 
 B)False

Question 13

Use the _________________________ function to determine the number of rows affected by an INSERT statement.

Accepted Answer

mysql_affe

Question 14

You use the mysql_num_fields() function to return the number of _______________ in a query result.

Accepted Answer

The answer of You use the mysql_num_fields() function to return...

Question 15

In PHP, use the mysql_query() function to send SQL statements to ____________________.

Accepted Answer

The answer of In PHP, use the mysql_query() function to...

Question 16

To open a connection to a MySQL database server, use ____.

Accepted Answer

A)  mysql_connect() 
B)  open_connect() 
C)  connection_mysql() 
D)  open_mysql() 
A)  mysql_connect() 
B)  open_connect() 
C)  connection_mysql() 
D)  open_mysql()

Question 17

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

Accepted Answer

A)  mysql_result_rows() 
B)  mysql_num_result() 
C)  mysql_num_rows() 
D)  mysql_num_records() 
A)  mysql_result_rows() 
B)  mysql_num_result() 
C)  mysql_num_rows() 
D)  mysql_num_records()

Question 18

The query pointer is a way of keeping track of where you are in a resultset.

Accepted Answer

A) True 
 B)False

Question 19

With queries that modify tables, but do not return results, such as INSERT, UPDATE, and DELETE queries, you use the mysql_modified_rows() function to determine the number of changed rows.

Accepted Answer

A) True 
 B)False

Question 20

The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.

Accepted Answer

A) True 
 B)False

You can suppress error message by using the error control operator (%).

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

The mysql_query() function returns a result pointer that represents the query results when the SELECT or SHOW statement which returns a resultset.

When you add records to a table that includes an AUTO_INCREMENT field, you omit the column name and value from the lists.

With queries that return results, such as SELECT queries, you can use the mysql_num_rows() function to find the number of records returned from a query.

How you enable MySQL support in PHP depends on the version of PHP and how you installed MySQL.

The mysql_errno() function returns the ____________________ code of an error.

To return information about the MySQL database server version, use the ____ function.

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

You can use the mysql_select_db() function to select a database or change to a different database.

To delete a database, you use the ____________________ function.

The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.

Use the _________________________ function to determine the number of rows affected by an INSERT statement.

You use the mysql_num_fields() function to return the number of _______________ in a query result.

In PHP, use the mysql_query() function to send SQL statements to ____________________.

To open a connection to a MySQL database server, use ____.

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

The query pointer is a way of keeping track of where you are in a resultset.

With queries that modify tables, but do not return results, such as INSERT, UPDATE, and DELETE queries, you use the mysql_modified_rows() function to determine the number of changed rows.

The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.

Getting Started With Php

Functions and Control Structures

Manipulating Strings

Handling User Input

Working With Files and Directories

Manipulating Arrays

Working With Databases and Mysql

Managing State Information

Developing Object-Oriented Php

Filters

Exam 8: Manipulating Mysql Databases With Php

You can suppress error message by using the error control operator (%).

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

The mysql_query() function returns a result pointer that represents the query results when the SELECT or SHOW statement which returns a resultset.

When you add records to a table that includes an AUTO_INCREMENT field, you omit the column name and value from the lists.

With queries that return results, such as SELECT queries, you can use the mysql_num_rows() function to find the number of records returned from a query.

How you enable MySQL support in PHP depends on the version of PHP and how you installed MySQL.

The mysql_errno() function returns the ____________________ code of an error.

To return information about the MySQL database server version, use the ____ function.

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

You can use the mysql_select_db() function to select a database or change to a different database.

To delete a database, you use the ____________________ function.

The PRIMARY KEY keywords are used to generate a unique id for each new row in a table.

Use the _________________________ function to determine the number of rows affected by an INSERT statement.

You use the mysql_num_fields() function to return the number of _______________ in a query result.

In PHP, use the mysql_query() function to send SQL statements to ____________________.

To open a connection to a MySQL database server, use ____.

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

The query pointer is a way of keeping track of where you are in a resultset.

With queries that modify tables, but do not return results, such as INSERT, UPDATE, and DELETE queries, you use the mysql_modified_rows() function to determine the number of changed rows.

The PHP Extension and Application Representation (PEAR) is a committee that oversees the open source PHP code.

Getting Started With Php

Functions and Control Structures

Manipulating Strings

Handling User Input

Working With Files and Directories

Manipulating Arrays

Working With Databases and Mysql

Managing State Information

Developing Object-Oriented Php

Filters