| HTML | XML |
| a. Stands for Hyper Text Markup Language. | a. Stands for eXtensible Markup Langauage. |
| b. File extension is .html/.htm | b. File extension is .xml |
| c. It is used to display the data and focuses on how data appears on the browser. | c. It is used to transport and store the data. |
| d. HTML is not case sensitive. | d. XML is case sensitive. |
| e. HTML tags are predefined tags. | e. XML tags are user defined tags. |
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
(UPDATE, SELECT, ALTER, DROP)
Write the output produced by the following SQL commands:
Consider the following table Bank.
Table: Bank
| AccNo | Cust_name | FD_Amount | Months | Int_Rate | FD_Date |
| 1001 | Arti Gupta | 30000 | 36 | 6.00 | 2018-07-01 |
| 1002 | Dilip Lal | 50000 | 48 | 6.75 | 2018-03-22 |
| 1003 | Navin Gupta | 30000 | 36 | NULL | 2018-03-01 |
| 1004 | D.P. Yadav | 80000 | 60 | 8.25 | 2017-06-12 |
| 1005 | Jyoti Sharma | 20000 | 36 | 6.50 | 2017-01-31 |
| 1006 | Rakesh Kumar | 70000 | 60 | 8.25 | 2018-06-15 |
| 1007 | K.D. Singh | 50000 | 48 | NULL | 2018-07-05 |
| 1008 | Anjali Sharma | 60000 | 48 | 6.75 | 2017-04-02 |
| 1009 | Swati Garg | 40000 | 42 | 6.50 | 2018-06-15 |
| 1010 | Rupinder Kaur | 25000 | 36 | 6.50 | 2018-09-27 |
Write SQL commands for the statements (a) to (h) on the table Bank
(a) Display the details of all FD whose rate of interest is in the range 6% to 7%.
(b) Display the Customer Name and FD Amount for all the loans for which the number of Months is 24, 36, or 48(using IN operator).
(c) Display the Account Number, Customer Name and FD Amount for all the FD for which the Customer Name
ends with “Sharma”.
(d) Delete the records of “Rupinder Kaur”.
(e) Add another column Maturity_Amt of type Integer in the Bank table.
(f) To find the average FD amount. Label the column as “Average FD Amount”.
(g) To find the total FD amount which started in the year 2018?
(h) Update Maturity Amount of all bank customers.
a. Maturity Amount = (FD_Amount*Months* Int_rate)/(12*100)
(a) Stealing away a brand new computer from a showroom.
(b) Getting in someone’s social networking account without his consent and posting pictures on his behalf to harass him.
(c) Secretly copying files from server of a call center and selling it to the other organization.
(d) Viewing sites on a internet browser.
Title: Carbon emission of the coutries 1990-2011
values=[27, 11, 25, 8, 1, 3, 25]
countres= [ "US", "China", "European Union", "Russian Federation", "Brazil","India","Rest of World"]