PHP-Midterm Exam

Which PHP function is used to execute SQL queries?

• mysqli_query()

• mysql_query()

• pdo_query()

• sql_query()

It is a collection of 1024 Terabytes

• Exabyte

• Petabyte

• Zettabyte

• Yottabyte

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

• mysqli_fetch_array()

• mysql_fetch_all()

• pdo_fetch_all()

• mysqli_query()

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 initialize your session?

• session_close()

• session_start()

• session_unset()

• session_destroy()

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()

Which SQL statement is used to extract data from a database?

• SELECT

• INSERT

• UPDATE

• DELETE

Which SQL statement is used to insert new data in a database?

• INSERT INTO

• INSERT NEW

• INSERT VALUE

• ADD NEW

It is a collection of bytes in Database

• Field

• Bit

• Record

• File

What is the total number of rows in MS Excel 2016 or 2019

• 1,048,576

• 16,384

• 255

• 31