Database Query Language and procedural Language MCQS

Which of the following is used to retrieve data from a database in SQL?

• INSERT

• SELECT

• UPDATE

• DELETE

Which SQL statement is used to retrieve all columns from the "students" table?

• SELECT * FROM students;

• SELECT students FROM *;

• GET ALL students;

• SELECT ALL FROM students;

What is the purpose of the WHERE clause in SQL?

• To sort the data

• To filter the data

• To modify data

• To insert new data

Which SQL clause is used to sort the result-set?

• ORDER BY

• SORT BY

• GROUP BY

• FILTER BY

What is the function of the GROUP BY clause in SQL?

• To update data

• To filter records

• To join tables

• To aggregate data

Which SQL command is used to remove a table from a database?

• ALTER TABLE table_name;

• REMOVE TABLE table_name;

• DROP TABLE table_name;

• DELETE TABLE table_name;

What does the DISTINCT keyword do in a SQL query?

• Removes duplicate records

• Sorts the results

• Filters records based on a condition

• Groups records together

Which SQL function is used to count the number of rows in a result set?

• COUNT()

• ROWS()

• SUM()

• AVG()

What is the purpose of the JOIN clause in SQL?

• To sort the results

• To combine rows from two or more tables

• To update data

• To filter records

Which SQL statement is used to update existing records in a table?

• CHANGE table_name;

• MODIFY table_name;

• UPDATE table_name SET;

• ALTER table_name;