Which clause is used to ensure that only specific rows are deleted in a DELETE statement?

• A.WHERE
• B.FROM
• C.HAVING
• D.SET

Comment: *

Name: *

Email: *

Verification: *

What will the following query do?
SELECT employee_id, salary
FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);

• A.Return employees with a salary below the average salary
• B.Return employees with a salary above the average salary
• C.Return all employees and their salaries
• D.Return employees with a salary equal to the average salary

Comment: *

Name: *

Email: *

Verification: *

What is a sequence in Oracle Database?

• A.A list of numbers stored in a table
• B.A predefined set of SQL queries executed in order
• C.A type of index used for sorting rows
• D.A database object that generates a series of unique numeric values

Comment: *

Name: *

Email: *

Verification: *

How can you ensure that data is sorted in descending order in a SQL query?

• A.Use the DESC keyword
• B.Use the ASC keyword
• C.Use the DISTINCT keyword
• D.Use the ORDER keyword

Comment: *

Name: *

Email: *

Verification: *

Which type of INSERT statement allows inserting rows into multiple tables using a single SELECT query?

• A.Insert rows into a single table based on values in other tables
• B.Insert rows into multiple tables simultaneously
• C.Insert rows into a table only when a condition is met
• D.Insert rows into multiple tables without conditions

Comment: *

Name: *

Email: *

Verification: *