Question : Which SQL statement is used to create a new database?
Solution :
Correct Answer : CREATE DATABASE
Description -
Question : Which command is used to delete a database permanently?
Solution :
Correct Answer : DROP DATABASE
Description -
Question : Which command is used to select a database in MySQL?
Solution :
Correct Answer : USE
Description -
Question : Which SQL command changes the name of an existing database?
Solution :
Correct Answer : RENAME DATABASE
Description -
Question : What will happen if you execute DROP DATABASE?
Solution :
Correct Answer : Entire database is deleted
Description -
Question : Which keyword is mandatory in CREATE DATABASE syntax?
Solution :
Correct Answer : DATABASE
Description -
Question : Which command is used before creating tables?
Solution :
Correct Answer : USE database_name
Description -
Question : Identify the correct syntax to create a database.
Solution :
Correct Answer : CREATE DATABASE Test;
Description -
Question : Which command may fail if the database does not exist?
Solution :
Correct Answer : USE
Description -
Question : Which statement prevents an error while creating an existing database?
Solution :
Correct Answer : CREATE DATABASE IF NOT EXISTS
Description -
Question : Which privilege is generally required to create a database?
Solution :
Correct Answer : CREATE
Description -
Question : Which SQL statement is correct for deleting database "Library"?
Solution :
Correct Answer : DROP DATABASE Library;
Description -
Question : Which command is database-specific in MySQL?
Solution :
Correct Answer : USE
Description -
Question : What is the default action of DROP DATABASE?
Solution :
Correct Answer : Delete all contents permanently
Description -
Question : Which command changes the current active database?
Solution :
Correct Answer : USE
Description -
Question : Which of the following is NOT a valid database command?
Solution :
Correct Answer : SELECT DATABASE
Description -
Question : What is the purpose of IF EXISTS in DROP DATABASE?
Solution :
Correct Answer : Avoids error if database does not exist
Description -
Question : Which SQL command selects the database "Company"?
Solution :
Correct Answer : USE Company;
Description -
Question : Which command is DDL related to databases?
Solution :
Correct Answer : CREATE DATABASE
Description -
Question : Which operation is irreversible without backup?
Solution :
Correct Answer : DROP DATABASE
Description -
Question : Which symbol ends SQL statements?
Solution :
Correct Answer : ;
Description -
Question : Which command creates database "ExamDB"?
Solution :
Correct Answer : CREATE DATABASE ExamDB;
Description -
Question : Which command is used after installing MySQL to work inside a database?
Solution :
Correct Answer : USE
Description -
Question : Which command can produce data loss?
Solution :
Correct Answer : DROP DATABASE
Description -
Question : Which SQL keyword is associated with database removal?
Solution :
Correct Answer : DROP
Description -
Question : What happens if two databases have the same name?
Solution :
Correct Answer : Error occurs
Description -
Question : Which command activates "StudentDB"?
Solution :
Correct Answer : USE StudentDB;
Description -
Question : Which command is safest while deleting a database?
Solution :
Correct Answer : DROP DATABASE IF EXISTS Test;
Description -
Question : Which statement is true about CREATE DATABASE?
Solution :
Correct Answer : It creates a new database structure
Description -
Question : Which SQL command is used to work with an existing database?
Solution :
Correct Answer : USE
Description -