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

ALTER TABLE old_name RENAME 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;

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

Permanently deletes the table and its data.

Deletes all rows but keeps the table structure.

Archives the table for future recovery.

Renames the table to employees_deleted.

Which query adds a row with id=1 and name='Alice' to the users table?

INSERT INTO users VALUES (1, 'Alice');

ADD INTO users VALUES (1, 'Alice');

INSERT VALUES (1, 'Alice') INTO users;

How do you insert data into specific columns of a table?

INSERT INTO table_name (column1, column2) VALUES (value1, value2);

INSERT INTO table_name column1, column2 VALUES (value1, value2);

INSERT table_name (column1, column2) VALUES (value1, value2);

ADD INTO table_name (column1, column2) VALUES (value1, value2);

What does the following query do? DELETE FROM orders WHERE order_id = 5;

Deletes the row with order_id=5 from the orders table.

Deletes all rows from the orders table.

Renames the row with order_id=5.

What is the purpose of the GROUP BY clause?

To group rows with the same values in specified columns.

To sort data in descending order.

To filter rows based on a condition.

To retrieve data from multiple tables.

What is the correct syntax to filter rows where price is between 10 and 20?

SELECT * FROM products WHERE price BETWEEN 10 AND 20;

SELECT * FROM products WHERE price IN (10, 20);

SELECT * FROM products WHERE price > 10 AND price < 20;

SELECT * FROM products BETWEEN price 10 AND 20;

How do you count the number of rows in a table?

SELECT COUNT * FROM table_name;

SELECT COUNT() FROM table_name;

What does SUM(column_name) do?

Adds up all the values in the column.

Finds the average of the column values.

Counts the number of rows in the column.

Finds the maximum value in the column.

What does AVG(column_name) calculate?

The average of the column values.

The total of the column values.

The count of rows in the column.

The largest value in the column.

How do you find the number of non-null rows in a column?

SELECT COUNT(column_name) FROM table_name;

SELECT NONNULL(column_name) FROM table_name;

SELECT COUNT(*) FROM table_name;

SELECT TOTAL(column_name) FROM table_name;

What does the MIN(column_name) function do?

Returns the smallest value in the column.

Finds the average value in the column.

Counts the total number of rows.

Returns the sum of all values in the column.

How can you retrieve rows where the name column starts with the letter 'A'?

SELECT * FROM table_name WHERE name LIKE 'A%';

SELECT * FROM table_name WHERE name LIKE '%A';

SELECT * FROM table_name WHERE name = 'A%';

SELECT * FROM table_name WHERE name LIKE '_A%';

What is the purpose of the COUNT(*) function?

To count all non-null values in a column.

To calculate the sum of column values.

To group rows based on conditions.

Which query will retrieve rows where price is greater than 50?

SELECT * FROM products WHERE price > 50;

SELECT * FROM products HAVING price > 50;

SELECT * FROM products GROUP BY price > 50;

SELECT * FROM products ORDER BY price > 50;

What is the result of the query SELECT AVG(price) FROM items;?

The average of all price values in the items table.

The total count of rows in the items table.

The minimum price value in the items table.

Which query retrieves rows where age is either 18, 20, or 22?

SELECT * FROM users WHERE age IN (18, 20, 22);

SELECT * FROM users WHERE age BETWEEN 18, 22;

SELECT * FROM users WHERE age = 18 OR 20 OR 22;

SELECT * FROM users WHERE age IS (18, 20, 22);

How can you sort rows in ascending order by name?

SELECT * FROM users ORDER BY name ASC;

SELECT * FROM users GROUP BY name ASC;

SELECT * FROM users WHERE name ASC;

SELECT * FROM users SORT BY name;

How do you retrieve rows where salary is less than 50,000 and department is 'HR'?

SELECT * FROM employees WHERE salary < 50000 AND department = 'HR';

SELECT * FROM employees WHERE salary < 50000 OR department = 'HR';

SELECT * FROM employees WHERE salary < 50000, department = 'HR';

SELECT * FROM employees WHERE salary BETWEEN 0 AND 50000 AND department = 'HR';

What does HAVING SUM(sales) > 1000 do when used with GROUP BY?

Filters groups where the total sales exceeds 1000.

Filters rows where sales is greater than 1000.

Orders groups with sales greater than 1000.

Groups rows with sales greater than 1000.

Which query will delete rows where status is 'inactive'?

DELETE FROM users WHERE status = 'inactive';

REMOVE FROM users WHERE status = 'inactive';

DELETE ROWS FROM users WHERE status = 'inactive';

CLEAR FROM users WHERE status = 'inactive';

How do you retrieve distinct values from a column?

SELECT DISTINCT column_name FROM table_name;

SELECT UNIQUE(column_name) FROM table_name;

SELECT ONLY(column_name) FROM table_name;

SELECT column_name DISTINCT FROM table_name;

Which query finds rows where name contains the substring 'john'?

SELECT * FROM users WHERE name LIKE '%john%';

SELECT * FROM users WHERE name LIKE 'john';

SELECT * FROM users WHERE name CONTAINS 'john';

SELECT * FROM users WHERE name HAS 'john';

How do you rename the column age to years in the students table?

ALTER TABLE students CHANGE age years INT;

UPDATE students SET age TO years;

ALTER students RENAME age TO years;

MODIFY TABLE students COLUMN age TO years;

What does SELECT * FROM products ORDER BY price DESC; do?

Sorts rows by price in descending order.

Filters rows where price is in descending order.

Groups rows by price in descending order.

Deletes rows with descending price.

How do you find the total number of rows grouped by category?

SELECT category, COUNT() FROM items GROUP BY category;

SELECT category, COUNT(category) FROM items;

SELECT COUNT(*) FROM items WHERE GROUP BY category;

SELECT COUNT(category) GROUP BY category FROM items;

Which query finds the maximum marks in the students table?

SELECT MAX(marks) FROM students;

SELECT MAX(marks) AS highest_marks FROM students GROUP BY marks;

SELECT marks FROM students ORDER BY marks DESC LIMIT 1;

SELECT MAXIMUM(marks) FROM students;

How do you retrieve rows where created_date is between '2023-01-01' and '2023-12-31'?

SELECT * FROM logs WHERE created_date BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM logs WHERE created_date > '2023-01-01' AND < '2023-12-31';

SELECT * FROM logs WHERE created_date IN ('2023-01-01', '2023-12-31');

SELECT * FROM logs WHERE created_date RANGE '2023-01-01' TO '2023-12-31';

What does TRUNCATE TABLE orders; do?

Removes all rows from the orders table but keeps its structure.

Deletes specific rows from the orders table.

Removes the table and resets the database.

Which query retrieves rows where price is greater than or equal to 100?

SELECT * FROM products WHERE price >= 100;

SELECT * FROM products WHERE price = 100;

SELECT * FROM products HAVING price >= 100;

SELECT * FROM products WHERE price BETWEEN 100 AND MAX(price);

How do you change the data type of a column?

ALTER TABLE table_name MODIFY COLUMN column_name data_type;

UPDATE TABLE table_name CHANGE COLUMN data_type;

MODIFY table_name COLUMN column_name data_type;

CHANGE COLUMN data_type IN table_name;

Which query calculates the total quantity for each product?

SELECT product, SUM(quantity) FROM sales GROUP BY product;

SELECT product, SUM(quantity) FROM sales WHERE product;

SELECT SUM(quantity), product GROUP BY product;

SELECT SUM(product), quantity FROM sales;

How do you remove duplicate rows from the results?

SELECT DISTINCT * FROM table_name;

SELECT * FROM table_name WHERE UNIQUE;

SELECT DISTINCT ROWS FROM table_name;

SELECT * FROM table_name REMOVE DUPLICATES;

Which query will retrieve rows where score is not null?

SELECT * FROM students WHERE score IS NOT NULL;

SELECT * FROM students WHERE score = NOT NULL;

SELECT * FROM students WHERE score != NULL;

SELECT * FROM students WHERE NOT NULL(score);

What does LIMIT 10 do in a query?

Restricts the result to the first 10 rows.

Sorts the first 10 rows in ascending order.

Filters rows where values are below 10.

Removes rows beyond the 10th row.

How do you combine rows from two tables with similar structure?

SELECT * FROM table1 UNION SELECT * FROM table2;

SELECT * FROM table1 AND table2;

SELECT * FROM table1 UNION table2;

What does the following query return? SELECT name, COUNT(*) FROM users GROUP BY name HAVING COUNT(*) > 1;

Names that appear more than once in the users table.

Rows grouped by name regardless of duplicates.

MySQL Quiz Class X

Authored by Alakesh Barua

Computers

10th Grade

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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);

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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);

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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);

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

First Quarter Exam in T.L.E. 7- ICT

Quiz

•

7th Grade - University

48 questions

DPK 2 TKJ

Quiz

•

10th Grade

50 questions

Excel - Hàm

Quiz

•

9th Grade - University

54 questions

Programming Concepts

Quiz

•

9th - 12th Grade

50 questions

UNIT 2.2 PROGRAMMING TECHNIQUES

Quiz

•

10th Grade

50 questions

Asas Sains Komputer Tingkatan 3

Quiz

•

9th - 12th Grade

49 questions

1. Data Representation - Computer Science CIE IGCSE 2023-24

Quiz

•

10th Grade

50 questions

AI, Machine Learning, and Neural Networks

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Computers

10 questions

Navigating Digital Citizenship and Online Safety

Interactive video

•

6th - 10th Grade

10 questions

Exponent Rules

Quiz

•

9th - 12th Grade

20 questions

JavaScript - Karel

Quiz

•

9th - 10th Grade

MySQL Quiz Class X

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

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

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

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

What is the purpose of the SELECT statement?

Which query retrieves all columns from the products table?

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

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

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

How can you delete the sales database?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers