MySQL & PHP Basic MCQs

Which command is used to create a new database?

• CREATE NEW DATABASE dbname;

• MAKE DATABASE dbname;

• CREATE DATABASE dbname;

• ADD DATABASE dbname;

Which command is used to remove a database?

• DROP DATABASE dbname;

• DELETE DATABASE dbname;

• REMOVE DATABASE dbname;

• DESTROY DATABASE dbname;

Which statement is used to retrieve data from a database?

• FIND

• GET

• SELECT

• RETRIEVE

Which keyword is used to sort the result set in ascending order?

• ORDER BY ASC

• SORT ASC

• ASCEND

• SORT BY

Which function is used to count rows?

• COUNT()

• SUM()

• ROWS()

• TOTAL()

Which SQL statement is used to add new data to a table?

• INSERT INTO

• ADD TO

• UPDATE

• APPEND

Which SQL keyword is used to update existing data?

• CHANGE

• MODIFY

• UPDATE

• ALTER

Which command is used to delete a table completely?

• DELETE TABLE

• DROP TABLE

• REMOVE TABLE

• DESTROY TABLE

Which SQL statement is used to prevent duplicate rows?

• DISTINCT

• UNIQUE

• PRIMARY

• KEY

Which SQL clause is used to filter records?

• WHERE

• FILTER

• HAVING

• CHECK