【单选题】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 ...
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 columns
【单选题】You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System...
A.
use the ROLLBACK command with SCN 663571
B.
perform Flashback Transaction Query with SCN 663571
C.
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D.
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
【简答题】完形填空。 Everybody knows Charles Chaplin, a world-famous funny actor. People 1 have laughed at Charles Chaplin's films until tears run 2 their faces. From his very first 3 they know what will happen. The...
【简答题】Consider the following data for a one-factor economy. All portfolios are well diversified. Portfolio E ( r ) Beta A 12% 1.2 F 6% 0 Suppose that another portfolio, portfolio E, is well diversified with...
【简答题】选词填空: retire 、 years 、 or 、 want、 different 、 Some of the parents want their kids to be businessmen 6 doctors. If they work hard, they will have cars and big houses in several 7 . Some parents want ...
【简答题】请大家直接按顺序填写字母,不要加题号,不要出现其它格式,否则系统不认。 extension 2. sample 3.negotiation 4.directory 5. switchboard 6.rush order 7.cellphone 8. IDD code 9.area code 选项见下: A. telephone dialing prefix that people have to ...