Press Enter or β to search
"Stack is a linear data structure which follows a particular order in which the operations are performed."
What is the order in which the operations are performed in a Stack ?
Name the List method/function available in Python which is used to remove the last element from a list implemented stack.
Also write an example using Python statements for removing the last element of the list.
(i) Expand the following :
VoIP, PPP
(ii) Riya wants to transfer pictures from her mobile phone to her laptop. She uses Bluetooth technology to connect two devices. Which type of network (PAN/LAN/MAN/WAN) will be formed in this case ?
Differentiate between the terms Attribute and Domain in the context of Relational Data Model.
Consider the following SQL table MEMBER in a SQL Database CLUB :
Table : MEMBER
| M_ID | NAME | ACTIVITY |
|---|---|---|
| M1001 | Amina | GYM |
| M1002 | Pratik | GYM |
| M1003 | Simon | SWIMMING |
| M1004 | Rakesh | GYM |
| M1005 | Avneet | SWIMMING |
Assume that the required library for establishing the connection between Python and MYSQL is already imported in the given Python code. Also assume that DB is the name of the database connection for table MEMBER stored in the database CLUB.
Predict the output of the following code :
MYCUR = DB.cursor()
MYCUR.execute ("USE CLUB")
...TABLE : VACCINATION_DATA
| VID | Name | Age | Dose1 | Dose2 | City |
|---|---|---|---|---|---|
| 101 | Jenny | 27 | 2021-12-25 | 2022-01-31 | Delhi |
| 102 | Harjot | 55 | 2021-07-14 | 2021-10-14 | Mumbai |
| 103 | Srikanth | 43 | 2021-04-18 | 2021-07-20 | Delhi |
| 104 | Gazala | 75 | 2021-07-31 | NULL | Kolkata |
| 105 | Shiksha | 32 | 2022-01-01 | NULL | Mumbai |
(a) SELECT Name, Age FROM VACCINATION_DATA WHERE Dose2 IS NOT NULL AND Age > 40;
(b) SELECT City, COUNT(*) FROM VACCIN
...Table : DOCTOR
| DNO | DNAME | FEES |
|---|---|---|
| D1 | AMITABH | 1500 |
| D2 | ANIKET | 1000 |
| D3 | NIKHIL | 1500 |
| D4 | ANJANA | 1500 |
Table : PATIENT
| PNO | PNAME | ADMDATE | DNO |
|---|---|---|---|
| P1 | NOOR | 2021-12-25 | D1 |
| P2 | ANNIE | 2021-11-20 | D2 |
| P3 | PRAKASH | 2020-12-10 | NULL |
| P4 | HARMEET | 2019-12-20 | D1 |
(a) SELECT DNAME, PNAME FROM DOCTOR NATURAL JOIN PATIENT;
(b) SELECT PNAME, ADMDATE, FEES FROM P
...Differentiate between Candidate Key and Primary Key in the context of Relational Database Model.
OR
Consider the following table PLAYER :
Table : PLAYER
| PNO | NAME | SCORE |
|---|---|---|
| P1 | RISHABH | 52 |
| P2 | HUSSAIN | 45 |
| P3 | ARNOLD | 23 |
| P4 | ARNAV | 18 |
| P5 | GURSHARAN | 42 |
(a) Identify and write the name of the most appropriate column from the given table PLAYER that can be used as a Primary key.
(b) Define the term Degree in relational data model. What is the Degree of the given table PLAYER ?
Write the definition of a user defined function PushNv(N) which accepts a list of strings in the parameter N and pushes all strings which have no vowels present in it, into a list named NoVowel.
Write a program in Python to input 5 words and push them one by one into a list named All.
The program should then use the function PushNV() to create a stack of words in the list NoVowel so that it stores only those words which do not have any vowel present in it, from the list All.
Thereafter, pop each word from the list NoVowel and display the popped word. When the stack is empty display the message
...(i) A SQL table ITEMS contains the following columns :
INO, INAME, QUANTITY, PRICE, DISCOUNT
Write the SQL command to remove the column DISCOUNT from the table.
(ii) Categorize the following SQL commands into DDL and DML:
CREATE, UPDATE, INSERT, DROP
Rohan is learning to work upon Relational Database Management System (RDBMS) application. Help him to perform following tasks :
(a) To open the database named "LIBRARY".
(b) To display the names of all the tables stored in the opened database.
(c) To display the structure of the table "BOOKS" existing in the already opened database "LIBRARY".