Wgu - D427 - Data Management - Applications - Preassessment |66 Questions| With Correct Answers.

20. The Podcast table has the following columns: podcastID—integer, primary key, auto_increment Title—variable-length string Speaker—variable-length string Minutes—integer Write a SQL statement to delete the row with the ID value of 33 from the Podcast table. {Ans: DELETE FROM Podcast WHERE ID = 33;}Which SQL command is an example of data definition language (DDL)? - UPDATE - ALTER - SELECT - DELETE {Ans: CREATE, ALTER, OR DROP}51. Write a join statement that pulls the values listed from 3 of the tables below (Models, Model Types, Phone Numbers). model_id last_name first_name model_type_id phone_number MODELS TABLE model_id last_name first_name model_type_id MODEL TYPES TABLE model_type_id PHONE NUMBERS TABLE model_id phone_number {Ans: SELECT M.model_id, M.last_name, M.first_name, T.model_type_id, phone_number FROM Models M JOIN Model_Types T ON M.model_type_id = T.model_type_id, JOIN Phone_Numbers P ON M.model_id = P.model_id;}10. Which of the following are true about materialized view (Choose 2)? - It is a base table. - It is stored. - It must be refreshed whenever the base table changes. - The results are stored as a temporary table. {Ans: It is stored It must be refreshed whenever the base table changes}35. Which kind of relationship is displayed in the entity-relationship diagram below? - Binary