A.V$UNDOSTAT B.V$TRANSACTION C.V$ROLLSTAT D.DBA_UNDO_EXTENTS E.DBA_ROLLBACK_SEGS
单项选择题What is true regarding a transaction executed in Automatic Undo Management mode?()
A.A B.B C.C D.D
多项选择题YoucanuseOracleFlashbacktolookatpastactivityinyourdatabase.WhataretwoothercharacteristicsofOracleFlashback?()
A.Oracle Flashback uses undo information to construct consistent data. B.You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C.You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D.Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
单项选择题Whatistrueaboutversion-enabledtables?()
A.The unit of versioning is the schema. B.It is possible to version enable a table pertaining to SYS. C.There are as many segments as versions for the same base table. D.It is possible to create workspaces if there is no version-enabled table in the database.
多项选择题Which three table transformations can be done using online redefinition of tables?()
A.A B.B C.C D.D E.E
单项选择题You have just run this syntax to start the listener from the Listener Control utility: LSNRCTL>START Starting mstgelai oracle bin tnslsnr: please wait… System parameter file is u01 oracle network admin listener.ora Log messages written to u01 oracle network log listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to… The command completed successfully What is the name of the Listener you started?()
A.TNSLSNR B.LISTENER C.LOCAL_LISTENER D.DEFAULT_LSRN