MYSQL&PHP

mysqli_query(Which PHP extension provides support for MySQL databases?

• mysqli

• mysql

• pdo_mysql

• sql

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 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 retrieve the number of rows in a result set?

• ) mysqli_num_rows()

• mysql_num_rows()

• pdo_num_rows()

• sql_num_rows()

A _______is a request for data or information from a database table or combination of tables.

• query

• request

• command

• instruction

_________is an open-source relational database management system

• SQL

• PHP

• HTML

• MYSQL

A ______is an organized collection of data, generally stored and accessed electronically from a computer system.

• Table

• Database

• MYSQL

• DBMS

Identify the function used to return code, if any mistakes occur in connecting database?

• mysqli_connect()

• mysqli_close()

• mysqli_query()

• mysqli_connect_error()

What are the parameters used to database connnection?

• Database Server name

• Username

• Password

• Database name