Which function is used to extract the year from a date in SQL?

• A.GET_YEAR(date)
• B.EXTRACT(YEAR FROM date)
• C.YEAR(date)
• D.TO_YEAR(date)

Comment: *

Name: *

Email: *

Verification: *

How can a synonym benefit database design?

• A.It allows the renaming of columns in a table.
• B.It improves query execution time.
• C.It enforces constraints on table columns.
• D.It provides a consistent reference to database objects, even if their underlying names change.

Comment: *

Name: *

Email: *

Verification: *

Which command is used to add a new column to an existing table?

• A.MODIFY COLUMN
• B.ALTER COLUMN
• C.ALTER TABLE
• D.ADD COLUMN

Comment: *

Name: *

Email: *

Verification: *

Which SQL function can be used to replace NULL values with a specified value?

• A.COALESCE
• B.REPLACE
• C.NVL
• D.ISNULL

Comment: *

Name: *

Email: *

Verification: *

What will the following query do?
DELETE FROM employees
WHERE department_id = 20;

• A.Delete the department_id column in the employees table
• B.Raise an error because DELETE cannot use a WHERE clause
• C.Delete all rows where department_id is 20
• D.Delete all rows in the employees table

Comment: *

Name: *

Email: *

Verification: *