Assignment 4 - Chapter 7 Worksheet (1).docx

Complete the following three sql commands grant all

This preview shows page 5 - 8 out of 8 pages.

Complete the following three SQL commands: GRANT ALL ON ???? TO ????; GRANT ALL ON ???? TO ????; GRANT ALL ON ???? TO ????;
Image of page 5

Subscribe to view the full document.

5. (3 pts) COMPLETE, but do not execute, the command to revoke all privileges from user Andrews. Complete the following SQL command: REVOKE ALL PRIVILEGES FROM ????; 6. COMPLETE, but do not execute, the commands to create the following indexes. The section “Security” in your eBook (Chapter 7, page 209) contains a number of related examples on the INDEX command. a. (3 pts) Create an index named TRIP_INDEX1 on the TRIP_NAME column in the TRIP table. Complete the following SQL command: CREATE INDEX ???? ON TRIP(????); b. (3 pts) Create an index named TRIP_INDEX2 on the TYPE column in the TRIP table. Complete the following SQL command: CREATE INDEX ???? ON TRIP(????); c. (3 pts) Create an index named TRIP_INDEX3 on the LAST_NAME and FIRST_NAME columns in the CUSTOMER table. Complete the following SQL command: CREATE INDEX ???? ON ????(????, ????); 7. (3 pts) COMPLETE, but do not execute, the commands to delete the index named BOOK_INDEX3. Complete the following SQL command: DROP INDEX ????; 8. WRITE and EXECUTE the SQL commands to obtain the following information from the system catalog. The section “System Catalog” in your eBook (Chapter 7, page 212) contains a number of related examples on the SQL commands that obtain information from the system catalog. Please note that all SQL examples in the this section of the eBook obtain information from “DBA” tables. In all of the following questions “DBA” has been changed to “ALL” in order to allow your SQL commands to execute properly. a. (3 pts) List every column (i.e., COLUMN_NAME) in the GUIDE table and its associated data type (i.e., DATA_TYPE) . Put your SQL command and results here:
Image of page 6
b. (3 pts) List every table (i.e. TABLE_NAME) that contains a column (i.e., COLUMN_NAME) that is named TRIP_ID.
Image of page 7

Subscribe to view the full document.

Image of page 8
  • Fall '18
  • Mrs. Kim

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern