Question: Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3). Varchar2(25)

Q11. Write an SQL query to do the following a. Create

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3). Varchar2(25) Date Number(2) Primary Key Default systemdate b. Change datatype of It_No to from Number (3) to Varchar2(4). (1 Mark) c. Insert the following records into the table Shop. (1 Mark) It_No It_Name DOP Quantity P222 Book 20/05/2019 18 P444 Pencil 15/10/2018 20 P666 Ruler 06/06/2020 10 d. Display Item no and Quantity of item with name Book (1 Mark) Q12 : Use the Shop table for the following queries a. Display all details of items purchased after the date 15/10/2018. (1 Mark) b. Display all details of item with DoP is 15/10/2018 or Quantity is 10. (1 Mark) c. Display item name of items in the descending order of DoP. (1 Mark) d. Display Item No. Name and Quantity after multiply by 2. In the output show the column heading as New Quantity (1 Mark) e. Delete all details of the item Ruler from the table shop. (1 Mark)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) | It No It_Name DOP Quantity Number(3). Varchar2(25) Date Number(2) Primary Key Default systemdate...

please answer this question with SQL language and please write your answer thus i can coppy it easly I hope you reply me as fast as you can because i have an exam thank you Q11. Write an SQL query to...

Date Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DOP Quantity Number(3). Varchar2(25) Number(2) Primary Key Default system date b....

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3), Varchar2(25) Date Number(2) Primary Key Default systemdate b....

Q11. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) | It No It_Name DOP Quantity Number(3) Varchar2(25) Date Number(2) Primary Key Default systemdate b....

Qil. Write an SQL query to do the following a. Create table Shop with the given details. (2 Marks) It_No It_Name DoP Quantity Number(3). Varchar2(25) Date Number(2) Primary Key Default systemdate b....

Q11. Write an SQL query to do the following: a. Create table Library with the given details. ID BName Pch Date Varchar2(3). Varchar2(15) Date Primary key (2 Marks) Price Number(5,2). Default 0 (1...

Q11. Write an SQL query to do the following: a. Create table Library with the given details. ID BName Pch Date Varchar2(3), Varchar2(15) Date Primary key (2 Marks) Price Number(5,2), Default 0 (1...

This ambient warehouse belongs to Lego . The warehouse provides order fulfilment for their stores and stockists e.g. Toys R Us. There are over 10,000 stock keeping units (SKUs) in the warehouse which...

Consider two prospects: Problem 1: Choose between Prospect A: $2,500 with probability .33, $2,400 with probability .66, Zero with probability .01. And Prospect B: $2,400 with certainty. Problem 2:...

Daniel deposits $ 1 8 , 5 0 0 into an account earning interest at 5 % per year compounded quarterly. He wishes to withdraw $ 4 2 5 at the end of each month. For how many months can he make these...

Orange Inc. offers a discount on an extended warranty on its oPhone when the warranty is purchased at the time the oPhone is purchased. The warranty normally has a price of $132, but Orange offers it...

1. Do you prefer a. doing a job that you are comfortable with and know well? b. doing a job that presents a new challenge every day? _______

3. Should a major donor receive special privileges, such as a job or college admission for a child?

4. Do you consider yourself a. mostly focused on the future? b. mostly focused on the present? _______