多选题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.
参考解析
解析：
暂无解析
相关考题：
多选题You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area for DML and DDL StatementsELocation of a part of the runtime area for SELECT statements
多选题Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）AThe procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.BThe procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.CAll the components may be moved into SYSAUX tablespace.DAll the components may be moved from the SYSAUX tablespace.
多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatically.COMF can be used with ASM disk groups, as well as with raw devices, for better file management.DOMF automatically creates unique file names for table spaces and control files.EOMF may affect the location of the redo log files and archived log files.
多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?（）AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
多选题Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $ sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
多选题Which two are true concerning a multitenant container database with three pluggable database?（）AAll administration tasks must be done to a specific pluggable database.BThe pluggable databases increase patching time.CThe pluggable databases reduce administration effort.DThe pluggable databases are patched together.EPluggable databases are only used for database consolidation.
多选题Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）AThe %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.BThe DESCRIBE commands in SQL *Plus will not display the invisible column in the output.CReferential integrity constraint cannot be set on the invisible column.DThe invisible column cannot be made visible and can only be marked as unused.EA primary key constraint can be added on the invisible column.