Table: Supplier

(a)

Given the Supplier Table with five records. Write SQL statements to answer the following questions:

1. Sort the list of supplier name in descending order.
2. List the supplier name that is from "Petaling Jaya".
3. Change the name of manager for "IDE Company" to "Ahmad".
4. Add a new record as given below to the Supplier Table:

Supplier Number: S9998
Supplier Name: JUARA Tech
Supplier Address: 112, Jalan Mambang, 40450, Shah Alam
Supplier Tel. No: 55214466
Manager: Amani

( 12 )

(b)

Differentiate each of the following ISO SQL data types. Give an example for each.

1. Fixed length and Variable length.
2. Decimal number and positive or negative number.

( 8 )

Answer rating: 100% (QA)

Answer Solution Soluti... View the full answer