Question

List all the movies that have length less than 100 and were produced by a studio name other than 'Fox'. Select the right answer.

Select one:
a. Selection NOT(length=100) AND NOT(studioName='Fox')(Movies)
b. Selection NOT(length=100 OR studioName='Fox')(Movies)
c. None of the others
d. Selection length<100 AND studioName <>'Fox'(Movies)

Answer 1

The correct option is d. Selection length<100 AND studioName <> 'Fox'(Movies), which selects all movies under 100 minutes in length and not produced by 'Fox'.

Step-by-step explanation:

The student is asking how to express a query that would list all movies with a length of less than 100 minutes, excluding those produced by the studio 'Fox'. The correct answer to this question is d. Selection length<100 AND studioName <>'Fox'(Movies). This is because we want to ensure that we're selecting all movies that meet two criteria: the first is that the movie has a length of less than 100 minutes and the second is that it wasn't produced by 'Fox'. We use '<100' to specify that the length should be less than 100, and '<>' to indicate that the studio name should not be equal to 'Fox'.