多选题
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
Redo logs
Control file
The latest backup of only the damaged data file
The latest backup of all the data file in the USERS tablespace
Temporary files of temporary tablespace
Archive Logs since the latest backup to point of failure
单选题
You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks（）？
ALTER DISKGROUP data CHECK
ALTER DISKGROUP data CHECK DISK
ALTER DISKGROUP data CHECK FILE
ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
多选题
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）
You can add or remove the trace files to the package.
You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
You can add SQL test cases to the incident package.
You cannot create an incremental incident package when the physical files are purged rom the ADR.
多选题
Which two statements about workload capture and replay operations are true？（）
The clients must be created manually on the test machines to perform more realistic testing.
Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
单选题
Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogs
b， a， c， d， e
a， c， b， d， f
c， a， b， d， e
c， a， b， d， f
e， a， b， d， c
多选题
Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）
It is used to change failure priority only for HIGH or LOW priorities.
It is used to execute the advised repair script.
It is used to change failure priority only for the CRITICAL priority.
It is used to explicitly close the open failures.
It is used to inform the database about the repair after the repair script executes.
单选题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
Restore and recover the datafile.
Restore and recover the tablespace.
Restore and recover the database.
Restore and recover the control file.
Restore and recover the parameter file.
单选题
Your database initialization parameter file has the following entry： SEC_MAX_FAILED_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting？（）
It drops the connection after the specified number of login attempts fail for any user.
It is enforced only if the password profile is enabled for the user.
It locks the user account after the specified number of attempts.
It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
多选题
Which three are the valid statements in relation to SQL plan baselines？（）
The plans can be manually loaded to the SQL plan baseline.
The plans in the SQL plan baseline are verified and accepted plans.
The plans generated for every SQL statement are stored in the SQL plan baseline by default.
The plan baselines are stored temporarily in the memory as long as the database instance is running.
For the SQL plan baselines to be accessible to the optimizer， the SYSAUX tablespace must be online.
单选题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）
point-in-time recovery
execute the ROLLBACK command with transaction number
flashback the database to before the transaction was committed
determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）