Advertisements
Advertisements
प्रश्न
Which of the following executes the SQL command to perform some action?
पर्याय
execute()
key()
cursor()
run()
उत्तर
execute()
APPEARS IN
संबंधित प्रश्न
The most commonly used statement in SQL is ______
Which method is used to fetch all rows from the database table?
Mention the difference between fetchone() and fetchmany().
What is the use of the Where Clause?
Give a python statement Using the where clause.
Consider the following table Supplier and item. Write a python script for the following Question?
| SUPPLIER | ||||
| Suppno | Name | City | Icode | SuppQty |
| S001 | Prasad | Delhi | 1008 | 100 |
| S002 | Anu | Bangalore | 1010 | 200 |
| S003 | Shahid | Bangalore | 1008 | 175 |
| S004 | Akila | Hydrabad | 1005 | 195 |
| S005 | Girish | Hydrabad | 1003 | 25 |
| S006 | Shylaja | Chennai | 1008 | 180 |
| S007 | Lavanya | Mumbai | 1005 | 325 |
Display Name, City, and Itemname of suppliers who do not reside in Delhi.
Consider the following table Supplier and item. Write a python script for the following Question?
| SUPPLIER | ||||
| Suppno | Name | City | Icode | SuppQty |
| S001 | Prasad | Delhi | 1008 | 100 |
| S002 | Anu | Bangalore | 1010 | 200 |
| S003 | Shahid | Bangalore | 1008 | 175 |
| S004 | Akila | Hydrabad | 1005 | 195 |
| S005 | Girish | Hydrabad | 1003 | 25 |
| S006 | Shylaja | Chennai | 1008 | 180 |
| S007 | Lavanya | Mumbai | 1005 | 325 |
Increment the SuppQty of Akila by 40
Write a Python script to create a table called ITEM with the following specifications.
Add one record to the table.
Name of the database:- ABC
Name of the table:- Item
Column name and specification:-
| Icode | :- | integer and act as primary key |
| Item Name | :- | The character with a length of 25 |
| Rate | :- | Integer |
| Record to be added | :- | 1008, Monitor, 15000 |
Write the Python script to display all the records of the following table using fetchmany().
| Icode | ItemName | Rate |
| 1003 | Scanner | 10500 |
| 1004 | Speaker | 3000 |
| 1005 | Printer | 8000 |
| 1008 | Monitor | 15000 |
| 1010 | Mouse | 700 |
The hat is the use of the HAVING clause. Give an example python script.
