Oracle
1Z0-882 · Question #28
1Z0-882 Question #28: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #28. The question stem and answer options stay visible for context.
Question
You execute this EXPLAIN statement for a SELECT statement on the table named comics.which contains 1183 rows: Mysql> explain select comic_ title, publisher from comics where comic_title like
& Action&'; row in set (0.00 sec) You create the following index: CREATE INDEX cimic_title_idx ON comics (comic_title, publisher); You run the same EXPLAIN statement again; Mysql > explain select comic_title ,publisher from comics where comic_title like & Action&'; 1 row inset (0.00 sec) Why didthe second SELECT statement need to read all 1183 rows in the index comic_title_idx?Exhibits
Options
- ABecause comic_title is not the primary key
- BBecause a LIKE statement always requires a full tables scan
- CBecause comic _title is part of acovering index
- DBecause a wildcard character is at the beginning of the search word
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.