Which SQL keyword is used to remove duplicate rows from the result set of a query?

• A.DISTINCT
• B.UNIQUE
• C.DISTINCTROW
• D.ONLY

Comment: *

Name: *

Email: *

Verification: *

Which type of privilege allows a user to perform administrative tasks, such as creating other users?

• A.Table privilege
• B.System privilege
• C.Schema privilege
• D.Object privilege

Comment: *

Name: *

Email: *

Verification: *

What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;

• A.Drops the salary column from the employees table
• B.Deletes the employees table
• C.Removes duplicate rows from the employees table
• D.Sets the salary column to NULL for all rows

Comment: *

Name: *

Email: *

Verification: *

What is a SELF JOIN in SQL?

• A.A join that does not require a WHERE clause
• B.A join of a table with itself
• C.A join between tables with identical structures
• D.A join used for Cartesian products

Comment: *

Name: *

Email: *

Verification: *

How are NULL values treated in relational databases?

• A.NULL values are treated as zero.
• B.NULL values are not allowed in relational databases.
• C.NULL values are treated as empty strings.
• D.NULL values represent missing or unknown data.

Comment: *

Name: *

Email: *

Verification: *