Question: st red Q11. Write an SQL query to do the following: d out of question a. Create table Library with the given details. D BName

st red Q11. Write an SQL query to do the following: d out of question a. Create table Library with the given details. D BName Pch_Date Varchar2(3). Varchar2(15) Date Primary key ( Marks) Price Number(5.2). Default 0 (1 Mark) (Mark) b. Add constraint Not null to the column BName c. Insert the following records into the table Library. ID BName Pch_Date B12 Sql 20/05/2019 B14 Database 15/10/2018 B16 Python 06/06/2020 Price 100.00 75.25 125.50 d. Change the Purchase Date of book SQL to 06/06/2020 (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 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...

I want it in the form of text and not screenshot it so that I can copy it.(t ype the command) Q11. Write an SQL query to do the following: a. Create table Library with the given details. ID BName...

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 Qil. Write an SQL query to do the following: ID a. Create table Library with the given details. 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...

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 Question 12 Q11. Write an SQL query to do the following: Not yet answered Marked out of 10.00 Flag question a. Create table Library with the given details. ID BName Pch_Date Varchar2(3)....

The markup on greeting cards in a drug store is 65% of the selling price. For a card priced at $4.95, determine: a. Its cost. b. The rate of markup on cost.

Figure 3-B illustrates a mass m1 driven by a sinusoidal force whose frequency is w. The mass m1 is attached to a rigid support by a spring of force constant k and slides on a second mass m2. The...

0 Requied inlormation Required 1 4 Repuired 2 A Compute the adid test ratie for each of the three pears. ores 4 Finet * * Five Antasencis: \ table [ [ Acallaterstiry ] , [ , Wenepenior, 1 ,...

Wendell's Donut Shoppe is investigating the purchase of a new $18,600 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings...

7. Use of new technology fits into the organizational culture or business strategy.

5. Employees have a difficult time attending scheduled training programs.

3. Trainees are comfortable using technology, including the Web, personal computers, and CD-ROMs.