Question

1. SELECT

TITLE,

RATING,

RENTAL_RATE

FROM FILM

WHERE RENTAL_RATE > 3.99 OR RATING = 'R'

Given the query above, is it possible for a row to be returned if the value of RENTAL_RATE in the row was less than $3.99?

A. Yes

B. No

2.

SELECT

TITLE,

RATING,

RENTAL_RATE

FROM FILM

WHERE RENTAL_RATE > 3.99 OR RATING = 'R'

Given the query above, is it possible for a row to be returned if the value of RATING in the row was 'PG'?

A. Yes

B. No

3.

SELECT

TITLE,

RATING,

RENTAL_RATE

FROM FILM

WHERE RENTAL_RATE > 3.99 OR RATING = 'R'

Given the query above, the RENTAL_RATE column is most likely which data type?

A. Integer

B. Float

C. Varchar

D. Datetime

Answer 1

Dear Student ,

As per requirement submitted above kindly find below solution.

Question 1:

Answer :A. Yes

Explanation :

• In the given SQL query , in the where clause OR operator is used
• RENTAL_RATE > 3.99 OR RATING = 'R' this means when RENTAL_RATE is less than 3.99 but there might be possibility that RATING = 'R' t
• hence above SQL query will return the result.

******************************************

Question 2:

Answer :A. Yes

Explanation :

• In the given SQL query , in the where clause OR operator is used
• This means when either of one condition is true it will return the result.
• hence above SQL query will return the rows.

******************************************

Question 3:

Answer :B. Float

Explanation :

• In the given SQL query RENTAL_RATE column has the float data type.
• because for datetime needs date
• for varchar needs a value to be included in the ''
• For integer data type needs to have number.

******************************************

NOTE :PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.