Oracle
1Z0-883 · Question #43
1Z0-883 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
Question
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?
Options
- AConvert the column to TEXT and add a fulltext index to the table.
- BCreate multiple prefix indexes of differing lengths.
- CConvert their column to BINARY.
- DRedesign the table so that the most commonly searched for string patterns are in their own columns.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.