PHP-MySQL Quiz

What is MySQL primarily used for?

• Image editing

• Video streaming

• Web databases

• File compression

Which language is commonly used with MySQL on the web?

• Python

• Java

• PHP

• Ruby

What does mysqli_connect() require?

• Only username and password

• Hostname, database, username, password

• Just the database name

• No parameters

Which of the following is NOT an advantage of MySQL?

• Secure

• Scalable

• Expensive

• Fast

Who developed MySQL?

• Microsoft

• Oracle

• Google

• IBM

How do you create a database in MySQL via PHP?

• create_db()

• newDatabase()

• mysqli_query($conn, "CREATE DATABASE dbname")

• add_database()

What is the SQL command to create a table?

• ADD TABLE

• INSERT TABLE

• CREATE TABLE

• MAKE TABLE

What does AUTO_INCREMENT do in a table column?

• Sets default value

• Makes column editable

• Automatically increases numeric value

• Creates a foreign key

Which keyword sets a default value in a column?

• SET

• DEFAULT

• VALUE

• PRIMARY

Which is the correct way to select all data from a table?

• SELECT ALL

• SELECT * FROM table_name

• GET ALL FROM table

• FETCH ALL