MYSQL

Which of the following is not a type of database model?

• File model
• Relational model
• Object-oriented model

Which SQL keyword is used to add data to a database table?

• INSERT
• DELETE
• SELECT

Which of the following is not a data type in MySQL?

• STRING
• INT
• DOUBLE

Which of the following is not a primary key constraint?

• FOREIGN KEY
• AUTO_INCREMENT
• NOT NULL

Which SQL keyword is used to retrieve data from a database table?

• SELECT
• UPDATE
• DELETE

What is the default port number used by the MySQL client?

• 3306
• 8080
• 443

Which command is used to list all the databases in MySQL?

• SHOW DATABASES;
• LIST DATABASES;
• DESCRIBE DATABASES;

Which command is used to create a new database in MySQL?

• CREATE DATABASE database_name;
• ADD DATABASE database_name
• NEW DATABASE database_name;

Which command is used to select a database in MySQL?

• USE database_name;
• SELECT database_name;
• SWITCH database_name;

Which command is used to exit the MySQL client?

• QUIT
• LOGOUT
• CLOSE