short Answer Instructions: Answer each question to the best of ability in the sp

Question

short Answer Instructions: Answer each question to the best of ability in the space provided. Spelling and syntax will be graded carefully. Partial credit will be given. Each question is worth 5 points 1. How would you create a new table containing the category code and description for the categories of books sold by JustLee and the columns should be catcode and CatDesc. Books? The table should be called CATEGORY, catcode should store a max of 5 characters and catDesc should store a max of 12 characters. 2. How would you rename the EMPLOYEES table as JUSTLEE EMP? 3. How would you change the zip code on order 1001 to 35801? 4. How would you delete customer 1020 from the customers table?

Explanation / Answer

2. RENAME TABLE EMPLOYEES TO JUSTLEE_EMP;

4. DELETE FROM CUSTOMERSTABLE WHERE CUSTOMER_ID=1020;

5.SELECT * FROM AUTHORS;

10.DROP DATABASE JUSTLEE;

3.ALTER TABLE ORDER WHERE ORDER_ID=1001 TO 35801;

7.SELECT * FROM BOOKTITLES WHERE PROFIT=12;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.