SQL>Connect / as syadba

connected .

SQL>GRANT CREATE USER To hr WITH ADMIN OPTION ; 

Grant succeeded .

SQL>GRANT CREATE USER TO john;

Grant succeeded .

SQL>Connect hr/hr@PROD

connected .

SQL>GRANT CREATE USER TO alice WITH ADMIN OPTION;

Grant succeeded -

SQL>conn / as sysdba

connected

SQL>REVOKE CREATE USER FROM hr

Revoke' succeeded.

Which two are true about the result and effects of executing these commands? 

SQL>CREATE ROLE dev1 ;

Role created.

SQL>GRANT CREATE SESSION ,CREATE USER, CREATE TABLE TO dev1 ; 

Grant succeeded .

SQL>CREATE USER john IDENTIFIED BY john;

User created .

SQL>GRANT CONNECT, dev1 TO john;

Grant succeeded .

SQL>REVOKE CREATE SESSION FROM dev1 ;

Rovoke succeeded .

Which two are true about the resut and effects of executing these commands?

Examine this command which executes sccessfully：

ALTER SYSTEM ENABLE RESTRICTED SESSION;

Which two are true?

The database instance is in ARCHIVELOG mode and the default location for the archived redo log files isthe FRA.

Which two files are removed automatically if space is required in the FRA as per the retention policy?

ALTER SYSTEM SET RESOURCE_LIMIT=FALSE SCoPE=BoTH ;

System altered .

CREATE PROFILE dev_users LIMIT SESSIONS_PER_USER 3 IDLE_TIME 10 FAILED_LOGIN_ATTEMPTS  3 PASSWORD_VERIFY_FUNCTION ora12c_verify_function;

Profile altered .

ALTER USER hr PROFILE dev_users;

User altered .

Which two are true?