Question: 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

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 Mark) al Mark) b. Add constraint Not null to the column BName c. Insert the following records into the table Library. D 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) Q12: Use the Library table for the following queries. a. Display all details of Books with name ends with letter e. (1 Mark) b. Display Id and Price of SQL book purchased on 06/06/2020 (1 Mark) c. Display name of Books in the descending order of Name. 01 Mark) d. Display the details of Books with price 100 and 125.50 (1 Mark) e. Decrease the price of book python by 20 and in the output display column name as NewPrice (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...

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

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

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

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

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

On December 31, 20A, Loganville Canning Company, with outstanding common stock of $30,000, had the following assets and liabilities: Cash ...................................................$ 5,000...

Billy, Inc. had 270,000 shares of $2 par value common stock issued and outstanding as of December 15, 2016. The company is authorized to issue 1,500,000 common shares. On December 15, 2016, Billy...

What impact do you think the leader of each company has on the overall organizational culture? What similarities and differences do you see with the two companies in terms of culture, leadership, and...

Lamonda Corp. uses a job order cost system. On April 1, the accounts had balances as shown in the T-accounts below: The following transactions occurred during April: (a) Purchased materials on...

9. Discuss the steps of an action learning program. Which aspect of action learning do you think is most beneficial for learning? Which aspect is most beneficial for transfer of training? Explain...

8. Why are apprenticeship programs attractive to employees? Why are they attractive to companies?

4. How can the characteristics of the trainee affect self-directed learning?