Get the step-by-step solution for this question inside the Vidyadip app.
Get the answer in the appGenerate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
(a) Name local variable(s).
(b) Name global variable(s).
(c) __________ is built-in function.
(d) ______________ is user-defined function.
(e) Name actual parameter(s).
(f) Name formal parameter(s).
Write the output produced by the following SQL commands:
Table: Club
| Member_id | Member_Name | Address | Age | Fee |
| M001 | Sumit | New Delhi | 20 | 2000 |
| M002 | Nisha | Gurgaon | 19 | 3500 |
| M003 | Niharika | New Delhi | 21 | 2100 |
| M004 | Sachin | Faridabad | 18 | 3500 |
(i) What is the cardinality and degree of the above given table?
(ii) If a new column contact_no has been added and three more members have joined the club then how these changes will affect the degree and cardinality of the above given table.