Unit 8.5 Querying a database

Unit 8.5 Querying a database

By Michael Harrington

Fill in the Blanks

Show you have read the objectives - fill in the blank

Learn how to query a ?

Fill in the Blanks

Show you have read the objectives - fill in the blank

Understand the use of logical ? in framing database queries

Fill in the Blanks

Show you have read the objectives - fill in the blank

Perform a query-by-example from given search ?

Multiple Choice

Comparison operators used in queries

What does this mean?

<

• Less than

• Less than or equal to

• Greater than

• Not Equal to

• Greater than or equal to

Multiple Choice

Comparison operators used in queries

What does this mean?

>

• Less than

• Less than or equal to

• Greater than

• Not Equal to

• Greater than or equal to

Multiple Choice

Comparison operators used in queries

What does this mean?

>=

• Less than

• Less than or equal to

• Greater than

• Not Equal to

• Greater than or equal to

Multiple Choice

Comparison operators used in queries

What does this mean?

<=

• Less than

• Less than or equal to

• Greater than

• Not Equal to

• Greater than or equal to

Multiple Choice

Comparison operators used in queries

What does this mean?

>

• Less than

• Less than or equal to

• Greater than

• Not Equal to

• Greater than or equal to

Multiple Choice

Comparison operators used in queries

What does this mean?

<>

• Less than

• Less than or equal to

• Greater than

• Not Equal to

• Greater than or equal to

Open Ended

Write criteria which will list all the database records for films which have a classification of "R"

Open Ended

Write criteria which will list all the database records for films which have a classification of "R" or have a classification of "U"

Open Ended

Write criteria which will list all the database records for films released by Fox since the year 2000

Open Ended

Write criteria for a query which will list all the films seen that were released before 2006?

year 2006

(Seen is a boolean True or False)

Open Ended

Write criteria for a query which will list all the films that are from the studio "Fox" and the production cost was greater than or equal to $1,000,000

Multiple Choice

What records would this query select?

• All from studio Fox or BV and not Seen

• All from studio Fox or BV

• All from studio Fox and BV

• All from studio Fox

• All from studio BV

Multiple Choice

Which selection query would produce the most records?

1) (Production cost($m)>250) AND (Classification = “U”)

2) (Production cost($m)>250) OR (Classification = “U”)

3) (Production cost($m)>250)

4) (Classification = “U”)

• 1) (Production cost($m)>250) AND (Classification = “U”)

• 2) (Production cost($m)>250) OR (Classification = “U”)

• 3) (Production cost($m)>250)

• 4) (Classification = “U”)