Answer these question bellows. 1. A developer looking to create an inventory sheet wants every inventory item listed with every location. Which query will produce the desired results? A. SELECT product from products CROSS JOIN location from locations B. SELECT product from products LEFT OUTER JOIN location from locations ON products.product = locations.location C. SELECT product from products FULL OUTER JOIN location from locations ON products.product = locations.location D. SELECT product from products INNER JOIN location from locations ON products.product = locations.location 2. For each of the following statements, select Yes if the statement is true or No if the statement is false. The ALTER TABLE command can add a new column. (YES) The ALTER TABLE command can change the IDENTITY specification of an existing column.(NO) The ALTER TABLE command can drop multiple columns from a table. (YES) The ALTER TABLE command can modify the data type of an existing column. (YES) 3. Match each database component to its function. Instructions: To answer, drag the database component from the column on the left to its correct function on the right. Each database component may be used once, more than once, or not at all. (ROW) : A group of database items listed left to right (horizontally) (COLUMN) : A group of items listed up and down (vertically) (FIELD) : A location in a record in which a particular type of data is stored. (ENTITIY) : A table of rows and columns. Used to store and organize data. 4. A school database needs a table that holds the student who signed up for a class, the class the student signed up for, and the signup date. The studentID and classID fields are to be used as a composite key for the table. Which statement accurately creates the table and fulfills the requirements for making each record unique? A. CREATE TABLE Signups ( studentID varchar (5) UNIQUE NOT NULL classID varchar(5) UNIQUE NOT NULL signupdate DATETIME primary key (studentID, classID) ) B. CREATE TABLE Signups ( studentID varchar (5) UNIQUE NOT NULL classID varchar (5) UNIQUE NOT NULL signupdate DATETIME composite key (studentID, classID) ) C. CREATE TABLE Signups (studentID varchar (5) UNIQUE NOT NULL primary key studentID classID varchar (5) UNIQUE NOT NULL signupdate DATETIME primary key classID ) D. CREATE TABLE Signups ( studentID varchar (5) UNIQUE NOT NULL classID varchar (5) UNIQUE NOT NULL signupdate DATETIME primary keys (studentID, classID) ) 5. A sales manager wants to see all customers with sales of at least 50000 who either reside in Los Angeles, California, or in the states of Nevada or Arizona. Which SQL statement will satisfy the request? A. SELECT lastname, firstname FROM customers WHERE sales >=50000 OR ((city= 'Los Angeles' AND state='California') OR state IN ('Nevada', 'Arizona')) B. SELECT lastname, firstname FROM customers WHERE sales >50000 AND ((city= 'Los Angeles' AND state='California') OR state IN ('Nevada', 'Arizona')) C. SELECT lastname, firstname FROM customers WHERE sales >=50000 AND ((city= 'Los Angeles' AND state='California') OR state IN ('Nevada', 'Arizona')) D. SELECT lastname, firstname FROM customers WHERE sales >50000 OR ((city= 'Los Angeles' AND state='California') AND state IN ('Nevada', 'Arizona'))