问题：
[单选题]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.
参考答案：
D
相关内容
- ● Which router or router combination i ued to calculate the MPLS traffic engineering tunnel path？（）
- ● An adminitrator ha a Power 570 in default configuration with a 4 port 1 Gbp Integrated Virtual Ethernet (IVE) adapter. A new application require that the MCS value for the firt port group of the IVE adapter be et to 1. If thi change i made, what i the maximum number of logical port, acro both port group, that the IVE adapter can provide?（）
- ● You are hrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE tatement. What i a prerequiite for hrinking the SCOTT.EMP table？（）
- ● Uer SCOTT want to back out the tranaction on the REGIONS table in hi chema. A a DBA， which command mut you execute to enable SCOTT to flah back the tranaction？（）
- ● What will be the reult of uing the SQL> DROP USER SCOTT CASCADE； command？（）
- ● The SCOTT uer ha an index on the ITEM_DESC column of the ITEM table. A part of the year-ending tak， SCOTT update the ITEM_DESC column for mot of the row in the ITEM table. How doe thi change to the table affect the index？（）
- ● You are performing the hrink operation on the SCOTT.EMP table. You want to perform the ame operation on all dependent object of the SCOTT.EMP table. What i NOT a prerequiite for the operation？（）
- ● You are maintaining your databae in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， i dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not ue RMAN to perform backup. You performed the lat full uer-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）
- ● View the Exhibit to examine the output produced by the following query at three different time ince thedatabae intance tarted and ha experienced workload of different capacitie：SQL> SELECT ubtr（component， 0， 10） COMP， current_ize CS， uer_pecified_ize US FROM v$memory_dynamic_componentWHERE current_ize!=0；What do you infer from thi（）
- ● An application i upgraded and it ha been determined that the AcceAgent no longer properly repond to the application. It i undertood that for a certain amount of time both the current verion and the upgraded verion of the application will be ued by the end-uer. The executable for both verion are the ame. What hould be the next tep？（）
- ● A uer on your network download a video card driver from the Internet. You are unure of the ource of the driver. You want to enure that the uer doe not loe production time becaue of an incompatible driver. What hould you do?（）
- ● A ingle 802.11g acce point ha been configured and intalled in the center of a quare office. A few wirele uer are experiencing low performance and drop while mot uer are operating at peak efficiency. What are three likely caue of thi problem? (Chooe three.) （）
