MySQL Quiz Class X

Which of the following commands creates a table named students with columns id (integer) and name (varchar)?

• CREATE students TABLE (id INT, name VARCHAR(50));
• CREATE TABLE students id INT, name VARCHAR(50);
• CREATE TABLE students (id INT, name VARCHAR(50));
• CREATE TABLE students (id TEXT, name INT);

How would you create a table with a primary key on the id column?

• CREATE TABLE example (id PRIMARY KEY INT);
• CREATE TABLE example PRIMARY KEY (id);
• CREATE TABLE example (id INT PRIMARY KEY);
• CREATE example (id INT PRIMARY KEY);

What does the following query do? UPDATE employees SET salary = salary * 1.1 WHERE department = 'Sales';

• Increases salary by 10% for all employees.
• Increases salary by 10% for employees in the Sales department.
• Does nothing.
• Throws an error.

How can you update the name column in the students table to John for the row with id=1?

• MODIFY students SET name='John' WHERE id=1;
• CHANGE students name='John' WHERE id=1;
• UPDATE students SET name='John' WHERE id=1;
• SET students name='John' FOR id=1;

What is the purpose of the SELECT statement?

• To retrieve data from one or more tables.
• To delete data from a table.
• To insert data into a table.
• To modify the structure of a table.

Which query retrieves all columns from the products table?

• SELECT all FROM products;
• SELECT * FROM products;
• SELECT columns FROM products;
• SELECT ALL COLUMNS FROM products;

How can you add a new column email to the users table?

• UPDATE users ADD COLUMN email VARCHAR(50);
• ADD COLUMN email VARCHAR(50) TO users;
• ALTER TABLE users ADD COLUMN email VARCHAR(50);
• MODIFY users ADD email VARCHAR(50);

Which of the following commands renames a table old_name to new_name?

• MODIFY TABLE old_name TO new_name;
• CHANGE TABLE old_name TO new_name;
• UPDATE TABLE old_name SET NAME = new_name;
• ALTER TABLE old_name RENAME TO new_name;

What happens when you execute the DROP TABLE employees; command?

• Deletes all rows but keeps the table structure.
• Permanently deletes the table and its data.
• Archives the table for future recovery.
• Renames the table to employees_deleted.

How can you delete the sales database?

• DELETE DATABASE sales;
• REMOVE DATABASE sales;
• DROP DATABASE sales;
• ALTER DATABASE sales DROP;