Question

1.2) (5 Points) For each of the following statements, mark T (True) or F (False) SELECT DISTINCT is used if a user does not want to see duplicate rows in a query. T F TF Consider the following SQL statement: SELECT pred price * pred quant as total cost FROM Product; The output of this query is a table with two columns. You can create a View if you do not want users to see all the attributes of a single or joined tables T F A super key identifies unique rows in the table. T F 1 P a T F If a salesperson attempts to enter information in INVOICE table for a customer not in the CUSTOMER table, the database will typically generate an error message. This message indicates that a referential integrity constraint has been violated.

Answer 1

>>Answer

>>Given That

SELECT DISTINCT is used if a user does not want to see duplicate rows in a query - TRUE
DISTINCT is used to show only unique records
============================
The query SELECT prod_price * prod_quantity as total_cost FROM Product. The output has two columns - FALSE

The product of price and quantity is named as total_cost and is display as a single column
=====================

You can create a View if you do not want users to see all the attributes of a single or joined tables - TRUE
================
A super key identifies unique rows in the table - TRUE

============================
If a salesperson attempts to enter information in INVOICE table or a customer not in the CUSTOMER table,
the database will typically generate an error message. This message indicates that a referential integrity
constraint has been violated - TRUE