CBSE COMPUTER SCIENCE

rev_stack

ONLINE MCQ TEST Python Basics 001- 1. https://docs.google.com/forms/d/e/1FAIpQLSfwkh38h6uFGRIUqsD_gWtC0LatfwtYWXb-6Cd7WS5c8KbvcA/viewform?usp=sf_link 2. https://forms.gle/Czxgqb6p9N34hLsX9 Python Basics 002- 1. https://docs.google.com/forms/d/e/1FAIpQLScguFCbVkCc8ifNMljY77f90agvQxjd64PjydiBHEMDk29QqQ/viewform?usp=sf_link 2. https://forms.gle/gih7FNGas4nX5tDV7 Python Basics 003- 1. https://docs.google.com/forms/d/e/1FAIpQLSfH6n41FHNkRSWP9ZSpQjKOAo9jS5yobQAhC1xWRniPqPgS8A/viewform?usp=sf_link 2. https://forms.gle/Fsft6dDag1gTGRZn8 Revision Tour-1 - 1. https://docs.google.com/forms/d/e/1FAIpQLSdPSGBYh7-UpgW3hYQWKTMUJXe4PTVmEnXUSZakDI9_c_T4VA/viewform?usp=sf_link 2. https://docs.google.com/forms/d/e/1FAIpQLSdPSGBYh7-UpgW3hYQWKTMUJXe4PTVmEnXUSZakDI9_c_T4VA/viewform?usp=sf_link List Object 001 1. https://docs.google.com/forms/d/e/1FAIpQLSc0dwUC6srssrHItlbmcO_qWvGAOcIXamC86GW3UDkOY2M14Q/viewform?usp=sf_link 2. https://forms.gle/qcPbd9HifatcybkT7 String Object 001- 1. https://docs.google.com/forms/d/e/1FAIpQLSfCe2ZBO52G7eb3pAoNtmq1ZMugmg_hKSIxvHgs0myEJKn5zQ/viewform?usp=sf_link 2. https://forms.gle/WbG1RiEsPYUvBWpi8 Dictionary Object 001- 1. https://docs.google.com/forms/d/e/1FAIpQLSfoL1be5aUKQW4f_aCoWUOqR5aoil9-tOIT3YRi61qEMHlFxA/viewform?usp=sf_link 2. https://forms.gle/LvemwL6kqjaeGne4A Computer Concepts 1. https://docs.google.com/forms/d/e/1FAIpQLSc4JP77T5JZKhKRL6F4l1jE7-W-HBIlKtNu6hrQNHfqQi4xZQ/viewform?usp=sf_link 2. https://forms.gle/UPV6QRAo5HAqMvyW7 Binary File Operation 1. https://docs.google.com/forms/d/e/1FAIpQLSePlWJ_6VWTIh3mSXbvVuOcbW6QVI-G_OXviqHL8fdkbsZ0gw/viewform?usp=sf_link 2. https://forms.gle/LR4Pr2WrkwunyE9bA Computer Network Expansions 1. https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link 2. https://forms.gle/BgTgRX7CeRyXTJ3C8 TEST THROUGH TELEGRAM 1. Python Basics-1 t.me/QuizBot?start=ayrNqFKS 2. Python List-1 t.me/QuizBot?start=eowBkzeL 3. Python List-2 t.me/QuizBot?start=k8DYZ3Oa 4. Python List-3 t.me/QuizBot?start=Smn9ThxH 5. Python FILE HANDLING -1 t.me/QuizBot?start=nQD1Q3kG 6. Python FILE HANDLING -2 t.me/QuizBot?start=vx12PVG3 7. Python FILE HANDLING -3 t.me/QuizBot?start=7VvdcQtz 8. Python FILE HANDLING -4 t.me/QuizBot?start=MnPrt2v4 9. Python FILE HANDLING -5 t.me/QuizBot?start=ohtwqD6S 10. Model Set t.me/QuizBot?start=mr6DO8hs Binary File Operation 1. https://docs.google.com/forms/d/e/1FAIpQLSePlWJ_6VWTIh3mSXbvVuOcbW6QVI-G_OXviqHL8fdkbsZ0gw/viewform?usp=sf_link 2. https://forms.gle/LR4Pr2WrkwunyE9bA Computer Network Expansions 1. https://docs.google.com/forms/d/e/1FAIpQLSfmxplpwpPhPSSes85fNfzncjnJr_44F-Je6oaQxqOXegZUjQ/viewform?usp=sf_link 2. https://forms.gle/BgTgRX7CeRyXTJ3C8 Pandas – Series-1 1. https://docs.google.com/forms/d/e/1FAIpQLScX53p5BhiMBrGjoCepoYNY0gsNwqwN1_n1mhMYJyT3dRaC4Q/viewform?usp=sf_link 2. https://forms.gle/SbdMp3DtcYsNm1gv5 Pandas – Series-2 1. https://docs.google.com/forms/d/e/1FAIpQLSfe9Aib_MalEBIqfzcQ2kGKNuOc2BQe4_du247YVbgi0JYVxw/viewform?usp=sf_link 2. https://forms.gle/AM2y68xh5Py2MrGN9 Pandas – Series-3 1. https://docs.google.com/forms/d/e/1FAIpQLSd2ZBHaebAbLTQXNy1ra5HzvbLPSVQkaTWB8KKXjFgu7ho6vQ/viewform?usp=sf_link 2. https://forms.gle/K6PabiCbuxQuSCvU6 Pandas – Series-4 1. https://docs.google.com/forms/d/e/1FAIpQLSfjzip1pbIuard6v4ypwWEHCva1c2XYs5XbhPjl7O8mZ5dUcg/viewform?usp=sf_link 2. https://forms.gle/kTJ4zRdnYu4LpFZU8

Answers: 1 (a) Both A and R are true and R is the correct explanation for A 2 (c) A is True but R is False 3 (b) Both A and R are true and R is not the correct explanation for A 4 (c) A is True but R is False 5 (b) Both A and R are true and R is not the correct explanation for A 6 (b) Both A and R are true and R is not the correct explanation for A 7 (a) Both A and R are true and R is the correct explanation for A 8 (b) Both A and R are true and R is not the correct explanation for A

Reasoning Type Questions 1 Assertion (A): CSV (Comma Separated Values) is a file format for data storage that looks like a text file. Reason (R): The information is organized with one record on each line and each field is separated by a comma. Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 2 Assertion (A) - If the arguments in the function call statement match the number and order of arguments as defined in the function definition, such arguments are called positional arguments. Reasoning (R) - During a function call, the argument list first contains default argument(s) followed by the positional argument(s). Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 3 Assertion(A): The resultset refers to a logical set of records that are fetched from the database by executing an SQL query. Reason(R): Resultset stored in a cursor object can be extracted by using fetch(...) functions. Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 4 Assertion(A): Python overwrites an existing file or creates a non-existing file when we open a file with ‘w’ mode. Reason(R): a+ mode is used only for writing operations Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 5 Assertion(A): The personal area Network (PAN) is established within a very small area(20 to 30 sq ft) to share the information. Reason (R ): The campus are network is used to interconnect the computers located within a campus such as a university campus, corporate campus, hospital campus etc. Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 6 Assertion ( A): In SQL, the aggregate function Avg() calculates the average value on a set of values and produces a single result. Reason ( R): The aggregate functions are used to perform some fundamental arithmetic tasks such as Min(), Max(), Sum() etc Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 7 Assertion (A) : pandas is an open source Python library which offers high performance, easy-to-use data structures and data analysis tools. Reason (R) : Professionals and developers are using the pandas library in data science and machine learning. Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True 8 Assertion: The internet is a collection of interconnected computer networks, linked by transmission medium such as fibre optic cables, transmission wires, wireless connections, etc. Reason: World Wide Web is a collection of websites or web pages stored in web servers and connected to local computers through the internet. Mark the correct choice as (a) Both A and R are true and R is the correct explanation for A (b) Both A and R are true and R is not the correct explanation for A (c) A is True but R is False (d) A is false but R is True

def checking_1(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='Admin',database='railway') cursor=mycon.cursor() mycon.autocommit=True f=input("FIRST NAME:") l=input("LAST NAME:") n=f+""+l a=input('USER NAME:') b=input('PASS WORD:') c=input('RE-ENTER YOUR PASS WORD:') ph=input("PHONE NUMBER:") print(' M=MALE','\n','F=FEMALE','\n','N=NOT TO MENTION') gen=input('ENTER YOUR GENDER:') print("ENTER YOR DATE OF BIRTH") d=input("DD:") o=input("MM:") p=input("YYYY:") dob=d+'/'+o+'/'+p age=input('YOUR AGE:') v={'m':'MALE','f':'FEMALE','n':'NOT TO MENTION'} if b==c: try: c1="insert into user_accounts values('{}','{}','{}','{}','{}','{}','{}','{}')".format(f,l,a,b,ph,v[gen],dob,age) cursor.execute(c1) print('WELCOME',f,'',l) return True except: print('PASSWORD ALREADY EXISTS') return False else: print('BOTH PASSWORDS ARE NOT MATCHING') # CHECKING ACCOUNT DETAILS def checking(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='Admin',database='railway') cursor=mycon.cursor() mycon.autocommit=True a=input('USER NAME:') b=input('PASS WORD:') try: s1="select user_name from user_accounts where password='{}'".format(b) c1="select fname,lname from user_accounts where password='{}'".format(b) cursor.execute(c1) data1=cursor.fetchall()[0] data1=list(data1) data1=data1[0]+''+data1[1] cursor.execute(s1) data=cursor.fetchall()[0] data=list(data)[0] if data==a: print(' HII ',data1) return True else: return False except: print('ACCOUNT DOES NOT EXIST') def checking_3(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='railway') cursor=mycon.cursor() mycon.autocommit=True a=input('USER NAME:') b=input('PASS WORD:') try: s1="select user_name from user_accounts where password='{}'".format(b) c1="select fname,lname from user_accounts where password='{}'".format(b) cursor.execute(c1) data1=cursor.fetchall()[0] data1=list(data1) data1=data1[0]+''+data1[1] cursor.execute(s1) data=cursor.fetchall()[0] data=list(data) if data[0]==a: x=['FIRST NAME','LAST NAME','PHONE NUMBER','GENDER','DATE OF BIRTH','AGE'] s1="select fname,lname,phno,gender,dob,age from user_accounts where password='{}'".format(b) cursor.execute(s1) data=cursor.fetchall()[0] data=list(data) print(x[0],':::',data[0]) print(x[1],':::',data[1]) print(x[2],':::',data[2]) print(x[3],':::',data[3]) print(x[4],':::',data[4]) print(x[5],':::',data[5]) else: return False except: print('ACCOUNT DOES NOT EXIST') table_creation_railway() table_creation_user_accounts() menu()

def ticket_checking(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='railway') cursor=mycon.cursor() mycon.autocommit=True print('1.yes') print('2.no') ch=int(input("do you want to continue or not:")) if ch==1: phno=int(input('enter your phnone number:')) try: s1="select * from railway where phno=phno" cursor.execute(s1) data=cursor.fetchall()[0] Data=list(data) a=['NAME','PHONE NUMBER','AGE','GENDER','STARTING POINT','DESTINATION','DATE',] print(a[0],'::::',Data[0].upper()) print(a[1],'::::',Data[1]) print(a[2],'::::',Data[2]) print(a[3],'::::',Data[3].upper()) print(a[4],'::::',Data[4].upper()) print(a[5],'::::',Data[5].upper()) print(a[6],'::::',Data[6]) except: print('TICKET DOES NOT EXISTS') elif ch==2: print('THANK YOU') else: print('ERROR 404:PAGE NOT FOUND') #TICKET_CANCELLING def ticket_cancelling(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='railway') cursor=mycon.cursor() mycon.autocommit=True print('1.yes') print('2.no') ch=int(input("do you want to continue or not:")) if ch==1: phno=input('enter your phone number:') s1="delete from railway where phno=phno" cursor.execute(s1) print('TICKET CANCELLED') elif ch==2: print('THANK YOU') else: print('ERROR 404:PAGE NOT FOUND') # ACCOUNT DETAILS def checking_2(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='railway') cursor=mycon.cursor() mycon.autocommit=True a=input('USER NAME:') b=input('PASS WORD:') try: s1="select user_name from user_accounts where password='{}'".format(b) cursor.execute(s1) data=cursor.fetchall()[0] data=list(data) if data[0]==a: print('IS THIS YOUR ACCOUNT') s1="select user_name from user_accounts where password='{}'".format(b) c1="select fname,lname from user_accounts where password='{}'".format(b) cursor.execute(c1) data1=cursor.fetchall()[0] data1=list(data1) data1=data1[0]+''+data1[1] cursor.execute(s1) data=cursor.fetchall()[0] data=list(data) if data[0]==a: x=['FIRST NAME','LAST NAME','PHONE NUMBER','GENDER','DATE OF BIRTH','AGE'] s1="select fname,lname,phno,gender,dob,age from user_accounts where password='{}'".format(b) cursor.execute(s1) data=cursor.fetchall()[0] data=list(data) print(x[0],':::',data[0]) print(x[1],':::',data[1]) print(x[2],':::',data[2]) print(x[3],':::',data[3]) print(x[4],':::',data[4]) print(x[5],':::',data[5]) print('1.yes') print('2.no') vi=int(input('enter your choice:')) if vi==1: b1="delete from user_accounts where password = '{}'".format(b) cursor.execute(b1) return True elif vi==2: print('SORRY,RETRY') else: print('ERROR 404:PAGE NOT FOUND') else: return False except: print('ACCOUNT DOES NOT EXIST') # INSERTING VALUES INTO TABLE

# TABLE _CREATION def table_creation_railway(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='Admin') cursor=mycon.cursor() mycon.autocommit=True s1='create database if not exists railway' cursor.execute(s1) s1='use railway' cursor.execute(s1) s1="create table if not exists railway(name varchar(100),phno varchar(15) primary key,age int(4),gender varchar(50),from_f varchar(100),to_t varchar(100),date_d varchar(20))" cursor.execute(s1) #table_creation_railway() def table_creation_user_accounts(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='Admin') cursor=mycon.cursor() mycon.autocommit=True s1='create database if not exists railway' cursor.execute(s1) s1='use railway' cursor.execute(s1) s1="create table if not exists user_accounts(fname varchar(100),lname varchar(100),user_name varchar(100),\ password varchar(100) primary key, phno varchar(15),gender varchar(50),dob varchar(50),age varchar(4))" cursor.execute(s1) #table_creation_user_accounts() #MAIN_CODE def menu(): print('1.YES') print('2.NO') ch=int(input('DO YOU WANT TO CONTINUE OR NOT:')) while ch==1: print('WELECOME TO ONLINE RAILWAY RESERVATION SYSTEM') print('1.SIGN IN') print('2.SIGN UP') print('3.DELETE ACCOUNT') print('4.EXIT') ch1=int(input('ENTER YOUR CHOICE:')) if ch1==1: a=checking() if a==True: print('WELCOME') main() else: continue elif ch1==2: a=checking_1() if a==True: main() else: print('PASSWORD ALREADY EXISTS') continue elif ch1==3: c=checking_2() if c==True: print('ACCOUNT DELETED') continue else: print('YOUR PASSWAORD OR USER_NAME IS INCORRECT') continue elif ch1==4: print('THANK YOU') break else: print('ERROR 404:PAGE NOT FOUND') break def main(): print('1.yes') print('2.no') c=int(input("do you want to continue or not:")) while (c==1): print(' 1.TICKET BOOKING',"\n", '2.TICKET CHECKING',"\n",'3.TICKET CANCELLING',"\n",'4.ACCOUNT DETAILS',"\n",'5.LOG OUT') ch=int(input('enter ur choice:')) if ch==1: ticket_booking() elif ch==2: ticket_checking() elif ch==3: ticket_cancelling() elif ch==4: checking_3() elif ch==5: print('THANK YOU') break else: print('WRONG INPUT') else: print('ERROR 404: ERROR PAGE NOT FOUND') #TICKET_BOOKING def ticket_booking(): import mysql.connector mycon=mysql.connector.connect(host='localhost',user='root',passwd='1234',database='railway') cursor=mycon.cursor() mycon.autocommit=True nm=input('enter your name:') phno=input('enter your phone number:') age=int(input('enter your age:')) print(' M=MALE','\n','F=FEMALE','\n','N=NOT TO MENTION') gender=input('enter your gender:') Gender=gender.upper() fr=input('enter ur starting point:') to=input('enter your destination:') date1=input('enter date(dd):') date2=input('enter month(mm):') date3=input('enter year(yyyy):') date=date1+"/"+date2+"/"+date3 a={'M':'MALE','F':'FEMALE','N':'NOT TO MENTION'} v=a[Gender] s1="insert into railway values('{}',{},{},'{}','{}','{}','{}')".format(nm,phno,age,v,fr,to,date) cursor.execute(s1) print('BOOKED SUCCESSFULLY') # TICKET_CHECKING