多选题
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
The SKD user cannot log in to the database instance.
The objects owned by the SKD user are not accessible to any user.
The other users can access the objects owned by the SKD user， on which they have access.
The password for the SKD user expires and the user is forced to change the password at the next log in.
单选题
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces. What happens to the new DML operations in this scenario（）
The DML commands will fail.
The undo data generated by the DML is stored in one of the two other undo tablespaces.
The undo data generated by the DML will overwrite the extents that contain committed undo data.
The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace
多选题
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
Flashback log files
Backups that have become obsolete
User managed backups of the data files and control files
Archived redo log files that have multiple copies in a different archive location and not backed up
多选题
You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）
The backup performed on Sundays contains all the blocks that have ever been used in the database.
The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
The backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup
多选题
Which two statements are true regarding undo tablespaces（）
The database can have more than one undo tablespace.
The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
单选题
our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）
The command succeeds only if Automatic Memory Management is not enabled.
The command succeeds， but you need to restart the database for changes to take effect.
The command returns an error because the size of the redo log buffer cannot be changed dynamically.
The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）
多选题
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）
data files
control files
parameter file
online redo log files
server parameter file
单选题
Given below is a list of scenarios： 1）A user terminates his session abnormally. 2）The connection between the server and the client application terminates because of a network failure. 3）A schema is accidentally dropped. 4）The tablespace is accidentally dropped from the database. 5）The hard disk gets corrupted and the data files in the disk are lost. 6）The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery（）
4 and 5
1，3，and 6
4，5，and 6
3，4，and 5
1，2，and 6
单选题
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of theincident（）
The DBA is working on the incident and prefers that the incident be kept in the ADR.
The incident is now in the Done state and the ADR can select the incident to be purged.
The incident has been newly created and is in the process of collecting diagnostic information.
The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport
多选题
Which statements are true regarding the Oracle Data Pump export and import operations（）
You cannot export data from a remote database.
You can rename tables during an import operation.
You can overwrite existing dump files during an export operation.
You can compress the data during export but not the metadata because it is not supported
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）