当前位置:1z0-883题库

问题:

[单选]

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?()

A . Convert the column to TEXT and add a fulltext index to the table
B . Create multiple prefix indexes of differing lengths
C . Convert their column to BINARY
D . Redesign the table so that the most commonly searched for string patterns are in their own colum

The server host1 has been set up as a backup system with the following /etc/exports:  /backups -rw  How can a second server regularly use this disk space?()   /usr/sbin/mkfs -s 8G -o nbpi=2048,frag=512 /dev/lv00 -b -l host1。 /usr/sbin/crnfsmnt -d /backups -l /backups host1 -R -X -v -S -b bg。 /usr/sbin/mknfsmnt -f /backups -d /backups -h host1 -a -S -t rw -w bg -g。 /usr/sbin/crfs -v nfs -g vg1 -A yes -p rw -m /backups -a logname=/dev/lv00。 计量计价控制实施过程中以()为基础,对承包商完成工程量报表进行实时计量 合同工程量。 计划工程量。 预算工程量。 实际工程量。 A small company has an IBM System x3105 file server. They are looking for an alternative for tape-based backup and disaster recovery for their 80 GB of data. The backup window is 1 to 2 hours using an incremental, 3-cartridge rotation with off-site storage.  What solution fits best for this purpose? () DLTV4 internal drive。 GoVault backup drive。 LTO3 library using one drive。 LTO3 Autoloader using one 400 GB cartridge。 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 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?()

参考答案:

  参考解析

本题暂无解析

在线 客服