In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which four actions can HR perform? (Choose four.)
A.
Revoke the CREATE SESSION privilege from other users
B.
Revoke the CREATE SESSION privilege from user HR
C.
Log in to the database instance
D.
Grant the CREATE SESSION privilege with ADMIN OPTION to other users
A.TRUE: SQL> revoke create session from g;
Revoke succeeded.
B. TRUE: SQL> revoke create session from hr;
Revoke succeeded.
C. TRUE: SQL> conn hr/hr@pdb3;
Connected.
D. TRUE: SQL> grant create session to hr with admin option;
Grant succeeded.
E. No make sense, you don't need this option to execute DDL
F. Same of letter E>
A. Revoke the CREATE SESSION privilege from other users - ORA-01031: insufficient privileges - false.
B. Revoke the CREATE SESSION privilege from user HR – it works, true.
C. Log in to the database instance – true.
D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users – true.
E. Execute DDL statements in the HR schema – false.
F. Execute DML statements in the HR schema – it works if somebody with appropriate rights creates some objects in hr’s schema. – so, it is also true.
So, BCDF.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Guhborges
3 months, 2 weeks agoM_ORACLE_RU
5 months, 1 week agoraferen10
7 months, 1 week agocrucinal1
10 months, 1 week ago