网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “ 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 in the table. ” 相关考题
考题
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQLDESCV$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.
考题
Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()
A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.
考题
WhichofthefollowingparametersdefinesthelocationwhereOracleshouldcreatearchivedredologs?()
A.LOG_ARCHIVE_1B.LOG_DESTINATION_1C.LOG_ARCHIVED_DESTINATION_1D.LOG_ARCHIVE_DEST_1E.LOG_ARCHIVE_SOURCE_1
考题
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.
考题
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
考题
Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?()
A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.
考题
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.
考题
Whichinitializationparametermustyousettoenableautomaticarchiving?()
A.LOG_ARCHIVE_DESTB.LOG_ARCHIVE_STARTC.LOG_ARCHIVE_FORMATD.LOG_ARCHIVE_MAX_PROCESSES
考题
Youconfiguredautomaticarchiveloggingforthedatabase.Onthenextstartupthedatabaserunsforawhile，butthenhangs.Aftercheckingthealertlog，youdeterminethatalltheonlineredologsneedarchiving.Whichstepwasskippedwhenyousetupautomaticarchivelog？（）A.LOG_ARCHIVE_DESTwasnotsetintheparameterfile.B.LOG_ARCHIVE_STARTwasnotsetintheparameterfile.C.alterdatabasearchivelog；wasnotexecutedinMOUNTmode.D.LOG_ARCHIVE_MAXprocesseswerenotsetintheparameterfile.
考题
Flash back
热门标签
最新试卷
