Question

On the basis of following table answer the given questions:
Table: CUSTOMER_DETAILS
+---------+-----------+-----------+-------------+------------+--------+
| Cust_ID | Cust_Name | Acct_Type | Accumlt_Amt | DOJ | Gender |
+---------+-----------+-----------+-------------+------------+--------+
| CNR_001 | Manoj | Saving | 101250 | 1992-02-19 | M |
| CNR_002 | Rahul | Current | 132250 | 1998-01-11 | M |
| CNR_004 | Steve | Saving | 18200 | 1998-02-21 | M |
| CNR_005 | Manpreet | Current | NULL | 1994-02-19 | M |
+---------+-----------+-----------+-------------+------------+--------+
(i) Write the degree and cardinality of the above table. (ii) What will be the output of the following query :
Select max(DOJ) From Customer_Details;
(iii) Write the sql query to delete the row from the table where customer has no accumulated amount.

Answer 1

Answer:

(i) Degree is 6 and cardinality is 4.

(ii) The output will be

Max(DOJ)

1998-02-21

(iii) Alter table Customer_Details drop row where (Accumlt_Amt is NULL);

Hope this helps you...