Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?() Convert the column to TEXT and add a fulltext index to the table。 Create multiple prefix indexes of differing lengths。 Convert their column to BINARY。 Redesign the table so that the most commonly searched for string patterns are in their own colum。
掠夺性定价
Which command will enable RBAC on a server?() setkst -t enable ; reboot。 chrbac -a enable ; reboot。 enable enhanced_RBAC ; reboot。 chdev -l sys0 -a enhanced_RBAC=’true’ ; reboot。
Your end user customer has not requested a ServicePac to cover the base unit and options they have purchased. What is a compelling reason to offer service? () IBM ServicePacs remove a liability from you the reseller in the event of fire。 IBM ServicePacs remove a liability from you the reseller in the event of flooding。 IBM ServicePacs provide improved warranty coverage。 Service just adds a layer of cost you do not need。 all of the above。
当受力超过一定的限度时自动打滑的离合器是() 侧齿式离合器。 内齿离合器。 摩擦离合器。 柱销式离合器。
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()