CS404 T02

1. Which of the following best describes SQL?

• A procedural programming language used for web development

• A language used exclusively for creating web pages

• A standard language for querying and manipulating relational databases

• A tool for managing file systems

2. In SQL, what does DDL stand for?

• Data Distribution Language

• Data Definition Language

• Data Display Language

• Data Deletion Language

3. Which SQL clause is mandatory in every SELECT statement?

• WHERE

• GROUP BY

• FROM

• ORDER BY

4. What is the purpose of the DISTINCT keyword in a SELECT query?

• To group rows by a specified column

• To order rows in ascending order

• To calculate the sum of a column

• To eliminate duplicate rows from the result

5. What does the asterisk (*) symbol represent in a SQL query?

• A function to calculate averages

• A reference to all columns in the table

• An alias for the primary key

• A command to create a new table

6. What is the role of the ORDER BY clause in SQL?

• It sorts the query output in ascending or descending order

• It creates a new table with ordered rows

• It renames columns in the result set

• It defines the columns that need to be updated

7. How do you rename a column heading in the output of a SQL query?

• Using the ALTER keyword

• By specifying the new name in the SELECT clause with AS

• Through the RENAME TABLE command

• By updating the column name in the database schema

8. Which operator is used for concatenating two string values in SQL?

• ++

• CONCAT()

• &&

• ||

9. What is the purpose of the DUAL table in Oracle SQL?

• It provides a dummy table for performing calculations or functions

• It stores backup data for other tables

• It holds metadata for the database

• It is used to join two tables together

10. Given the query:

SELECT ename || ' earns ' || sal AS "Salary Status" FROM emp;

What will this query output?

• A list of employee names and their salaries in separate columns

• A list of employee names concatenated with a string literal and their salary

• Only the salary values formatted as text

• A list of employee names with a fixed message "Salary Status"