Quiz 1 - ITEDEV - Final

What is the correct PHP function to connect to a MySQL database?

• mysql_connect()
• connect_mysql()
• mysqli_connect()
• db_connect()
• pdo_connect()

Answer explanation

mysqli_connect() is the correct modern function for connecting to MySQL in procedural PHP.

Which superglobal is used to collect form data after submitting an HTML form with method='post'?

• $_GET
• $_REQUEST
• $_POST
• $_SESSION
• $_FORM

Answer explanation

$_POST is specifically used for handling form data submitted via POST method.

Which PHP function is used to execute a SQL query?

• mysqli_fetch()
• mysqli_query()
• execute_sql()
• run_query()
• query_db()

Answer explanation

mysqli_query() is used to send a query to the currently active database connection.

Which HTML tag is used to create a form in PHP?

• <table>
• <div>
• <input>
• <form>
• <submit>

Answer explanation

<form> tag is used to collect user input.

Which attribute specifies where to send the form data?

• method
• action
• name
• target
• destination

Answer explanation

The action attribute defines where the form data should be sent.

What will the following code output: echo 5 . '5';

• 55
• 10
• Error
• 5.5
• NULL

Answer explanation

The dot (.) operator concatenates strings, so it returns '55'.

Which SQL command is used to retrieve data from a table?

• GET
• FETCH
• RETRIEVE
• SELECT
• SHOW

Answer explanation

SELECT is the standard SQL command to retrieve data.

What is the correct PHP function to connect to a MySQL database?

• mysql_connect()
• connect_mysql()
• mysqli_connect()
• db_connect()
• pdo_connect()

Answer explanation

mysqli_connect() is the correct modern function for connecting to MySQL in procedural PHP.

Which superglobal is used to collect form data after submitting an HTML form with method='post'?

• $_GET
• $_REQUEST
• $_POST
• $_SESSION
• $_FORM

Answer explanation

$_POST is specifically used for handling form data submitted via POST method.

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

• INSERT INTO
• ADD DATA
• NEW RECORD
• UPDATE
• PUT DATA

Answer explanation

INSERT INTO is the correct SQL statement to add a new row of data.