Introduction to Computer Science for Grade VII

Fill in the blank: The learning material is designed for Grade ____.

• A) V

• B) VI

• C) VII

• D) VIII

The MAX function in sports scores is used to determine the _______.

• average score

• total score

• highest score

• lowest score

Which of the following is a type of SQL function?

• Aggregate Functions

• String Functions

• Date Functions

• Logical Functions

What does the SQL query 'SELECT SUM(int_price) FROM tbl_stock;' do?

• Counts the number of products

• Sums the prices of all products

• Lists all product names

• Finds the highest price.

What is the primary key column in the table 'tbl_stock'?

• pk_int_id

• vchr_product

• int_price

• tbl_stock

What does the SQL function MIN() do in the query 'SELECT MIN(int_price) FROM tbl_stock;'?

• Returns the maximum value

• Returns the minimum value

• Returns the average value

• Returns the sum of values

What is the price of the 'Pencil' in the 'tbl_stock' table?

• 10

• 14

• 2

• 6

Fill in the blank: To find the highest price in the 'int_price' column, use the SQL function ____.

• A) MAX

• B) MIN

• C) AVG