SQL and PL/SQL Multiple Choice Questions

Which SQL command is used to create a new database?

• CREATE TABLE

• CREATE DATABASE

• MAKE DATABASE

• NEW DATABASE

Which of the following is a DML command?

• CREATE

• DROP

• INSERT

• ALTER

The command used to remove all rows from a table but keep its structure is:

• DELETE

• DROP

• TRUNCATE

• ERASE

The WHERE clause is used to:

• Group data

• Filter records

• Sort results

• Rename columns

Which function returns the number of rows in a table?

• SUM()

• COUNT()

• AVG()

• MAX()

The SQL clause used to arrange records in ascending or descending order is:

• GROUP BY

• ORDER BY

• SORT

• HAVING

Aggregate functions return:

• Multiple values

• A single value

• Boolean values

• Text only

Which SQL operator is used to combine the results of two queries?

• INTERSECT

• UNION

• MINUS

• JOIN

What is a nested query?

• Query without a WHERE clause

• Query inside another query

• Query with GROUP BY

• None

Which type of join returns only matching rows from both tables?

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

• FULL JOIN