多选题Which two statements are true about variable extent size support for large ASM files?（）AThe metadata used to track extents in SGA is reduced.BRebalance operations are completed faster than with a fixed extent sizeCAn ASM Instance automatically allocates an appropriate extent size.DResync operations are completed faster when a disk comes online after being taken offline.EPerformance improves in a stretch cluster configuration by reading from a local copy of an extent.
多选题
Which two statements are true about variable extent size support for large ASM files?（）
A
The metadata used to track extents in SGA is reduced.
B
Rebalance operations are completed faster than with a fixed extent size
C
An ASM Instance automatically allocates an appropriate extent size.
D
Resync operations are completed faster when a disk comes online after being taken offline.
E
Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
参考解析
解析：
暂无解析
相关考题：
单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）ADecreasing PCTUSEDBDecreasing PCTFREECIncreasing the number of DBWN processDUsing Automatic Segment Space Management (ASSM)EIncreasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）ASet DB_FLASH_CACHE_SIZE=64GBSet D3_FLASH_CACHE_SIZE=64G, 64GCSet D3_FLASK_CACKE_SI2E=128GDdb_flash_cache_SI2E is automatically configured by the instance at startup
多选题On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）AOnly the ORD_CUSTOMER_IX1 index created.BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
多选题What are three purposes of the RMAN “FROM” clause?（）Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo support file restores over the network in a Data Guard environmentETo support file recovery over the network in a Data Guard environment
多选题Which two statements are true about the RMAN validate database command?（）AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect corrupt block change tracking files.