A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 3, Problem 5RQ
Explanation of Solution
a)
COMMISSIONRATE:
It is a valid option in Oracle...
Explanation of Solution
b)
POSTAL_CODE_5CHAR:
It is a valid option in Oracle...
Explanation of Solution
c)
SHIP TO ADDRESS:
It is an invalid option in Oracle...
Explanation of Solution
d)
INVOICE-NUMBER:
It is an invalid option in Oracle...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
You should use an Oracle function to calculate the number of days that have gone between your birthday and the current date.
Calculate the number of days that have passed between your birthday and the current date using an Oracle function.
Which of the following is true? (refer to the tables in the JustLee Books database)a. If you truncate a table, you can’t add new data to the table.b. If you change the default value of an existing column, all existing rows containing a NULL value in the same column are set to the new DEFAULT value.c. If you delete a column from a table, you can’t add a column to the table with the same name as the previously deleted column.d. If you add a column to an existing table, it’s always added as the last column of the table.
Chapter 3 Solutions
A Guide to SQL
Ch. 3 - Prob. 1RQCh. 3 - How do you delete a table using SQL?Ch. 3 - Prob. 3RQCh. 3 - Prob. 4RQCh. 3 - Prob. 5RQCh. 3 - Prob. 6RQCh. 3 - Prob. 7RQCh. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQ
Ch. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Prob. 13RQCh. 3 - Use SQL to complete the following exercises....Ch. 3 - Prob. 2TDCh. 3 - Prob. 3TDCh. 3 - Prob. 4TDCh. 3 - Prob. 5TDCh. 3 - Prob. 6TDCh. 3 - Prob. 7TDCh. 3 - Prob. 1CATCh. 3 - Add the following row to the ADVENTURE_TRIP table:...Ch. 3 - Prob. 3CATCh. 3 - Prob. 4CATCh. 3 - Prob. 5CATCh. 3 - Prob. 6CATCh. 3 - Review the data for the TRIP table in Figure 1-5...Ch. 3 - Colonial Adventure Tours would like to increase...Ch. 3 - Prob. 1SCGCh. 3 - Add the following record to the VACATION_UNIT...Ch. 3 - Delete the VACATION_UNIT table.Ch. 3 - Prob. 4SCGCh. 3 - Prob. 5SCGCh. 3 - Prob. 6SCGCh. 3 - The SERVICE_REQUEST table uses the CHAR data type...
Knowledge Booster
Similar questions
- What Oracle function should you use to compute the number of days that have passed between your birthday and the current date?arrow_forwardIn order to compute the number of days that have passed between your birthday and the current date, you should utilise an Oracle function.arrow_forwardInstructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a…arrow_forward
- 18. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? a. VARCHAR2 b. CHAR c. LONG d. NUMBERarrow_forwardIf an integer is multiplied by a NULL value, the result is: (refer to the tables in the JustLee Books database.)a. an integerb. a whole numberc. a NULL valued. None of the above—a syntax error message is returned.arrow_forward) Create a database called cars that has these tables or write the SQL command to create the database and the tables Car(car_ID, car_name, price, color, manufacturer, No_cylinder, owner_ID) Owner(owner_ID, name, No_cars, phone_No, address) answer the following SQL queries: 1- Find the cars names that has 4 cylinders and its price is greater than the average price of all cars that manufactured by Audi. 2- Find all red cars owned by Mr.Ali. 3- find the summation of black cars prices that has 4 cylinder. 4- delete all the owners who live in New York.arrow_forward
- Im trying to run the following SQL in Oracle: SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee Description')WHERE ServiceName NOT IN (SELECT FEETYPE FROM REPORT_FILTER_KR)GROUP BY GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeChargedORDER BY SUM(FeeCharged) DESC; And I'm recieving this error: Error starting at line : 1 in command -SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee…arrow_forwardCreate reports containing the following details from the database: Q1 How many books are there in the Computer category? Use column alias for a column with the number of books, show category and the number of books in your report. Q2 Find out how many books each author wrote. Display author’s first and last name and how many books (s)he wrote. Sort by last name, then first name. Q3 Calculate the total paid for the order 1009. Consider quantity in calculations, some books may be purchased in multiple copies. Q4 Find the average retail price of books in each of the Children and Business categories, use a single query to show the average for Children and Business books (two records in the results). Q5 List customers from New Jersey and Florida who placed orders totaling over $30.Aggregate PER order, PER customer. Q6 Determine the average of ALL orders. Find the total per each order before calculating the average for all orders. Hint: Use nesting. Q7 Show the most expensive book a customer…arrow_forwardYou should use an Oracle function to determine how many days have transpired between your birthday and the present day.arrow_forward
- Third normal form says: a. No nonkey columns depend on another nonkey column. b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above.arrow_forwardSecond normal form says: a. No nonkey columns depend on another nonkey column. b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the abovearrow_forwardTHIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS (a) From which two fields in which table can you calculate the enrollment of a section?(b) From which table can you get both course and section numbers?(c) Which field in table SECTION uniquely identifies a section, section id or section no?(d) Write a SQL statement to show sections and their enrollment.(e) Write a SQL statement to show sections with enrollment greater than five. Display both course andsection numbersarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr