InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
On the basis of following table answer the given questions:Table: CUSTOMER_DETAILSCust_IDCust_Name Acct_TypeAccumlt_Amt DOJ Gender CNR_001Manoj Saving1012501992-02-19MCNR_002 RahulCurrent1322501998-01-11MCNR_004 Steve Saving182001998-02-21M CNR_005Manpreet CurrentNULL1994-02-19M(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» (i) The degree is 6 and cardinality is 5. (ii) +------------+ |max(DOJ)| +------------+ |1998-02-21| +------------+ (iii) Delete from Customer_Details where Accumlt_Amt is NULL; |
|