h) Write a query to create table below :
softdrink
Drink code Dname Price Calories
101 Lime and lemon 20.00 120
102 Apple drink 18.00 120
103 Nature nectar 15.00 115
104 Green mango 15.00 140
105 Aam panna 20.00 135
106 Mango juice bahaar 12.00 150
Write a query to create table.
I) To display names and drink codes of those drinks that have more than 120
calories.
ii) To display drink codes, names and calories of all drinks, in descending order of
calories.
iii) To display name and price of drinks that have price in the range 12 to 18.
iv) increase the price of all drink in the given table by 10 %.
i) A) write two examples of DBMS Software.
B) difference between DDL and DML.
j) Differentiate between char and varchar data type (explain with example) ?
Answers
Answered by
2
Answer:
i hope it helps you...❤❤
Attachments:
Answered by
1
Answer:
The queries for the given problems are as follows.
Explanation:
Examples of DBMS softwares.
1. Improvado.
2 Microsoft SQL Server.
3 Postgre SQL.
4 My SQL.
5 Amazon RDS.
6 Oracle RDBMS.
7 Razor SQL.
9 SQL Developer.
Difference between DDL and DML
1. DDL
- DDL stands for the abbreviation Data Definition Language.
- DDL statements are used to create database, create schema, create constraints, create users, create tables etc.
- DDL don't have any further classifications.
- Commands like "Create", "Drop", "Alter", and "Rename" are used by DDL.
2.DML
- DML stands for the abbreviation Data Manipulation Language.
- DML statement is used to insert, update or delete the records in the created database.
- DML is classified into Procedural DML and Non-procedural DML.
- Commands like "Insert", "Update", and "Delete" are used by DML.
Difference between char and varchar data type.
1. Char
- Char datatypes stored character strings of fixed length.
- Char stands for Character.
- It performs better then varchar.
- It takes 1 byte to store a character.
- It has set length of storage.
2. Varchar
- Varchar datatype stores character strings of variable lengths.
- Varchar stands for Variable character.
- It doesn't perform as good as char.
- It takes 1 byte plus some extra storage to store one character.
- Its storage length varies according to the entered string in bytes.
#SPJ2
Attachments:
Similar questions