Your database is in NOARCHIVELOG mode.One of the two data files belonging to the SYSTEM tablespace is corrupt.You discover that all online redo logs have been overwritten since the last backup.Which method would you use to recover the data file using RMAN?
ENCRYPT_TS is an encrypted tablespace that contains tables with data.Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.Which two actions will permit the TSPITR to work? (Choose two.)
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings inRMAN:Which statement is true about the outcome?
You want to track and store all transactional changes to a table over its lifetime.To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.To accomplish this, you issued the following command:ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;What is the implication of this command?
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?
