Question: Use Figure 1 (Book Table) to answer the questions 9 and 10 (below two questions). Figure 1: Book Table How many tuples (rows) will the


Use Figure 1 (Book Table) to answer the questions 9 and 10 (below two questions). Figure 1: Book Table How many tuples (rows) will the following query on table BOOK return? SELECTISBN FROM BOOK WHERE Title LIKE \% \%is\%' OR Category NOT LIKE '\%ce'; Question 10 1 pts How many records (rows) will the following query on table BOOK return? SELECT DISTINCT(CATEGORY) FROM BOOK; If the result-set contains no records (i.e. empty), enter 0 as an answer. Otherwise, enter the numeric value of the number of records that will be returned
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
