You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database.C. Create a Flashback Data Archive in the tablespace where the tables are stored.D. Create a Flashback Data Archive in any suitable tablespace.E. Enable Flashback Data Archiving for the tables that require tracking
You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database.
C. Create a Flashback Data Archive in the tablespace where the tables are stored.
D. Create a Flashback Data Archive in any suitable tablespace.
E. Enable Flashback Data Archiving for the tables that require tracking
相关考题：
—Must I be in hospital for a week， Doctor? —No， you_________. You can go back home tomorrow.A. mustn’t B. needn’t C. must
－－Must we finish our homework now? －－No, you ______. You _______ finish it after school. A.needn't , mayB.mustn't , mayC.can't , canD.needn't , must
“Must I finish my homework now?” “No, you() . But you() finish it this evening. ” A. mustn’ t…mustB. needn’ t…mustC. can’ t…canD. can’ t…must
9． _______you _______ stay at home today?A． Do ; have toB． Must; have toC． Have; toD． Do ; must
—_______ I return the book to the library this week?— No, you _______.You can keep it until the end of this month. A.Must; needn’tB.Can; can’tC.May; mustn’tD.Can; mustn’t
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.Some details are as follows:The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query:SELECT TABLE_SCHEMA, ‘ENGINE‘, COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= ‘BASE TABLE‘ GROUP BY TABLE_SCHEMA, ‘ENGINE‘ ;Why is this query slow to execute?（）A.Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesB.Aggregating details from various storage engine caches for the final output is time consumingC.Collecting information requires various disk-level operations and is time consumingD.Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
3．—__________ 1 go out for a while?—No，you __________ You must finish your homework first．A． Must，needn'tB． Can，mayC． May，mustn'tD． May，must