MIS 330 EXAM 2 QUESTIONS WITH CORRECT ANSWERS

(T/F) You can use comparison operators to test for NULL values.


Give this one a try later!


FALSE




The below command is an example of (DDL/DML/DCL):


SELECT studentID
FROM Student;


Give this one a try later!


DML

, What is the statement to empty certain data from a table without dropping the table
completely?


Give this one a try later!


DELETE FROM [table name]




What does a LEFT OUTER JOIN do?


Give this one a try later!


LEFT OUTER JOIN returns all the rows from the first table, even if there are
no matches in the second table.




Display the ProductID, ProductName, and ProductPrice for products with a
ProductPrice of $100 of higher


Give this one a try later!


SELECT productid, productname, productprice
FROM product
WHERE productprice >= 100;




What does an INNER JOIN do?


Give this one a try later!