TheSCOTTuserhasanindexontheITEM_DESCcolumnoftheITEMtable.Aspartoftheyear-endingtask，SCOTTupdatestheITEM_DESCcolumnformostoftherowsintheITEMtable.Howdoesthischangetothetableaffecttheindex？（）A.An update in a leaf row takes place.B.The index becomes invalid after the update.C.The leaf block containing the row to be updated is marked as invalid.D.A row in the leaf block of the index for the key value is deleted and inserted.

1Z0-042

单项选择题

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）

A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is deleted and inserted.

相关考题

单项选择题 Your tnsnames.ora file has the following entry for the service alias ORCL： ORCL = （DESCRIPTION = （ADDRESS = （PROTOCOL = TCP）（HOST = 10.156.24.216）（PORT = 1521））（CONNECT_DATA = （SERVER = DEDICATED）（SERVICE_NAME = orcl.oracle.com））） The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command： SQL> CONNECT scott/tiger@orcl What could be the reason for this？（）

单项选择题 Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）

多项选择题 WhichtwostatementsaboutRecoveryManager（RMAN）backupsaretrue？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064