Question: Question 35 (2.5 points) Which statement is used to modify the structure of an existing table? ALTER TABLE CREATE TABLE CHANGE TABLE UPDATE Question 36




Question 35 (2.5 points) Which statement is used to modify the structure of an existing table? ALTER TABLE CREATE TABLE CHANGE TABLE UPDATE Question 36 (2.5 points) Code example 4-1 SELECT VendorName As Vendor, InvoiceDate As Date FROM Vendors AS v JOIN Invoices AS i ON v. VendorID = i. Vendor ID; (Refer to code example 4-1.) This type of join is called a/an inner join outer join left join right join Question 37 (2.5 points) When you code a union with the INTERSECT keyword to combine two result sets, the union includes only rows that occur in both result sets excludes rows from the first result set if they also occur in the second result set includes all rows that occur in both result sets if the primary keys are the same excludes rows from the second result set if they also occur in the first result set Question 38 (2.5 points) If introduced as follows, the subquery can return which of the values listed below? WHERE 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
