Lesson 24: Using Data to Create New Information

What is the purpose of adding an extra column in a query?

• To delete data

• To create a new database

• To make query more fun

• To display additional information

What is the heading of the extra column in the query?

• Value

• Total

• Price

• Stock Amount

What does "Using Data to Create New Information" mean?

• Writing a story about data

• Using data to make graphs

• Using data to generate new insights

• Both B and C

Which columns are used to create a new query in a database?

• Text and number columns

• Date and time columns

• Any relevant columns needed for the query

• Only primary key columns

What should you do when you want to multiply two numbers in a computer query?

• Use the letter "x"

• Use the letter "m"

• Use the sign "+"

• Use the sign "*"

What happens if values in the database change, but you don't rerun the query?

• The database becomes corrupted

• The query stops working

• The result in the query remains the same

• The database gets deleted

What kind of information does an expression provide?

• Data from another database

• New information

• Historical data

• Personal opinions

Why doesn't it matter if values change in the database when using expressions?

• Because each time the query is run, the totals will update

• Because the database cannot be changed

• Because the expression always returns the same result

• Because the database becomes read-only

Why is it important to use expressions in a database?

• To make the database more colorful

• To create new columns

• To perform calculations and generate new information

• To delete unnecessary data

What does an expression do in a database query?

• It stores data permanently

• It performs calculations to provide new information

• It deletes data from the database

• It changes the database structure