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

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

A newly created database has no RMAN backups.

Examine these commands ：

CONfIGURE  RETENTION POLICY To REDUNDANCY 2 ;

RMAN> BACKUP TABLESPACE SYSTEM;

backup  set  complete, elapsed time ：

RMAN >  BACKUP TABLESPACE SYSTEM,sYSAUX ;

backup  set complete, elapsed time： 00： 00： 04

RMAN> BACKUP DATABASE ;

backup set complete, elapsed time： 00：00：07

Which two are true about the execution of the third backup command?

NAME  TYPE  VALUE

db_create_file_dest string /u01/app/oracle/oradata/prod/

Now examine this statement which executes successfully in an Oracle Database version 12c or later.

CREATE TABLESPACE data_ olap;

Which two are true about this tablespace and its attributes?

You successfully execute these commands：

SQL> CREATE AUDIT POLICY  sales_pol ACTIONS select on sh.sales;

SQL>AUDIT POLICY sales_pol;

Which statement is true about SALES_ POL?

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?

CONNECT / AS SYSDBA

CREATE DIRECTORY dumpdir AS '/u01/app/ ';

Directory created.

GRANT READ, WRITE ON DIRECTORY dumpdir To PUBLIC;

Grant succeeded .

CREATE USER TEST IDENTIFIED BY test ;

User created .

GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE To test;

Grant succeeded.

CONN test/test

connected .

CREATE TABLE test_employees (id NUMBER(3., name VARCHAR2 (20), salary NUMBER(7));

Table created .

SQL> CREATE SYNONYM emp FOR test_employees ;

synonym created .

Now examine this command：

$expdp test/test  DIRECTORY=dumpdir DUNPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP："WHERE salary=12000"'

 Which is true?

STARTUP PFILE= 'D：\0racle12c\0racle\admin\orcl\pfile\pfileinitorcl.ora '

ORACLE instance started .

Total system Global Area 5117049968 bytes

Fixed Size  9038960 bytes

Variable size  922746880 bytes 

Database Buffers  4177526784 bytes

Redo Buffers  7737344 bytes

Database mounted .

Database opened .

Now examine these statements：

SHOW PARAMETER cursor_ sharing;

NAME   TYPE   VALUE

cursor_sharing  string  EXACT

ALTER SYSTEM SET cursor_sharing= FORCE;

Which three are true about the result of processing the last statement?

SHOW PARAMETER undo retention;

NAME  TYPE    VALUE

undo_retontion  integer  900

Now examine these statements：

SELECT TABLESPACE_NAME, RETENTION

FROM dba_table_spaces

WHERE TABLESPACE_NAME="UNDOTHSl" ;

TABLESPACE_NAME   RETENTION

UNDOTBS1    GUARANTEE

conn hr/hr@PROD

Connocted .

INSERT INTO emp (id, name, salary, Depno)

VALUES (101, " John', 12000, 30.;

1 row created -

COMMIT ;

Commi tcomplete .

Which three are true about the processing of these statements?

NAME  TYPE   VALUE

undo_management string AUTO

undo_retention integer 900

Now examine this statement：

AITER TABLESPACE undotbsl RETENTION GUARANTEE;

Tablespace altered .

Which two are true about undo retention in this configuration?

Connect / as syadba

connected .

GRANT CREATE USER To hr WITH ADMIN OPTION ;

Grant succeeded .

GRANT CREATE  USER TO john;

Grant succeeded .

Connect hr/hr @PROD

connected .

GRANT CREATE USER TO alice WITH ADMIN OPTION;

Grant succeeded -

conn / as sysdba

connected

REVOKE CREATE USER FROM hr ：

Revoke' succeeded 。

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

CREATE ROLE dev1 ;

Role created 

GRANT CREATE sEssION ,CREATE USER, CREATE TABLE TO dev1 ;

Grant succeeded .

CREATE USER john IDENTIFIED BY john;

User created .

GRANT CONNECT, dev1 TO john;

Grant succeeded .

REVOKE CREATE SESSION FROM dev1 ;

Rovoke succeeded .

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