多项选择题
In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）
A. The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B. The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C. The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D. If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
E. Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.
相关考题
-
单项选择题
Becauseofhardwarefailure，youdecidedtodroparedologmemberfromthedatabase.Whichconditionshouldbemettodroparedologfile？（）
A. The redo log file should belong to an active group.
B. The redo log file should belong to an inactive group.
C. The redo log file should belong to the current group.
D. The redo log file can be dropped only if all the transactions are stopped.
E. Before a redo log file is dropped， it should be deleted from the operating system （OS）. -
单项选择题
You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE 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 and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that： a） No other user data in the database is affected. b） The operation takes the minimum possible time. Which option would you choose？（）
A. Use ROLLBACK command with SCN 663571.
B. Perform Flashback Transaction Query with SCN 663571.
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571. -
多项选择题
YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager（RMAN）toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers？（）
A. Backup of offline tablespaces.
B. Backup of read-only tablespaces.
C. Backup of system-critical tablespaces.
D. Backup of online， locally managed tablespaces.
E. Backup of read/write dictionary-managed tablespaces.
