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 supplemen

题目

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

相似考题

1.—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

2.“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

3.9． _______you _______ stay at home today?A． Do ; have toB． Must; have toC． Have; toD． Do ; must

4.－－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

参考答案和解析
参考答案：D, E
更多“You must track all transactions that modify certain tables in the sales schema for at leas ”相关问题

  • 第1题：

    He developed computer software to handle complicated______(finance) transactions.


    正确答案：financial
    financial 解析：本题考查词类转换。此处需用finance的形容词形式来作定语修饰transactions。再根据句意：他开发了一个电脑软件来处理复杂的财务转账。得知应填入finance的形容词形式，即去e加形容词后缀一ial。

  • 第2题：

    A: I haven't sat down all day.

    B: You _____be very tired.

    A. could

    B. have to

    C. must


    参考答案：A

  • 第3题：

    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 tables

    B.Aggregating details from various storage engine caches for the final output is time consuming

    C.Collecting information requires various disk-level operations and is time consuming

    D.Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming


    参考答案：C

  • 第4题：

    A:I haven't eaten all day.

    B: You __ be very hungry.

    A. should

    B. have to

    C. must


    参考答案：C

  • 第5题：

    —_______ I return the book to the library this week?— No, you _______.You can keep it until the end of this month.

    A.Must; needn’t

    B.Can; can’t

    C.May; mustn’t

    D.Can; mustn’t


    答案：A

  • 第6题：

    3．—__________ 1 go out for a while?

    —No，you __________ You must finish your homework first．

    A． Must，needn't

    B． Can，may

    C． May，mustn't

    D． May，must


    正确答案：C

相关内容