单选题 Which of the following statements best describes Flashback Versions Query?()
Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
单选题 You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?()
ALTER DISKGROUP dg1 UNDROP disk2,disk3,disk5
ALTER DISKGROUP dg1 UNDROP
ALTER DISKGROUP dg1 UNDROP DISKS
You cannot cancel the pending disk drops
单选题 You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?()
Run Segment Advisor
Run the SQL Tuning Advisor (STA)
Run the Automatic Workload Repository (AWR) report
Run the SQL Access Advisor with a hypothetical workload
单选题 You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
Restore the backup control file and open the database with RESETLOGS option.
Perform point-in-time recovery because flashback cannot be performed again on this table
Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
多选题 What two are the prerequisites for enabling Flashback Database?() (Choose two)
The database must be in ARCHIVELOG mode
The database must be in MOUNT EXCLUSIVE mode
The database must be opened in RESTRICTED mode
The database instance must be started in the NOMOUNT state
The database instance must have the keep buffer pool defined
多选题 You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?()
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
多选题 Which two commands never trigger an implicit rebalancing within the disk group?() (Choose two.)
ALTER DISKGROUP misc MOUNT;
ALTER DISKGROUP misc DROP DISK misc2;
ALTER DISKGROUP misc CHECK ALL NOREPAIR;
ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
单选题 Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?()
a cumulative level 1 backup
a differential level 1 backup
a full backup
a whole backup
单选题 To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()
EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
Either B or C
All of the above
单选题 Performance divergence indicated in the Workload Replay report is most likely due to what?()
DML and SQL statement results that do not match between the capture and replay systems
When errors that occur in the capture system dont occur in the replay system
Top SQL statements
Infrastructure or system-configuration differences
Time-of-day differences between capture and replay systems
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()