CBSE Question Paper Analyzer

Consider the following SQL table MEMBER in a SQL Database CLUB :

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.execute ("USE CLUB")

MYCUR.execute ("SELECT * FROM MEMBER WHERE ACTIVITY= 'GYM' ")

(a) SELECT Name, Age FROM VACCINATION_DATA WHERE Dose2 IS NOT NULL AND Age > 40;

(b) SELECT City, COUNT(*) FROM VACCINATION_DATA GROUP BY City;

(c) SELECT DISTINCT City FROM VACCINATION_DATA;

(d) SELECT MAX (Dose1), MIN (Dose2) FROM VACCINATION_DATA;

(a) SELECT DNAME, PNAME FROM DOCTOR NATURAL JOIN PATIENT;

(b) SELECT PNAME, ADMDATE, FEES FROM PATIENT P, DOCTOR D WHERE D.DNO = P.DNO AND FEES > 1000;

Differentiate between Candidate Key and Primary Key in the context of Relational Database Model.

OR

Consider the following table PLAYER :

(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 "EmptyStack".

If the Words accepted and pushed into the list All are

Then the stack NoVowel should store

And the output should be displayed as

GYM RHYTHM DRY EmptyStack

OR

Write the definition of a user defined function Push3_5(N) which accepts a list of integers in a parameter N and pushes all those integers which are divisible by 3 or divisible by 5 from the list N into a list named Only3_5.

Write a program in Python to input 5 integers into a list named NUM.

The program should then use the function Push3_5() to create the stack of the list Only3_5. Thereafter pop each integer from the list Only3_5 and display the popped value. When the list is empty, display the message "StackEmpty".

Then the stack Only3_5 should store

And the output should be displayed as

30 18 6 10 StackEmpty