Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING 'sales1';
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link?

You have successfully taken a database backup by using the command:
RMAN> BACKUP AS BACKUPSET DATABASE;
Now you execute this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is the outcome?

The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error?

A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = '*' SCOPE = SPFILE; Which is true about the result of this command?