when the data file of the undo tablespace is autoextensible
when there are more than one undo tablespaces available in the database
when the undo tablespace is of a fixed size and retention guarantee is not enabled
when the undo tablespace is autoextensible and retention guarantee is not enabled
第1题:
The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL ‘6‘ MINUTE)WHERE ename = ‘ALLEN‘;What are the minimum requirements for the statement to execute successfully? ()
A. ARCHIVELOG mode must be enabled
B. Row Movement must be enabled for the table
C. FLASHBACK must be set to ON for the database
D. The UNDO_MANAGEMENT parameter must be set to AUTO
E. The UNDO_RETENTION parameter must be set appropriately
第2题:
第3题:
The human can react to any situation, some of which he may never have imagined.()
第4题:
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? ()
第5题:
第6题:
Which of the following best summarizes the U. S. economic situation today?
[A]American economists are painting a gloomy picture.
[B]It is slowly warming up with moderate growth.
[C]Recession may come back anytime in the coming months.
[D]Most sectors are picking up at a surprisingly fast pace.
这是一道涉及对全文主旨理解的考题。综合全文,作者对美国经济进行了客观、全面的分析。从第二至四段的内容可知,作者对GDP的增长原因、经济对劳动市场的影响、美联储提高利率的措施都持有谨慎的乐观态度。但是作者也指出失业的速度有所缓和(三段末),美联储的货币政策相对中性化(四段末),工业生产部门的产量正在达到底线,复苏即将开始(第五段),办公设备部门将以比较缓和的速度继续增长(第九段末)。因此[B]项恰当地概括了美国的经济形势。
文章开篇就提到,政府报告带来的意外惊喜使经济学家对国民生产总值的预测上调。排除[A]项。首段提到,有观点认为经济衰退期已在12月或1月终止。但下文只描述了经济的复苏趋势,因此[C]项不符合。[D]项错在surprisingly fast pace,文中大量出现表示“适中、温和”含义的关键词,如tame,neutrality,relaxed pace等,表明经济的发展速度是缓慢的。
第7题:
第8题:
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? ()
A. Check the alert log file
B. Query the V$FLASHBACK_DATABASE_LOG view
C. Query the V$RECOVERY_FILE_DEST_SIZE view
D.Query the V$FLASHBACK_DATABASE_STAT view
E. Check the value assigned for the UNDO_RETENTION parameter
第9题:
The remote host parameter configured on the LNS must match which parameter on the LAC?()
第10题:
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()