CodingNest Database Quiz 1

What does SQL stand for?

• Structured Query Language
• Simple Query Language
• System Query Language
• Sequential Query Language

Answer explanation

SQL stands for Structured Query Language, used for managing databases.

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

• SHOW TABLES;
• SHOW DATABASES;
• LIST DATABASES;
• DISPLAY DATABASES;

Answer explanation

SHOW DATABASES; is the correct command to list all databases.

Which statement is used to switch to a specific database?

• CHANGE DATABASE dbname;
• SELECT DATABASE dbname;
• USE dbname;
• SET DATABASE dbname;

Answer explanation

USE dbname; is the correct command to switch databases.

What is the default port for MySQL?

• 3306
• 5432
• 1521
• 1433

Answer explanation

MySQL runs on port 3306 by default.

Which SQL statement is used to insert new data into a table?

• ADD INTO
• INSERT INTO
• APPEND TO
• CREATE ROW

Answer explanation

INSERT INTO is the correct SQL statement for inserting data.

How do you retrieve all the records from a table named students?

• SELECT * FROM students;
• SHOW ALL FROM students;
• GET ALL FROM students;
• LIST * FROM students;

Answer explanation

SELECT * FROM students; fetches all records from a table.

Which SQL statement is used to modify existing data in a table?

• CHANGE
• MODIFY
• UPDATE
• ALTER

Answer explanation

UPDATE is used to modify existing data.

What will happen if you run the following command? DELETE FROM employees;

• Deletes a single record
• Deletes all records in employees table
• Deletes only duplicate records
• Drops the table

Answer explanation

DELETE FROM removes all records from the table.

Which statement is used to remove an entire table structure along with its data?

• DROP TABLE table_name;
• DELETE TABLE table_name;
• REMOVE TABLE table_name;
• CLEAR TABLE table_name;

Answer explanation

DROP TABLE removes the table and its data.

What will be the output of SELECT 10 + 5;

• 105
• 15
• 10 + 5
• Error

Answer explanation

10 + 5 evaluates to 15.