Question
Write function insert() to insert the new row in table student. The function will take the values as parameter.
✓
Answer
Get the step-by-step solution for this question inside the Vidyadip app.
Get the answer in the appNeed a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Write two characteristics of Web 2.0. [Delhi, AI 2016]
Write script to input two integers and find their LCM.
Differentiate between packet switching over message switching?
What is the difference between HTML and XML.
Write the function to update() to accept the values as parameter and update the record according to the passed values. Assuming that values exist in the table.
Write a script to create an empty list and then
(a) Input 10 numbers from the users and store them in the list using append() method
(b) Find the sum of all the even elements present in the list
(a) Input 10 numbers from the users and store them in the list using append() method
(b) Find the sum of all the even elements present in the list
Consider the following table Bank.Table: Bank
| AccNo | Cust_name | FD_Amount | Months | Int_Rate | FD_Date |
| 1001 | Arti Gupta | 30000 | 36 | 6.00 | 2018-07-01 |
| 1002 | Dilip Lal | 50000 | 48 | 6.75 | 2018-03-22 |
| 1003 | Navin Gupta | 30000 | 36 | NULL | 2018-03-01 |
| 1004 | D.P. Yadav | 80000 | 60 | 8.25 | 2017-06-12 |
| 1005 | Jyoti Sharma | 20000 | 36 | 6.50 | 2017-01-31 |
| 1006 | Rakesh Kumar | 70000 | 60 | 8.25 | 2018-06-15 |
| 1007 | K.D. Singh | 50000 | 48 | NULL | 2018-07-05 |
| 1008 | Anjali Sharma | 60000 | 48 | 6.75 | 2017-04-02 |
| 1009 | Swati Garg | 40000 | 42 | 6.50 | 2018-06-15 |
| 1010 | Rupinder Kaur | 25000 | 36 | 6.50 | 2018-09-27 |
Write SQL commands for the statements (a) to (g) on the table BANK
(a) To create the table Bank (Primary Key: AccNo)
(b) Display the structure of the table Bank.
(c) Display the details of all the bank.
(d) Display the AccNo, Cust_Name, and FD_Amount.
(e) Display the details of all the FD’s having maturity time is less than 40 months.
(f) Display the AccNo and FD amount which started before 01-04-2018.
(g) Display details of all FD whose rate of interest are NULL.
What is Trojan Horse?
Write the output of the given program:
Out of the following, which all comes under cyber crime?
(a) Stealing away a brand new computer from a showroom.
(b) Getting in someone’s social networking account without his consent and posting pictures on his behalf to harass him.
(c) Secretly copying files from server of a call center and selling it to the other organization.
(d) Viewing sites on a internet browser.