Web Application Development MCQs with Answers
Practice important Web Application Development MCQs with answers and explanations.
Multiple Choice Questions
Q121: Which of the following is NOT a MySQL tool mentioned?
- A: XAMPP
- B: WAMP
- C: PhpMyAdmin
- D: PostgreSQL
View Answer
D
Q122: Fill in the blank: The PHP MySQL extension mysqli is an improvement over the _______ extension.
- A: MySQL
- B: PDO
- C: SQLite
- D: MongoDB
View Answer
A
Q123: What does the SQL statement CREATE DATABASE mystudent; do?
- A: Creates a new database named 'mystudent'
- B: Deletes the 'mystudent' database
- C: Modifies the 'mystudent' database
- D: Selects the 'mystudent' database
View Answer
A
Q124: What SQL statement is used to create a table in MySQL?
- A: CREATE DATABASE
- B: CREATE TABLE
- C: INSERT INTO
- D: ALTER TABLE
View Answer
B
Q125: Fill in the blank: The CREATE TABLE statement in MySQL is used to _______.
- A: delete a table
- B: update a table
- C: create a new table
- D: drop a table
View Answer
C
Q126: Which MySQL data type is used for timestamps?
- A: TIMESTAMP
- B: DATE
- C: VARCHAR
- D: INT
View Answer
A
Q127: Fill in the blank: The SQL statement INSERT INTO student (firstname, lastname, email) VALUES ('Ali', 'Wali', 'ali@example.com') will _______.
- A: delete a record
- B: update a record
- C: insert a new record
- D: select a record
View Answer
C
Q128: What function retrieves the last inserted ID in MySQL?
- A: mysqli_insert_id()
- B: mysqli_last_id()
- C: mysqli_get_id()
- D: mysqli_id()
View Answer
A
Q129: Fill in the blank: To handle multiple SQL statements, the _______ function is used in PHP.
- A: mysqli_multi_query()
- B: mysqli_query()
- C: mysqli_exec()
- D: mysqli_execute()
View Answer
A
Q130: In a prepared statement, what does the bind_param() function do?
- A: Prepares the SQL statement
- B: Binds parameters to the SQL statement
- C: Executes the SQL statement
- D: Closes the SQL statement
View Answer
B