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)

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!