CS 6441

George Washington University Quiz2_merged.V8 Database Management Systems_CSCI_6441 (with all correct answers shown)

George Washington University Quiz4_merged Database Management Systems_CSCI_6441 (with all correct answers shown)

Which code returns the date in the format Friday, April 20th, 2019? DATE_FORMAT('2019-04-20', '%W, %M %D, %Y') DATE_FORMAT('2019-04-20', '%W, %M %D, %Y') Question 2 Selected Answer: Correct Answer: Which statement is NOT CORRECT? The management of data storage is more expensive than the purchase of storage hardware, which is why businesses opt for enterprise storage subsystems. Although SCSI has been a popular medium for connecting storage devices to servers and/or processors ...

Question 1. When could an index decrease the speed of a query? A. The table is small. B. The column is used in a WHERE clause. C. The column contains a wide range of values. D. The column contains a large number of null values. Ans: A Question 2. What is the syntax for removing a PRIMARY KEY constraint and all its dependent constraints? A. ALTER TABLE table_name DROP PRIMARY KEY CASCADE; B. ALTER TABLE table_name REMOVE CONSTRAINT PRIMARY KEY CASCADE; C. ALTER TABLE table_name DISA...

ALL CORRECT ANSWERS ARE SHOWN Question 1 Selected Answer: Correct Answer: Which set operator would you use to display the employee IDs of employees hired after January 10, 2007 in the EMP table and employee IDs of employees who have held more than one position in the EMP_HIST table, eliminating any duplicate IDs? INTERSECT UNION Question 2 Selected Answers: Correct Answers: Which three statements concerning explicit datatype conversions are TRUE? (Choose three.) A character value may...

Question 1 Selected Answer: True Correct Answer: False Cloud developers create applications and host them on SaaS provider sites, which provide an operating environment and hardware. Question 2 Selected Answer: Correct Answer: C. SaaS _____________ a complete software application with a user interface. C. SaaS 0 out of 0.5 points 0.5 out of 0.5 pointsCorrect Answer: C. SaaS Question 3 Selected Answer: a. Correct Answer: a. Response Feedback: Which statement would you use to mi...

Click the Exhibit(s) button to examine the structure of the PRODUCT table. Evaluate this SQL statement: SELECT supplier_id, AVG(cost) FROM product WHERE AVG(list_price) > 60.00 GROUP BY supplier_id ORDER BY AVG(cost) DESC; Which clause will cause an error? SELECT WHERE GROUP BY ORDER BY Answer: WHEREExplanation: The WHERE clause will cause an error when this SELECT statement is executed. Groups can only be restricted with a HAVING clause. Including a group, or aggregate, funct...