S3 DDD Unit 2 - 3. Design

Which of the following is considered good practice when working with SQL queries?

• Planning the design of a query before creating the SQL code

• Writing SQL code without any planning

• Ignoring the structure of the database

• Only using default queries provided by the database

Why is it important to plan the design of a query before writing the SQL code?

• It helps ensure the query meets the requirements and avoids errors.

• It makes the code look more colorful.

• It reduces the size of the database.

• It automatically generates reports.

Which of the following is considered good practice before creating SQL code?

• Writing the code without any plan

• Planning the design of a query

• Ignoring the table structure

• Only using default settings

What should the "Field(s)" section in a query design table contain?

• The names of the tables used in the query

• The names of the fields you want to display, separated by comma

• The search criteria for the query

• The sort order for the results

Which logical operators can be used when searching for more than one criteria in a query?

• ADD, SUBTRACT

• AND, OR

• IF, ELSE

• SUM, AVG

What does the "Sort Order" section specify in a query design table?

• The search criteria for the query

• The field name and sort order, separated by comma

• The names of the tables used in the query

• The data type of each field

If you want to search for resorts that are islands and have a train station, which of the following would be a correct search criteria?

• resortType = "island" OR trainStation = True

• resortType = "island" AND trainStation = True

• resortType > "island"

• trainStation = False

Suppose you want to list hotel names and phone numbers in Glasgow, but sorted by phone number instead. Which part of the query would you change?

• Field(s)

• Table(s)

• Search Criteria

• Sort Order

What is the correct layout for a query design?

• Fields

  Search criteria

  Tables

  Order

• Tables

  Search criteria

  Fields

  Order

• Fields

  Tables

  Search criteria

  Order

• OrderFields

  Tables

  Search criteria

If you wanted to find hotels with a star rating of 4 or higher that offer bed and breakfast, which search criteria would you use based on the example?

• starRating >3 and mealPlan = “BB”

• starRating <3 and mealPlan = “BB”

• starRating = 3 and mealPlan = “BB”

• starRating >4 and mealPlan = “BB”