black

1Z0-042

登录

单项选择题

The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()

A.B-tree
B.bitmap
C.reverse key
D.function based

相关考题

单项选择题 Your alert log file has the following information: Tue May 25 17:43: 38 2004  ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly?()

单项选择题 Youspecifiedsegmentspacemanagementasautomaticforatablespace.Whateffectwouldthishaveonspacemanagement?()

单项选择题 The user SCOTT executes the following command successfully to increase the salary values in one of his sessions:  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20;  Before SCOTT ends the transaction, user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064