Question 1

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

Accepted Answer

A)  mysql_update_info() 
B)  mysql_info() 
C)  mysql_update() 
D)  mysql_info_update() 
A)  mysql_update_info() 
B)  mysql_info() 
C)  mysql_update() 
D)  mysql_info_update()

Question 2

When adding a record to a table, you can specify ____________________ in any fields for which you do not have a value.

Accepted Answer

The answer of When adding a record to a table,...

Question 3

You pass the mysql_close() function the database ____________________ variable to close the database.

Accepted Answer

The answer of You pass the mysql_close() function the database...

Question 4

To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function.

Accepted Answer

A) True 
 B)False

Question 5

If you are connecting to an instance of the MySQL database server that is running on the same server as the PHP scripting engine, use a value of ____________________ or "127.0.0.1" for the host argument.

Accepted Answer

The answer of If you are connecting to an instance...

Question 6

The error control operator disables error checking.

Accepted Answer

A) True 
 B)False

Question 7

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

A)  INSERT DATA 
B)  LOAD DATA 
C)  INSERT RECORDS 
D)  UPLOAD RECORDS 
A)  INSERT DATA 
B)  LOAD DATA 
C)  INSERT RECORDS 
D)  UPLOAD RECORDS

Question 8

To create a table, use the ____________________ statement with the mysql_query() function.

Accepted Answer

The answer of To create a table, use the ____________________...

Question 9

To delete all the records in a table, you use the DELETE statement but omit the ____________________ keyword.

Accepted Answer

The answer of To delete all the records in a...

Question 10

The mysqli package is the object-oriented equivalent of the mysql package.

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ function returns the number of rows in a query result.

Accepted Answer

The answer of The ____________________ function returns the number of...

Question 12

The mysql_close() function is used to explicitly close a database connection.

Accepted Answer

A) True 
 B)False

Question 13

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

A)  CHANGE 
B)  INSERT 
C)  PUT 
D)  SET 
A)  CHANGE 
B)  INSERT 
C)  PUT 
D)  SET

Question 14

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

Accepted Answer

A)  DELETE, RECORD 
B)  DELETE, WHERE 
C)  REMOVE, WHERE 
D)  REMOVE, RECORD 
A)  DELETE, RECORD 
B)  DELETE, WHERE 
C)  REMOVE, WHERE 
D)  REMOVE, RECORD

Question 15

The NOT NULL keywords are often used with primary keys to require that a field include a value.

Accepted Answer

A) True 
 B)False

Question 16

The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn't.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  SHOW EXISTING TABLE 
B)  SHOW MATCHING TABLE 
C)  SHOW SAME TABLE 
D)  SHOW TABLES LIKE 
A)  SHOW EXISTING TABLE 
B)  SHOW MATCHING TABLE 
C)  SHOW SAME TABLE 
D)  SHOW TABLES LIKE

Question 18

PEAR stands for ________________________________________.

Accepted Answer

PHP Extens

Question 19

A list of records that are returned from a query is called a resultset.

Accepted Answer

A) True 
 B)False

Question 20

The ___ function returns a text string describing the error in PHP code.

Accepted Answer

A)  mysql_error() 
B)  mysql_errno() 
C)  mysql_err() 
D)  mysql_error_number() 
A)  mysql_error() 
B)  mysql_errno() 
C)  mysql_err() 
D)  mysql_error_number()

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

When adding a record to a table, you can specify ____________________ in any fields for which you do not have a value.

You pass the mysql_close() function the database ____________________ variable to close the database.

To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function.

If you are connecting to an instance of the MySQL database server that is running on the same server as the PHP scripting engine, use a value of ____________________ or "127.0.0.1" for the host argument.

The error control operator disables error checking.

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.

To create a table, use the ____________________ statement with the mysql_query() function.

To delete all the records in a table, you use the DELETE statement but omit the ____________________ keyword.

The mysqli package is the object-oriented equivalent of the mysql package.

The ____________________ function returns the number of rows in a query result.

The mysql_close() function is used to explicitly close a database connection.

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.

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

The NOT NULL keywords are often used with primary keys to require that a field include a value.

The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn't.

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

PEAR stands for ________________________________________.

A list of records that are returned from a query is called a resultset.

The ___ function returns a text string describing the error in 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

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

When adding a record to a table, you can specify ____________________ in any fields for which you do not have a value.

You pass the mysql_close() function the database ____________________ variable to close the database.

To delete records in a table, use the DELETE and WHERE keywords with the mysql_query() function.

If you are connecting to an instance of the MySQL database server that is running on the same server as the PHP scripting engine, use a value of ____________________ or "127.0.0.1" for the host argument.

The error control operator disables error checking.

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.

To create a table, use the ____________________ statement with the mysql_query() function.

To delete all the records in a table, you use the DELETE statement but omit the ____________________ keyword.

The mysqli package is the object-oriented equivalent of the mysql package.

The ____________________ function returns the number of rows in a query result.

The mysql_close() function is used to explicitly close a database connection.

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.

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

The NOT NULL keywords are often used with primary keys to require that a field include a value.

The mysql_connect() function returns a 1 if it connects to the database successfully or 0 if it doesn't.

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

PEAR stands for ________________________________________.

A list of records that are returned from a query is called a resultset.

The ___ function returns a text string describing the error in 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