You obtain the results retrieved from the public synonym HR created by the database administrator.

You obtain the results retrieved from the HR table that belongs to your schema.

You get an error message because you cannot retrieve from a table that has the same name as a public synonym.

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

It allows a grantee DBA privileges.

It is required syntax for object privileges.

It allows privileges on specified columns of tables.

It is used to grant an object privilege on a foreign key column.

It allows the grantee to grant object privileges to other users and roles.

SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

SELECT student_id, gpa FROM student_grades ORDER BY gpa;

SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

CREATIVE USER susan;

CREATIVE OR REPLACE USER susan;

CREATE NEW USER susan DEFAULT

CREATE USER susan IDENTIFIED BY blue;

CREATE NEW USER susan IDENTIFIED BY blue;

CREATE OR REPLACE USER susan IDENTIFIED BY blue;