Information Management - QUIZ 04 - SQL 01

What is SQL primarily used for?

• Operating Systems Management

• Web Development

• Relational Database Management

• Network Configuration

Which of the following is not a SQL command?

• CREATE

• ALTER

• INSERT

• BUILD

What is the primary purpose of the `SELECT` command in SQL?

• To create new databases

• To retrieve data from tables

• To delete data from tables

• To modify the structure of a table

What is a join in SQL?

• A function to divide tables

• A method to delete rows

• A way to combine data from multiple tables

• A technique to group data by categories

Which of the following SQL commands is used to delete data from a table?

• UPDATE

• DELETE

• SELECT

• DROP

Which of the following is a data type in SQL?

• JOIN

• INTEGER

• AGGREGATE

• FOREIGN

The `WHERE` clause in SQL is used for which of the following?

• Joining two tables

• Filtering rows based on a condition

• Sorting data

• Deleting rows

Which of these is not a type of SQL join?

• INNER JOIN

• LEFT JOIN

• FULL OUTER JOIN

• MID JOIN

In SQL, what is the function of the `GROUP BY` clause?

• To filter results

• To join multiple tables

• To group data and calculate aggregates like SUM or COUNT

• To order data in ascending or descending order

Which of the following is an advanced SQL concept?

• Data Insertion

• Joins

• Subqueries

• Data Types