PHP + MySQL Database System Quiz

What is MySQL?

• A programming language

• A database system

• A web browser

• A web server

What does a table in MySQL database represent?

• A collection of audio files

• A collection of related data

• A collection of images

• A collection of videos

What does the SQL SELECT statement do?

• Delete records from a table

• Update existing records

• Insert data into a table

• Retrieve records from a table

Which function is used to connect to MySQL server in PHP?

• pdo_connect()

• mysql_connect()

• mysqli_connect()

• mysqli_open()

What does the LIMIT clause in MySQL do?

• Sets a default value for a column

• Specifies the number of records to return

• Orders the data from a table

• Deletes records from a table

What does the ORDER BY clause in MySQL do?

• Deletes records from a table

• Retrieves records from a table

• Updates existing records

• Orders the data from a table

What does the UPDATE statement in MySQL do?

• Inserts new records into a table

• Retrieves records from a table

• Deletes existing records

• Updates existing records

Which function is used to retrieve the number of rows in a result set in PHP?

• mysqli_fetch_assoc()

• mysqli_num_rows()

• mysqli_fetch_array()

• mysqli_free_result()

What does the DELETE statement in MySQL do?

• Retrieves records from a table

• Updates existing records

• Inserts new records into a table

• Deletes existing records

Which function is used to fetch a result row as an associative array in PHP?

• mysqli_fetch_assoc()

• mysqli_num_rows()

• mysqli_fetch_array()

• mysqli_free_result()