You executed the following commands:SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?
Which two statements are true about encrypting RMAN backups?
You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?
View the following SQL statements:Transaction T1 -SQL> INSERT INTO hr.regions -2 VALUES (5,'Pole');3 COMMIT;Transaction T2 -SQL> UPDATE hr.regions -2 SET region_name='Poles'3 WHERE region_id = 5;4 COMMIT;Transaction T3 -SQL> UPDATE hr.regions -2 SET region_name='North and South Poles'3 WHERE region_id = 5;You want to back out transaction T2. Which option would you use?
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?
