C170 Objective Assessment Exam Actual Topics With Answers

Refer to the given SQL statement. SELECT PRODNUM, PRODNAME FROM PRODUCT Which line should be added to the end of the statement to return the product numbers and product names for products that cost 20 dollars? {Ans: WHERE PRODCOST=20;}Which action deletes all rows from a table? {Ans: Omitting the WHERE clause from a DELETE statement}How is this portion of the entity-relationship diagram read, from left to right? {Ans: At least one book was written by an author.}Which command creates a database only if it does not already exist? {Ans: CREATE DATABASE IF NOT EXISTS db_name ;}What is a SQL statement? {Ans: A complete command composed of one or more clauses.}Why is a view used to give controlled access to data? {Ans: To restrict access to persons retrieving and modifying sensitive information}