niusouti.com

You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column i

题目
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()

A. Drop the table.

B. Partition the table

C. Truncate the table.

D. Add a column to the table.

E. Rename a column in the table.

相似考题

1.ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL>DESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.

2.WhichofthefollowingparametersdefinesthelocationwhereOracleshouldcreatearchivedredologs?()A.LOG_ARCHIVE_1B.LOG_DESTINATION_1C.LOG_ARCHIVED_DESTINATION_1D.LOG_ARCHIVE_DEST_1E.LOG_ARCHIVE_SOURCE_1

3.Which two statements are true when row archival management is enabled?()A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

4.Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.

更多“You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?() ”相关问题

  • 第1题：

    You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）

    A. The valid time columns employee_time_start and employee_time_end are automatically created.

    B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

    C. The valid time columns are not populated by the Oracle Server automatically.

    D. The valid time columns are visible by default when the table is described.

    E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio


    参考答案：A, B, E

  • 第2题：

    You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE = ‘/u01/oradata’Which statement is true about the archived redo log files?（）

    A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

    B. They are created only in the Fast Recovery Area.

    C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

    D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


    参考答案：B

  • 第3题：

    Youconfiguredautomaticarchiveloggingforthedatabase.Onthenextstartupthedatabaserunsforawhile，butthenhangs.Aftercheckingthealertlog，youdeterminethatalltheonlineredologsneedarchiving.Whichstepwasskippedwhenyousetupautomaticarchivelog？（）

    A.LOG_ARCHIVE_DESTwasnotsetintheparameterfile.

    B.LOG_ARCHIVE_STARTwasnotsetintheparameterfile.

    C.alterdatabasearchivelog；wasnotexecutedinMOUNTmode.

    D.LOG_ARCHIVE_MAXprocesseswerenotsetintheparameterfile.


    参考答案：B

  • 第4题：

    Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?()

    A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.

    B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.

    C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.

    D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.


    参考答案：D

  • 第5题：

    Whichinitializationparametermustyousettoenableautomaticarchiving?()

    A.LOG_ARCHIVE_DEST

    B.LOG_ARCHIVE_START

    C.LOG_ARCHIVE_FORMAT

    D.LOG_ARCHIVE_MAX_PROCESSES


    参考答案：B

  • 第6题：

    Flash back


    答案：
    解析：
    Hash back即闪回，是指病人仿佛又完全身临创伤性事件发生时的情境，重新表现出事件发生时所伴发的各种情感，持续时间可从数秒钟到几天不等。

相关内容