What happens at the next log switch?

Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3 =’LOCATIO=/disk3/arch’LOG_ARCHIVE_DEST _4 =’LOCATIONs/disk4/arch’LOG_ARCHIVE _MIN_SUCCEED_DEST = 2 While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used. What happens at the next log […]

Read More

What must you do to activate the new default value for numeric full redaction?

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————————-0 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————————-1 After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. What must you […]

Read More

XIDSTART_SCNEND_SCNOPERATIONAMT_DUE ————————– ———————– ————-

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 AlteredSQL> 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 […]

Read More

In which three scenarios is media recovery required?

In which three scenarios is media recovery required? A. when a tablespace is accidentally dropped from a database B. when archived redo log files are lost C. when data files are lost D. when one of the online redo log members is corrupted E. when all control files are lost Explanation:References: Show Answer

Read More