A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 7, Problem 8TD
Write the commands to obtain the following information from the system catalog. Do not execute these commands unless your instructor asks you to do so.
- a. List every table that you own.
- b. List every column in the ITEM table and its associated data type.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
List all the views contained within the system catalog.
Write the command to display only tables within the system catalog that are of the type BASE TABLE. Display only the following columns: TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE.
What command has to be executed so that data may be copied and pasted from one table to another?
Task 13: Write the command to display only tables within the system catalog that are of the type BASE TABLE. Display only the following columns: TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE.
1
Task 14: Create an index named ITEM_INDEX1 on the ITEM_ID column in the INVOICE_LINE table.
1
Task 15: Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEM table.
1
Task 16: Create an index named ITEM_INDEX3 on the CATEGORY and LOCATION columns in the ITEM table.
1
Task 17: Create an index named ITEM_INDEX4 on the CATEGORY and LOCATION columns in the ITEM table. List categories in descending order.
1
Task 18: Delete the index named ITEM_INDEX3.
1
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns.
1
Task 20: List every column in the ITEM table and its associated data type.
1
Task 21: Alter the INVOICE_LINE table by adding…
Chapter 7 Solutions
A Guide to SQL
Ch. 7 - What is a view?Ch. 7 - Which command creates a view?Ch. 7 - Prob. 3RQCh. 7 - What happens when a user retrieves data from a...Ch. 7 - What are three advantages of using views?Ch. 7 - Which command deletes a view?Ch. 7 - Prob. 8RQCh. 7 - Which command terminates previously granted...Ch. 7 - Prob. 10RQCh. 7 - How do you create an index? How do you create a...
Ch. 7 - Prob. 12RQCh. 7 - Does the DBMS or the user make the choice of which...Ch. 7 - Describe the information the DBMS maintains in the...Ch. 7 - The CUSTOMER table contains a foreign key,...Ch. 7 - Prob. 16RQCh. 7 - Prob. 17RQCh. 7 - Prob. 18RQCh. 7 - Prob. 19RQCh. 7 - When would you usually specify primary key...Ch. 7 - Prob. 21RQCh. 7 - Prob. 22RQCh. 7 - Prob. 23RQCh. 7 - Use SQL to make the following changes to the TAL...Ch. 7 - Create a view named ITEM_ORDER. It consists of the...Ch. 7 - Create a view named ORDER_TOTAL. It consists of...Ch. 7 - Write, but do not execute, the commands to grant...Ch. 7 - Prob. 5TDCh. 7 - Perform the following tasks: a. Create an index...Ch. 7 - Delete the index named ITEM_INDEX3.Ch. 7 - Write the commands to obtain the following...Ch. 7 - Prob. 9TDCh. 7 - Prob. 10TDCh. 7 - Toys Galore currently has a credit limit of 7,500....Ch. 7 - Use SQL to make the following changes to the...Ch. 7 - Create a view named RESERVATION_CUSTOMER. It...Ch. 7 - Create a view named TRIP_INVENTORY. It consists of...Ch. 7 - Write, but do not execute, the commands to grant...Ch. 7 - Prob. 5CATCh. 7 - Create the following indexes: a. Create an index...Ch. 7 - Prob. 7CATCh. 7 - Write the commands to obtain the following...Ch. 7 - Prob. 9CATCh. 7 - Ensure that the only legal values for the TYPE...Ch. 7 - Prob. 11CATCh. 7 - Use SQL to make the following changes to the...Ch. 7 - Create a view named CONDO_OWNERS. It consists of...Ch. 7 - Create a view named CONDO_FEES. It consists of two...Ch. 7 - Write, but do not execute, the commands to grant...Ch. 7 - Prob. 5SCGCh. 7 - Prob. 6SCGCh. 7 - Delete the OWNER_INDEX 3 index from the OWNER...Ch. 7 - Write the commands to obtain the following...Ch. 7 - Prob. 9SCGCh. 7 - Ensure that the only legal values for the BDRMS...Ch. 7 - Prob. 11SCG
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Compile and run the sample code that uses show_bytes (file show-bytes. c) on different machines to which you ha...
Computer Systems: A Programmer's Perspective (3rd Edition)
Categorize each of the following items as either hardware or software: CPU C++ compiler ALU C++ preprocessor in...
C How to Program (8th Edition)
In Exercises 1 through 22, determine the output displayed in the text box or list box by the lines of code.
Introduction to Programming Using Visual Basic (10th Edition)
(Display three messages) Write a program that displays Welcome to Java, Welcome to Computer Science, and Progra...
Introduction to Java Programming and Data Structures, Comprehensive Version (11th Edition)
In the following field declaration from the TicketMachine class private int price; does it matter which order t...
Objects First with Java: A Practical Introduction Using BlueJ (6th Edition)
The following C++ program will not compile because the lines have been mixed up. cout Success\n; cout Success...
Starting Out with C++ from Control Structures to Objects (8th Edition)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
Write the commands to obtain the following information from the system catalog. Do not execute these commands unless your instructor specifically asks you to do so. a. List every column in the CONDO_UNIT table and its associated data type. b. List every table that contains a column named OWNER_NUM.
arrow_forward
Write the commands to obtain the following information from the system catalog. Do not execute these commands unless your instructor asks you to do 30. a. List every column in the GUIDE table and its associated data type. b. List every table that contains a column named TRIP_ID. c. List the table name, column name, and data type for the columns named TRIP_ID,TRIP_NAME, and TYPE. Order the results by table name within column name. (Thatis, column name is the major sort key and table name is the minor sort key.)
arrow_forward
Are a table and the data contained in the table erased from the system permanently if a DROP TABLE command is issued on the table?
arrow_forward
write a trigger that will be activated after a DELETE activity. The trigger will INSERT all deleted data to a backup table having same attributes as original table
arrow_forward
A specific command is required in order to copy data inside tables as well as copy data across tables.
arrow_forward
Write and execute the command to retrieve the customer ID, first name, and last name of each customer in the MAJOR_CUSTOMER VIEW with a balance that exceeds the credit limit.
arrow_forward
Write the SQL commands to obtain the following information from the system catalog:a. List every table that you created.b. List every field in the Client table and its associated data type.c. List every table that contains a field named TaskID.
arrow_forward
The format for the UPDATE command is the word UPDATE, followed by the name of the table to be updated. The next portion of the command consists of the word ________________, followed by the name of the column to be updated, an equals sign, and the new value.
arrow_forward
Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW.
1
Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA.
1
Task 12: List all the views contained within the system catalog, but only display the first 12 records.
arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License