SQL MCQ

Which command is used to retrieve data from an SQLite database?

• • INSERT

• • UPDATE

• • SELECT

• • DELETE

What is the correct syntax to create a new table in SQLite?

• • CREATE NEW TABLE table_name (column1 datatype, column2 datatype);

• • CREATE TABLE table_name (column1 datatype, column2 datatype);

• • CREATE TABLE table_name: (column1 datatype, column2 datatype);

• • NEW TABLE table_name (column1 datatype, column2 datatype);

Which keyword is used to eliminate duplicate rows in the result set of a query?

• • UNIQUE

• • DISTINCT

• • DIFFERENT

• • EXCLUSIVE

How do you retrieve all columns from a table named employees?

• • SELECT * FROM employees;

• • SELECT all FROM employees;

• • SELECT employees.* FROM employees;

• • SELECT columns FROM employees;

What is the purpose of the WHERE clause in SQLite?

• • To sort the result set

• • To filter records

• • To join tables

• • To group records

How can you update the salary column to 5000 for all employees in the staff table?

• • MODIFY staff SET salary = 5000;

• • ALTER TABLE staff SET salary = 5000;

• • UPDATE staff SET salary = 5000;

• • SET staff.salary = 5000;

Which command is used to remove a table named customers from an SQLite database?

• • A) REMOVE TABLE customers;

• • B) DELETE TABLE customers;

• • C) DROP TABLE customers;

• • D) ERASE TABLE customers;

What does the ORDER BY clause do in a query?

• • A) Filters records based on a condition

• • B) Orders the records in a specified sequence

• • C) Aggregates records into groups

• • D) Joins two or more tables

Which command is used to add a new row to a table in SQLite?

• • A) INSERT INTO table_name VALUES (...);

• • B) ADD ROW table_name VALUES (...);

• • C) APPEND TO table_name VALUES (...);

• • D) NEW ROW table_name VALUES (...);