Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.Examine the steps to restore the SPFILE and the control file to mount the database:1.Set D3ID of the target database in RMAN.2.Start the database instance by using the startup force nomount command in RMAN.3.Restore the control files from the backup.4.Mount the database.5.Restore the SPFILE from the autobackup.6.Create a PFILE from the recovered SPFILE.7.Restart the instance in nomount state.Identify the required steps in the correct order.
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE-------------------------SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)PL/SQL procedure successfully completed.SQL> select number_value from redaction_values_for_type_full;NUMBER VALUE --------------------------1After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.What must you do to activate the new default value for numeric full redaction?
You want to create a guaranteed restore point for your database by executing the command:SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;Identify two prerequisites for the successful execution of this command.
Your database has a table customers that contains the columns cust_name, amt_due, and old_status.Examine the commands executed and their output:SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l. 1WHEREcust_name='JAMES';1row updated.SQL> ALTER TABLE customers DROP COLUMN old_status;Table Altered -SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame='JAMES';1 row updated.SQL> COMMIT;SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN, versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_dueFROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname='JAMES';.XIDSTART_SCNEND_SCNOPERATIONAMT_DUE-------------------------- ----------------------- ------------------- ------------------- ------------------------07002f00cl03000017063371706337 U3300Why is it that only one update is listed by the Flashback Version Query?
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
