Question

Test time remaining
00:48:52
FYTQ MOCK TEST 30 Mar
-otion 1 of 1
+1 -0
Question 15
Consider a table order with attributes orderid(primary key), customerid; orderdate, quantity
price and category Columns customerid, orderdate, quantity and price are non unique. The
table has two explicit indexes as follows: IDX1- quantity IDX2 - customerid, orderdate Which of
the following queries will not result in Table Scan?
WHERE LOWER(category) = 'stationary
Minnings ann
WHERE customerid > C1001 AND
-SOLAADLO
Previous
Mark​

Answer 1

Answer

WHERE cutomerid <>'C1001' AND orderdate='30-MAR-2018

WHRE customerid='C1005' OR quality>10.

Answer 2

Answer:

Option 1 and Option 3 contain columns with no indexes, so the entire table must be searched in the worst case scenario.

Explanation:

The primary key will also be used to build implicit indexes by default (custom). Option 1 and Option 3 contain columns with no indexes, so the entire table must be searched in the worst case scenario. Option 2 and Option 4 both have columns for which the database search engines can retrieve data either explicitly or implicitly. Indexes allow us to retrieve certain rows from a table without having to search the entire table. Given that explicit quantity and quality indices are produced (customised, order date). When a table is built by default, implicit indexes based on the primary key are also created (customised). Option 1 and Option 3 contain columns with no indexes, so the entire table must be searched in the worst case scenario.