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
I CNR 004 Steve | Saving 18200 1998-02-21 | M
| CNR 005 | Manpreet Current NULL, 1994-02-19
( 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:

basic of the is a metro matrix solution

Answer 2

Answer:

Explanation:

(I). Degree: 6

Cardinality: 4

(II). max(DOJ)

1998-02-21

(III) Delete from Customer_Details where Accumlt_Amt is NULL;