QUESTION 18 The maximum value that can be stored by defining an attribute as NUMBER (5,3) is O a. 99.999 O b. 9.999 Oc. 99999.999 O d. 55.333 QUESTION 19 ... will change department ID 20 of employee table to 15. O a. UPDATE Employee SET Department ID = 15 WHERE Department ID = 20; !! UPDATE Employee SET Department ID = 20 WHERE Department ID = 15; Ob. Oc. UPDATE Employee SET Department_ID = 20: Od UPDATE Employee SET Department_ID = 15

What is the main difference between the set operators and the join?

PLZ HELP WITH THE FOLLOWING: make the following work select MOVIE_NAME, MOVIE_YEAR from MOVIE where  MOVIE_COST > (select a.MOVIE_COST from MOVIE a, PRICE b where a.PRICE_CODE = b.PRICE_CODE and b.PRICE_DESC ="weekly Special");   CREATE TABLE MEMBERSHIP (   MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEMNUM_PK PRIMARY KEY,   MEM_FNAME VARCHAR(30) NOT NULL,   MEM_LNAME VARCHAR(30) NOT NULL,   MEM_STREET VARCHAR(30),   MEM_CITY VARCHAR(10),   MEM_STATE CHAR(2),   MEM_ZIP CHAR(5),   MEM_BALANCE NUMBER(2) );   CREATE TABLE RENTAL (   RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENTNUM_PK PRIMARY KEY,   RENT_DATE DATE,   MEM_NUM CHAR(3),   CONSTRAINT RENTAL_MEMNUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP );   CREATE TABLE PRICE (   PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICECODE_PK PRIMARY KEY,   PRICE_DESC VARCHAR(20),   PRICE_RENTFEE NUMBER (3, 1),   PRICE_DAILYATFEE NUMBER(3, 1) );   CREATE TABLE MOVIE (   MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIENUM_PK PRIMARY KEY,   MOVIE_NAME VARCHAR(30) NOT NULL,…

Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator.   Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000.     List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron.       Down below are the tables ORDER_LINE ORLN_ORDER_NUMBER               ORLN_PART_NUMBER ORLN_NUMBER_ORDERED          ORLN_QUOTED_PRICE   ORDER_TABLE ORDR_ORDER_NUMBER               ORDR_ORDER_DATE               ORDR_CUSTOMER_NUMBER   CUSTOMER CUST_NUMBER CUST_LAST         CUST_FIRST        CUST_STREET     CUST_CITY          CUST_STATE        CUST_ZIP_CODE               CUST_BALANCE CUST_CREDIT_LIMIT       CUST_SALES_REP_NUM               PART PART_NUMBER  PART_DESCRIPTION         UNITS_ON_HAND…