Which command revokes a user's privilege to update a table?

• A.REVOKE UPDATE ON table_name FROM user_name;
• B.DENY UPDATE ON table_name FROM user_name;
• C.REMOVE UPDATE ON table_name FROM user_name;
• D.DELETE UPDATE ON table_name FROM user_name;

Comment: *

Name: *

Email: *

Verification: *

What will the following SQL statement output?
SELECT first_name || ' ' || last_name AS full_name FROM employees;

• A.Only the first names of employees
• B.A syntax error
• C.Concatenated first and last names with spaces in between
• D.Concatenated first and last names without spaces

Comment: *

Name: *

Email: *

Verification: *

What does the NEXTVAL pseudocolumn do in SQL?

• A.Retrieves the next value in a sequence and increments the sequence
• B.Retrieves the current value of a sequence without incrementing it
• C.Deletes the sequence from the database
• D.Resets the sequence to its starting value

Comment: *

Name: *

Email: *

Verification: *

Which function is used to convert a string to uppercase in SQL?

• A.CONVERT_UPPER
• B.UPPER
• C.TO_UPPERCASE
• D.CASE_UPPER

Comment: *

Name: *

Email: *

Verification: *

Which of the following data dictionary views provides information about constraints on tables?

• A.All of the above
• B.DBA_CONSTRAINTS
• C.USER_CONSTRAINTS
• D.ALL_CONSTRAINTS

Comment: *

Name: *

Email: *

Verification: *