भाषा का प्रयोग दो

Which command removes all rows but keeps table structure?

Which SQL function returns the largest value in a column?

Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?

Which SQL keyword prevents duplicate rows in result?

Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?

Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?

A transaction in DBMS is said to be atomic if:

Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?

Materialized views differ from normal views because:

Which clause is used to sort query results in SQL?