PHP & MySQL MCQ – Connect, Insert, Update, Retrieve

1. Which function is used in PHP to connect to a MySQL database using MySQLi?

a) mysql_connect()
b) mysqli_connect()
c) connect_mysql()
d) db_connect()

2. What does the mysqli_query() function do?

a) Connects to the database
b) Sends an SQL query to the database
c) Fetches data only
d) Closes the connection

3. Which SQL statement is used to insert new data into a table?

a) UPDATE
b) SELECT
c) INSERT INTO
d) ADD

4. How do you fetch one row from a result set in PHP using MySQLi?

a) mysqli_fetch_row()
b) fetch()
c) mysqli_get()
d) mysqli_query()

5. Which SQL command is used to change existing data in a MySQL table?

a) UPDATE
b) CHANGE
c) MODIFY
d) ALTER

6. What function is used to start a session in PHP?

a) session_begin()
b) start_session()
c) session_start()
d) begin_session()

7. What superglobal is used to store session data?

a) $_COOKIE
b) $_POST
c) $_SESSION
d) $_GET

8. Which hash function is commonly used to store passwords securely in PHP?

a) md5()
b) password_hash()
c) base64_encode()
d) sha1()

9. During login, how do you verify a password hashed with password_hash()?

a) verify_hash()
b) md5_check()
c) password_verify()
d) password_check()

10. Which of the following is a correct way to redirect a user after login in PHP?

a) goto("home.php")
b) navigate("home.php")
c) redirect("home.php")
d) header("Location: home.php")

Wait for 20 seconds...