PHP MySQL

Which of the following is not a component of CRUD?

• Create

• Read

• Update

• Drop

Which PHP function is used to execute SQL queries?

• Which PHP function is used to execute SQL queries?

• mysql_query()

• pdo_query()

• sql_query()

mysqli_query(Which PHP extension provides support for MySQL databases?

• mysqli

• mysql

• pdo_mysql

• sql

Which MySQL command is used to create a new table

• CREATE DATABASE

• CREATE TABLE

• INSERT INTO

• SELECT

Which of the following is used to retrieve data from a MySQL database?

• mysqli_fetch_all()

• mysql_fetch_all()

• pdo_fetch_all()

• mysqli_query()

Which of the following is used to update data in a MySQL database?

• UPDATE

• DELETE

• INSERT INTO

• SELECT

Which of the following is used to delete data from a MySQL database?

• UPDATE

• DELETE

• INSERT INTO

• SELECT

Which of the following is used to insert new data into a MySQL database?

• UPDATE

• DELETE

• INSERT INTO

• SELECT

Which of the following is used to establish a connection to a MySQL database?

• mysqli_connect()

• mysql_connect()

• pdo_connect()

• sql_connect()

Which of the following is used to close a connection to a MySQL database?

• mysqli_close()

• mysql_close()

• pdo_close()

• sql_close()