MySQL Functions Quiz 3

Welcome to your MySQL Functions Quiz 3

Name

School Name

Q21. Write a query to calculate GST as 10% of Price from Inventory table and display the result after rounding it off to one decimal place.

Select round(10/100 * Price, 1) "GST" from Inventory;

Select round(10/100 * Price) "GST" from Inventory;

Select round(0.01 * Price, 1) "GST" from Inventory;

Select roundoff(10/100*Price, 1) "GST" from Inventory;

Q22. Write a query to calculate sum of column Price from table Inventory.

Select price(sum) from Inventory;

Select sum(price) from Inventory;

Select sum(column price) from Inventory;

Select sum(price) Inventory;

Q23. Write a query to increase price of all products by Rs100 in table Inventory.

update inventory set price = price +100;

update table inventory set price = price +100;

Alter inventory set price = price +100;

update inventory price = price +100;

Q24. Write a query to add a new column Finaltax of suitable data type to the table inventory.

Update table inventory add(Finaltax numeric(7,3));

Alter table inventory add(Finaltax numeric(7,3));

Alter inventory add(Finaltax numeric(7,3));

Update inventory add(Finaltax numeric(7,3));

Q25. Write a query to calculate average of column "Finaltax" in table Inventory.

Select average-Finaltax from Inventory;

Select avg(Finaltax) Inventory;

Select average(Finaltax) from Inventory;

Select average(Finaltax column) from Inventory;

Q26. Write a query to display the car name(column name "carname") from table inventory who has maximum amount in "Finaltax" column.

Select carname, max(Finaltax) from inventory;

Select carname from inventory where Finaltax = max(Finaltax);

Select carname from inventory where Finaltax = (Select max(Finaltax) from inventory;

Select max(Finaltax) from inventory;

Q27. Write a query to add a new column Commission to the Sale table. The column Commission should have a total length of 7 in which 2 decimal places to be there.

Alter table Sale add (Commission Numeric(7,2));

Alter table add (Commission Numeric(7,2));

Alter table Sale add (Commission Numeric(9,2));

Alter Sale add (Commission Numeric(9,2));

Q28. Write a query to display record from Sale table where Commission is more than 20000.

Select * from Sale where Commission > 20000;

Select * from Sale where Commission >= 20000;

Select * from sale having Commission > 20000;

Select all records from sale where Commission > 20000;

Q29. Write a query to display InvoiceNo, SalePrice and Commission from Sale table such that commission value is rounded off to 1 digit.

Select InvoiceNo, SalePrice, round(Commission, 0) from Sale;

Select InvoiceNo, SalePrice, round(Commission, 1) from Sale;

Select InvoiceNo, SalePrice, roundoff(Commission, 1) from Sale;

Select InvoiceNo, SalePrice, (Commission, 1) from Sale;

Q30. Write a query to display only first alphabet of carname in capital from sale table.

select upper(carname) from sale;

select upper(left((carname),1)) from sale;

select left(carname,1) from sale;

select upper(left(carname),1) from sale;

Related

Leave a ReplyCancel reply