Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

mysql information

memorize.ai (lvl 286)

Section 1

Preview this deck

Which of the following statements is used to create a query string in $SQLstring to delete the company_cars table

Front

1 / 27

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (27)

Section 1

(27 cards)

Which of the following statements is used to create a query string in $SQLstring to delete the company_cars table

Front

$SQLstring = "DROP TABLE company_cars";

Back

When using the INSERT and VALUE keywords to add records to a table using the mysql_query() function, what keyword is used to indicate that there is no value for a fi eld?

Front

NULL

Back

clause indicates a fi eld or fi elds that will be used as a referential index for the table

Front

Back

Which of the following functions reports the error message from the last failed database connection attempt?

Front

mysql_error()

Back

function closes a database connection.

Front

mysql_close()

Back

function returns the number of operations for various types of actions, depending on the type of query

Front

Th e mysql_info()

Back

Which of the following SQL keywords creates an autoincrementing

Front

AUTO_INCREMENT

Back

Which of the following functions closes a database connection

Front

mysql_free_connect()

Back

Which of the following functions reports the error message from the last failed database connection attempt?

Front

mysql_error()

Back

To which of the following functions do you need to pass a variable representing the database connection? (Choose all that apply.)

Front

mysql_get_host_info() c. mysql_get_proto_info() d. mysql_get_server_info()

Back

Which of the following characters suppresses error messages

Front

@

Back

You use the _ statement and_function with a local text fi le to add multiple records to a database.

Front

LOAD DATA , the mysql_query()

Back

What is the correct syntax for selecting a database with the mysql_select_db() function? (Select all that apply.)

Front

mysql_select_db(database) c. mysql_select_db(database, connection)

Back

The function returns the number of operations for various types of actions, depending on the type of query.

Front

mysql_info()

Back

Which of the following functions closes a resultset to ensure that it doesn't keep taking up space in your Web server's memory?

Front

mysql_free_result()

Back

Which of the following functions returns the fi elds in the current row of a resultset into an associative array

Front

mysql_assoc_fetch()

Back

Which of the following functions opens a database connection

Front

mysql_close()

Back

clause creates a fi eld that must contain data

Front

NOT NULL

Back

Which of the following functions returns the number of rows aff ected by queries that do not return results, such as INSERT, UPDATE, and DELETE queries?

Front

mysql_affected_rows()

Back

To which of the following functions do you need to pass a variable representing the database connection

Front

Back

mysql_query() function to prevent your code from attempting to create a table that already exists

Front

$TableName = "employees"; $SQLstring = "SELECT * FROM $TableName"; $QueryResult = @mysql_query($SQLstring, $DBConnect); if (mysql_num_rows($QueryResult) > 0) { echo "<p>The $TableName table already exists!</p>"; } else { //create table }

Back

tatement with the mysql_query() function to delete a table

Front

DROP TABLE

Back

Explain what a result pointer is and how to create and use one.

Front

a special type of variable that refers to the currently selected row in a resultset. *You assign the result pointer to a variable, which allows you to access the recordsfrom the resultset in PHP.

Back

https://www.coursehero.com/flashcards/511928/MIS-3501-FINAL/

Front

great information

Back

Which of the following functions returns the fi elds in the current row of a resultset into an indexed array? (Select all that apply.

Front

mysql_fetch_array() mysql_fetch_row()

Back

Which of the following functions terminates script execution?

Front

exit() c. die()

Back

clause creates a fi eld that is automatically updated with the next sequential value for that column

Front

AUTO_INCREMENT

Back

mysql information

Preview this deck

Which of the following statements is used to create a query string in $SQLstring to delete the company_cars table

0.0

Cards (27)

Which of the following statements is used to create a query string in $SQLstring to delete the company_cars table

$SQLstring = "DROP TABLE company_cars";

When using the INSERT and VALUE keywords to add records to a table using the mysql_query() function, what keyword is used to indicate that there is no value for a fi eld?

NULL

clause indicates a fi eld or fi elds that will be used as a referential index for the table

Which of the following functions reports the error message from the last failed database connection attempt?

mysql_error()

function closes a database connection.

mysql_close()

function returns the number of operations for various types of actions, depending on the type of query

Th e mysql_info()

Which of the following SQL keywords creates an autoincrementing

AUTO_INCREMENT

Which of the following functions closes a database connection

mysql_free_connect()

Which of the following functions reports the error message from the last failed database connection attempt?

mysql_error()

To which of the following functions do you need to pass a variable representing the database connection? (Choose all that apply.)

mysql_get_host_info() c. mysql_get_proto_info() d. mysql_get_server_info()

Which of the following characters suppresses error messages

@

You use the _____ statement and_____function with a local text fi le to add multiple records to a database.

LOAD DATA , the mysql_query()

What is the correct syntax for selecting a database with the mysql_select_db() function? (Select all that apply.)

mysql_select_db(database) c. mysql_select_db(database, connection)

The function returns the number of operations for various types of actions, depending on the type of query.

mysql_info()

Which of the following functions closes a resultset to ensure that it doesn't keep taking up space in your Web server's memory?

mysql_free_result()

Which of the following functions returns the fi elds in the current row of a resultset into an associative array

mysql_assoc_fetch()

Which of the following functions opens a database connection

mysql_close()

clause creates a fi eld that must contain data

NOT NULL

Which of the following functions returns the number of rows aff ected by queries that do not return results, such as INSERT, UPDATE, and DELETE queries?

mysql_affected_rows()

To which of the following functions do you need to pass a variable representing the database connection

mysql_query() function to prevent your code from attempting to create a table that already exists

$TableName = "employees"; $SQLstring = "SELECT * FROM $TableName"; $QueryResult = @mysql_query($SQLstring, $DBConnect); if (mysql_num_rows($QueryResult) > 0) { echo "<p>The $TableName table already exists!</p>"; } else { //create table }

tatement with the mysql_query() function to delete a table

DROP TABLE

Explain what a result pointer is and how to create and use one.

a special type of variable that refers to the currently selected row in a resultset. *You assign the result pointer to a variable, which allows you to access the recordsfrom the resultset in PHP.

https://www.coursehero.com/flashcards/511928/MIS-3501-FINAL/

great information

Which of the following functions returns the fi elds in the current row of a resultset into an indexed array? (Select all that apply.

mysql_fetch_array() mysql_fetch_row()

Which of the following functions terminates script execution?

exit() c. die()

clause creates a fi eld that is automatically updated with the next sequential value for that column

AUTO_INCREMENT

You use the _ statement and_function with a local text fi le to add multiple records to a database.