Oracle
1Z0-882 · Question #59
1Z0-882 Question #59: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #59. The question stem and answer options stay visible for context.
Question
Examine this table that contains over two million rows of data: CREATE TABLE
news_feed' ( .id'bigint (20) NOT NULL AUTO _INCREMENT, .news _sources_id'varchar (11) NOT NULL, .dataline' datetime NOT NULL, .headline' varchar (256) NOT NULL, .story' text NOT NULL,.tag varchar (32768) DEFAULT NULL, PRIMARY KEY (id') KEY dateline' ( dateline') ) Examine this query that returns 332 rows of date: SELECT * FROM news_feed WHERE DATE(dateline)= `2013-01-01' Which change would show the greatest improvement in the response time of the query?Options
- AUse the LIKE operator:
- BUSE the DATEDIFF function:
- CUse numeric equivalents for comparing the two dates:
- DUse a date range comparison:
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.