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

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_Noto 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)

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!

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....

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...

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...

sql,please answer it quickly 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...

For the circuit shown below calculate (b) Z, (d) A, (a) r. (c) Z (e) A, Take B = 120 and r, = 40 k2 o 20 V 2 k2 470 k2 10 u F 10 0.6 k2 Z, ww-

A silicon iron ring is wound with 800 turns, the ring having a mean diameter of 120 mm and a cross-sectional area of 400 mm. If when carrying a current of 0.5 A the relative permeability is found to...

Ted Lasso wants to save for his son s education. He knows investing is one of the best ways to save because he has about 1 5 years until his son will be old enough for college. What investment...

Over the past four years, Jellystone Quarry stock produced returns of 12.5, 15.1, 8.7, and 2.6 percent, respectively. For the same time period, the risk-free rate 4.7, 5.3, 3.9, and 3.4 percent each...

=+Is it possible to operate union-free?

=+impact member states and MNEs?

=+2 How do European Union directives (such as those developed in the area of HR)