FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Manipulating Mysql Databases With Php

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

PEAR stands for ________________________________________.

Correct Answer

verified

PHP Extens...

View Answer

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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.

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

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

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

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

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

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

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

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.

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

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

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

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.

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