网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Online index rebuild functionality has been extended to include which four index structures？（）
A
Bitmap indexes.
B
Reverse key indexes.
C
Function-based indexes.
D
Key-compressed indexes on regular tables.
E
Key-compressed indexes on IOT （including secondary indexes）
参考答案
参考解析
解析：
暂无解析
更多 “多选题Online index rebuild functionality has been extended to include which four index structures？（）ABitmap indexes.BReverse key indexes.CFunction-based indexes.DKey-compressed indexes on regular tables.EKey-compressed indexes on IOT （including secondary indexes）” 相关考题
考题
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.The table does not have a primary key and is used by an OLTP application.Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A. Oracle Data Pump.B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D. Online Table Redefinition.E. Edition-Based Table Redefinition.
考题
当需要重建某个索引ix_customername,可以使用()方式。
A.ALTER INDEX ix_customername REBUILDB.ALTER INDEX ix_customername BUILDC.UPDATE INDEX ix_customername BUILDD.UPDATE INDEX ix_customername REBUILD
考题
Questions 50-52 refer to the following article.
June 14, Bangkok — There has been a growing number of online orders for American products in
Central and Southeast Asia. Thus, in response to the -------, America’s biggest online shopping site
A.declaration
B.difficulty
C.increase
D.contract
考题
A technician wants to verify a remote printer that has been power cycled is back online. Thetechnician would use which of the following commands and switch?（）A、tracert -tB、ipconfig /renewC、ping –tD、nslookup -ttl
考题
A new administrator is performing fallover testing on a two-node cluster and is concerned that the cascading resource group belonging to Node ’A’ did not reintegrate properly after the cluster was restarted on Node ’A’. A stable cluster is reported by clstat，and clRGinfo reports the resource group online on Node ’B’. What type of configuration would cause this type of behavior？（） A、 The resource group DNP has been configured.B、 The resource group option CWOF has been enabled.C、 The resource group option Inactive Takeover is set.D、 A resource group fallback timer has been configured.
考题
You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） A、 Index-organized tableB、 Mapping TableC、 Clustered TableD、 Journal Table
考题
Online index rebuild functionality has been extended to include which four index structures？（）A、Bitmap indexes.B、Reverse key indexes.C、Function-based indexes.D、Key-compressed indexes on regular tables.E、Key-compressed indexes on IOT （including secondary indexes）
考题
You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（） A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE
考题
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、 Drop and re-create the inbox.B、 Coalesce the ORDERS_IND index.C、 Coalesce the INDEXES tablespace.D、 Drop and re-create the ORDERS table.E、 Rebuild the index online and move it to another tablespace.
考题
为了监视索引的空间使用效率，可以首先分析该索引的结构，使用（）语句，然后查询INDEX_STATE视图。A、SELECT INDEX … VALIDATE STRUCTUREB、ANALYZE INDEX … VALIDATE STRUCTUREC、UPDATE INDEX … VALIDATE STRUCTURED、REBUILD INDEX … VALIDATE STRUCTURE
考题
In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（） A、 The datafiles have an ONLINE status.B、 The datafiles have an OFFLINE status.C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E、 The datafiles are in STANDBY mode.
考题
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQLCREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）A、disabling the indexB、making the index invisibleC、making the index unusableD、using the MONITORING USAGE clause for the index
考题
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA/x7f01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、drop and recreate the indexB、coalesce the ORDERS_IND indexC、coalesce the INDEXES tablespaceD、drop and recreate the ORDERS tableE、rebuild the index online and move it to another tablespace
考题
Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）A、Rebuild the index using the online option. B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least. In the ALTER INDEX statement， which option should be included？（）A、Sort in tempdb B、Online C、Fill factor D、Pad index
考题
单选题An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）A
EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.B
ALTER TABLE … COALESCE ；C
ALTER INDEX …REBUILD ONLINE；D
CREATE TABLE …AS SELECT_ONLINE；
考题
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A
Oracle Data Pump.B
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D
Online Table Redefinition.E
Edition-Based Table Redefinition.
考题
单选题You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）A
INDEX_STATSB
DBA_INDEXESC
DBA_IND_COLUMNSD
V$OBJECT_USAGE
考题
多选题In which scenarios would you rebuild an index？（）Awhen you need to disable the index usageBwhen you need to change storage optionsCwhen you need to enable index monitoringDwhen you need to move the index to another tablespace
考题
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A
The materialized view should have a complete refresh performed after the online table redefinition is completed.B
The materialized view should have a fast refresh performed after the online table redefinition is completed.C
The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
考题
多选题On a Nexus 5000 Series Switch， when a VFC is not online， what are the causes？（）ALLDP transmit and receive are disabledBThe initiator server has no connectivity to the target storageCFIP negotiation timingDPeer does not support LLDPEVSAN trunk protocol has been enabled
考题
单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）A
The datafiles have an ONLINE status.B
The datafiles have an OFFLINE status.C
The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D
The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E
The datafiles are in STANDBY mode.
考题
单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）A
Index-organized tableB
Mapping TableC
Clustered TableD
Journal Table
考题
单选题An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQLCREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task？（）A
disabling the indexB
making the index invisibleC
making the index unusableD
using the MONITORING USAGE clause for the index
考题
单选题The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）A
ALTER TABLE employees monitor index employee_idx_fk; B
ALTER INDEX employee_idx_fk monitoring on; C
ALTER TABLE employees monitor all indexes; D
ALTER INDEX employee_idx_fk monitoring usage;
考题
单选题当需要重建某个索引ix_customername，可以使用（）方式。A
ALTER INDEX ix_customername REBUILDB
ALTER INDEX ix_customername BUILDC
UPDATE INDEX ix_customername BUILDD
UPDATE INDEX ix_customername REBUILD
考题
填空题Having been badly damaged by the earthquake，the city has to be (rebuild) ____.
热门标签
最新试卷
