MY SQL Chapter-3

Identify the error in this SQL statement: INSERT INTO Order (ID, Product) VALUES (101, 'Laptop');

• Table name should be Orders

• Syntax is correct

• Missing semicolon at the end

• The Product column does not exist

What is the purpose of the VARCHAR data type in MySQL?

• To store fixed-length strings

• To store variable-length strings

• To store large text objects

• To store integers

Which data type would be best for storing an email address?

• CHAR(50)

• VARCHAR(100)

• TEXT

• BLOB

What is the main difference between CHAR and VARCHAR data types in MySQL?

• CHAR stores binary data, VARCHAR does not

• CHAR has unlimited length, VARCHAR is limited

• CHAR is variable-length, VARCHAR is fixed-length

• CHAR is fixed-length, VARCHAR is variable-length

What does the following SQL command achieve? CREATE TABLE Orders (OrderID INT, OrderDate DATETIME DEFAULT CURRENT_TIMESTAMP);

• Creates a table with two columns without defaults

• Creates a table and sets a default timestamp for OrderDate

• Creates a table and makes OrderDate a primary key

• None of the above

What is incorrect in the following SQL statement? CREATE TABLE Users (ID INT, Name CHAR(20), Email VARHCAR(100));

• Spelling mistake in data type for Email

• ID should be VARCHAR

• Name should be TEXT

• Syntax is correct

What does the UPDATE statement do in SQL?

• Deletes records

• Modifies existing records

• Inserts new records

• Creates a table

What is the result of the following SQL query? SELECT COUNT(*) FROM Users;

• The number of rows in Users

• The list of users

• The first user in the table

• Total data size of Users

INSERT INTO Customers (Name, Age) VALUES ('Alice', 30); What does this command do?

• Inserts a new row into Customers

• Updates a row in Customers

• Deletes a row from Customers

• None of the above

What is the main purpose of using a JOIN in SQL?

• To delete records from a table

• To merge rows from two or more tables

• To update records in a table

• To create a new table