多选题 You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
All the objects of scott are moved to the Recycle Bin.
Any objects in the Recycle Bin belonging to scott are purged.
All the objects owned by scott are permanently dropped from the database.
All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
多选题 Which Scheduler view(s) can be queried to see which jobs are currently executing? ()
DBA_SCHEDULER_JOB_RUN_DETAILS
DBA_SCHEDULER_RUNNING_JOBS DBA
DBA_SCHEDULER_CURRENT_JOBS
DBA_SCHEDULER_JOBS DBA
DBA_SCHEDULER_EXECUTING_JOBS
单选题 Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()
SQL statements that are part of the AWR baseline only
SQL statements based on the AWR top SQL identification
SQL statements that are part of the available SQL Tuning Set (STS) only
SQL statements that are available in the cursor cache and executed by a user other than SYS
单选题 An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?()
TEST_TBS is a small file tablespace.
TEST_TBS is a bigfile tablespace (BFT).
TEST_TBS is the default temporary tablespace.
TEST_TBS is a dictionary-managed tablespace.
单选题 After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
Opening the database in RESTRICTED mode
Opening the database with the RESETLOGS option
Setting a new DBID for the newly restored database
Restoring the server parameter file (SPFILE) to the new host
单选题 You executed the following commands in an RMAN session for your database instance that has failures: RMAN> LIST FAILURE; After some time, you executed the following command in the same session: RMAN> ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()
It produces a warning for new failures before advising for CRITICAL and HIGH failures.
It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
单选题 Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
The shrink operation touches every block in the BOOKING table
The high-water mark (HWM) for the BOOKING table is shifted from its original position
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题 A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: What happens when the whole CONTROLLER1 Failure group is damaged?()
The transactions that use the disk group will halt.
The mirroring of allocation units occurs within the CONTROLLER2 failure group.
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
单选题 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? ()
Check the alert log file
Query the V$FLASHBACK_DATABASE_LOG view
Query the V$RECOVERY_FILE_DEST_SIZE view
Query the V$FLASHBACK_DATABASE_STAT view
Check the value assigned for the UNDO_RETENTION parameter
在任何情况下,伸缩调节器处轨距的要求为()。
人类有两套影响学习的记忆系统:陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆,就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式,比如骑自行车。在很多时候,这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西,比如语法规则。帮助人们学习词汇的陈述性记忆系统,则需要更多时问完成发育。儿童拥有程序记忆系统,并且不受陈述性记忆系统的干扰。由此可以推出()。
宋末元初四大家
公平目标的实现可以通过()实现。
荟萃分析
人员安全疏散分析的性能判定标准为:可用疏散时间(A.SET)必须()必需疏散时间(RSET)。
预防HIV感染的主要措施应当为( )
简述我国混合型债券市场的发展状况。
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指()
输血的适应证中,不包括()