Consider the following database query command: SELECT product_id, product_name, list_price FROM products WHERE list_price = ( SELECT MAX(list_price) FROM products ); What does MAX(list_price) perform?

Question

Answer

1.  It calculates the average list price of all products in the PRODUCTS table

Answer

4.  It counts the number of products in the PRODUCTS table that have a list price greater than zero

Answer

2.  It will return the highest list price from the PRODUCTS table

Answer

3.  It retrieves the minimum list price from the PRODUCTS table

Crowdly

Consider the following database query command: SELECT product_id, product_name, ...

Want instant access to all verified answers on exam.trendmicro.com.ph?