Isds 3003 Final Exam Review 2023 Complete Solution

SQL views are used for all except ________ . to hide columns or rows B. to backup preexisting tables C. to display the results of computations D. to hide complicated SQL syntax E. to layer built-in functions {Ans: to backup preexisting tables}SQL stands for ________ A. Standard Question Language B. Structural Question Language C. Structured Query Language D. Structured Question Language E. Standard Query Language {Ans: Structured Query Language}Which of the following is not true about null values? A. A null value can mean that no value for the field is appropriate. B. A null value is ambiguous. C. A null value can mean that the value is unknown. D. Null values cannot be avoided. E. A null value can mean that the value is known to be blank {Ans: Null values cannot be avoided}Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of all except ________ A. less work B. greater security C. specialization among developers D. increased network throughput E. standardized processing {Ans: increases network throughput}Given the table: CUSTOMER(CustID, Name, PhoneNum, AcctBalance) what is the standard SQL query phrase to retrieve data for customers