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 thestructure of an existing table? ALTER TABLE CREATE TABLE CHANGE TABLE UPDATEQuestion 36 (2.5 points) Code example 4-1 SELECT VendorName As Vendor, InvoiceDateAs Date FROM Vendors AS v JOIN Invoices AS i ON v.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!