Facebook, tweeter whatsapp, Telegram (any two)



XI- Informatics Practices (065) SAMPLE PAPER Session Ending Exam BLUE PRINTS. NoTypology of QuestionsVery ShortAnswer(VSA)(1 mark)ShortAnswer-I(SA-I)(2 marks)ShortAnswer -II(SA-II)(3 marks)LongAnswer(L.A.)(4 marks)LongAnswer(L.A.)(6 marks)TotalMarks1PCT-1 (Unit1)58 3 --302Data Handling (DH-1, Unit2)26 2 --203Data Management (DM-1, Unit 3)22-1-104Society, Law and Ethics (SLE-1)- Cyber Safety (Unit 4)24---10Total Marks1140154-70************XI- Informatics Practices (065) SAMPLE PAPER Session Ending ExamTime allowed: 3 hours] [Maximum marks: 70Instructions: (i) Programming Language: PYTHON.(ii) All Questions are compulsory within each section.1aFill in the blanks:(i) 1 Mega Byte = ______Kilo Byte(ii) 1024x1024x1024x1024 bytes= 1 _______Byte1bName two typical components of a CPU1cWrite any two name of IDE for python language.1dWhat is the difference between equality (==) and identity (is) operator?1eWhat contents are stored in RAM and ROM.2fWrite brief description of mobile system’ working with diagram.2gWrite 02 differences between Interpreter and Compiler.2hWrite any 02 key features of Python Language?2eWrite any 02 differences between tuples and lists in Python? Give Example.22aName any two modules that we import to use them.1bWhat is Dictionaries in python? Give example2cWhat will be the output produced by the following code-A, B, C, D=9.2, 2.0, 4, 21print(A/4)print(A//4)print(B**C)print(A%C)2dWhat is the use of break statement in looping? Explain with example.2eWrite a python script to print ‘Fibonacci series’ first 20 elements. Some initial elements of the series are: 0 1 1 2 3 5 8 . . .3fWrite a program to check whether entered string is palindrome or not.3gABC shop deals with footwear and apparels. Write a program to calculate total selling price after levying the GST. Do calculate central Govt. GST and state govt. GST. GST rates are as under-ItemGST RateFootwear <= 500 (per pair)5%Footwear > 500 (per pair)18%Apparels <= 1000 (per piece)5%Apparels > 1000 (per piece)12%33aHow will you remove last object from a list?1bWhat is NumPy and how is it better than a list in python?2cWrite a program to read employees.csv and locate the 3 largest values in a data frame.2dWrite ouput of following code:import pandas as pdmy_series=pd.Series([1,2,2.5,'comp',56.5])print(my_series.head())print(my_series.head(2))2eWrite a Python program to display a summary of the basic information about a specified DataFrame and its data.Name of DataFrame: examdataattemptsNamequalifyscorea1Anastasiayes12.5b3Dimano9.0c2Katherineyes16.5d3JamesnoNaNe2Emilyno9.0f3Michaelyes20.0g1Matthewyes14.5h1LauranoNaNi2Kevinno8.0j1Jonasyes19.02fWrite the program to convert a panda module series to python list and its types.2gWrite a python program to sort the following data according to Brand in ascending order.(Using Dataframe named Car )BrandPriceYearHonda Civic220002015Toyota Corolla250002013Ford Focus270002018Audi A43500020183hWhat is full form of CSV.1iWrite output of the following code:import pandas as pdmy_series=pd.Series({'Indore':20,'Ujjain':35,'Bhopal':40})print(my_series[my_series>20])2jWrite a program to query data in an SQLite database from Python. ORWrite steps to query data in an SQLite database from Python.34aName any two advantages of DBMS.1bDefine following with example: Primary Key, Candidate Key, Alternate Key, Foreign key2cWhat types of commands are used in following categories?(1) DDL (2) DML 2d Consider the following table details and answer (i) to (iv) (4 x 1 =4)Table : EmployeeColumn NameData TypeSizeConstraintEmp_IDVarchar8Primary keyNameVarchar20-SalaryInteger6-Designation Varchar15-i). Write a command to create above table with given constraints.ii). Write a command to add following column in above table.Column NameData TypeSizeConstraintMobile _no.Integer10- iii). Write a command to change Emp_ID as KVS1011 to KVS1001.iv). Write a command to remove all the rows from the table Employee.4eWhich keyword is used to eliminate redundant data?15aList any two names of Social networking sites.1bWhat is the use of CAPTCHA .1cWhat is cyber-crime?2cWhat are the differences between Virus and Worms?(any two)2eWhat are DoS attacks? Explain any two.2fWhat safety precautions will you take to safely browse the web? Give details?2******************XI- Informatics Practices (065) SAMPLE PAPER 2Session Ending ExamMARKING SCHEMEQ. No.Suggested / Expected Answer with HintMarks1 aFill in the blanks:(i) 1 Mega Byte=______Kilo Byte(ii) 1024x1024x1024x1024 bytes= 1_______Byte1Ans.(i) 1 Mega Byte=__1024__Kilo Byte(ii) 1024x1024x1024x1024 bytes= 1_Tera_BytebName two typical components of a CPU1Ans.The two typical components of a CPU include the following:The?arithmetic logic unit?(ALU), which performs arithmetic and logical operations.The?control unit?(CU), which extracts?instructions?from?memory and decodes and?executes?them, calling on the ALU when necessary.cWrite any two name of IDE for python language.1Ans.PyScripter , SpyderdWhat is the difference between equality (==) and identity (is) operator?1Ans.Equality (==) compares values while identity (is) compares memory address of variables/objects.eWhat contents are stored in RAM and ROM.2Ans.RAM stores the active data that includes the data input by the user, the content displays on the screen and all the temporary instructions that are being processed by the CPUROM stores the data and instructions provided by the manufacturer of the motherboard ( data and information required during the process of booting)fWrite brief description of mobile system working with diagram.2Ans. ( 01 Marks for diagram + 01 Marks for description )gWrite two differences between Interpreter and Compiler2Ans.Interpreter convert the High level Language program into machine language in line by line whereas Compiler converts whole program in one go.Interpreter takes more memory because its present in the memory all the time but compiler takes less memory because after compilation its remove from memory.hWrite any 02 key features of Python Language?2Ans.Key features of Python are:A variety of basic data types are available: numbers (floating point, complex, and unlimited-length long integers), strings (both ASCII and Unicode), lists, and dictionaries.Python supports object-oriented programming with classes and multiple inheritance.Code can be grouped into modules and packages.The language supports raising and catching exceptions, resulting in cleaner error handling.Data types are strongly and dynamically typed. Mixing incompatible types (e.g. attempting to add a string and a number) causes an exception to be raised, so errors are caught sooner.Python contains advanced programming features such as generators and list comprehensions.Python's automatic memory management frees you from having to manually allocate and free memory in your code.2 marks for any two key featureseWrite any 02 differences between tuples and lists in Python? Give Example.2Ans. The major?difference between tuples?and?lists is?that a?list is?mutable, whereas a?tuple is?immutable. This means that a?list?can be changed, but a?tuple?cannot.Example:-Sizea = tuple(range(1000))b = list(range(1000))a.__sizeof__() # 8024b.__sizeof__() # 90882.aName any two modules that we import to use them.1Ans.Pandas, NumpybWhat is Dictionaries in python? Give example.2Ans.A?dictionary?is an associative array (also known as hashes). Any key of the?dictionary?is associated (or mapped) to a value. The values of a?dictionary?can be any?Python?data type. So?dictionaries?are unordered key-value-pairs.cWhat will be the output produced by the following code-A, B, C, D=9.2, 2.0, 4, 21print(A/4)print(A//4)print(B**C)print(A%C)2Ans. output-2.32.016.01.1999999999999993? mark for each correct answerdWhat is the use of break statement in looping? Explain with example.2Ans.It terminates the loop when a condition becomes true.. The?break?statement can be used in both?while?and?for loops.#!/usr/bin/pythonfor letter in 'Python': # First Example if letter == 'h': break print 'Current Letter :', lettervar = 10 # Second Examplewhile var > 0: var = var -1 if var == 5: break print 'Current variable value :', varprint "Good bye!"eWrite a python script to print ‘Fibonacci series’ first 20 elements. Some initial elements of the series are: 0 1 1 2 3 5 8 . . .3Ans.nterms = int(input("How many terms? "))n1 = 0n2 = 1count = 0print("Fibonacci sequence upto",nterms,":")while count < nterms: print(n1,end=' , ') nth = n1 + n2 n1 = n2 n2 = nth count += 13 marks for correct code or any other similar codefWrite a program to check whether entered string is palindrome or not.3Ans.string = input("Please enter your own String : ")if(string == string[:: - 1]): print("This is a Palindrome String")else: print("This is Not a Palindrome String")3 marks for correct code or any other similar codegABC shop deals with footwear and apparels. Write a program to calculate total selling price after levying the GST. Do calculate central Govt. GST and state govt. GST. GST rates are as under-ItemGST RateFootwear <= 500 (per pair)5%Footwear > 500 (per pair)18%Apparels <= 1000 (per piece)5%Apparels > 1000 (per piece)12%3Ans.itc=input("Enter item code (A)Apparel (F)Footwear-")sp=float(input("enter selling price-"))if itc=='A': if sp<=1000: gstRate=5 else: gstRate=12elif itc=='F': if sp<=500: gstRate=5 else: gstRate=18cgst=sp*(gstRate/2)/100sgst=cgstamount=sp+cgst+sgstprint("Total sell price-",amount)3 marks for correct code or any other similar code3 a.How will you remove last object from a list ?1Ans.Using the pop() methodbWhat is NumPy and how is it better than a list in python?2Ans.The most important benefits of using it are :It consumes?less memory.It is fast as compared to the python List.It is?convenient to use. cWrite a program to read employees.csv and locate the 3 largest values in a data frame.2Ans. data = pd.read_csv("employees.csv") ??print(data.nlargest(3, "Salary")) dWrite ouput of following code:import pandas as pdmy_series=pd.Series([1,2,2.5,'comp',56.5])print(my_series.head())print(my_series.head(2))2Ans.0 11 22 2.53 comp4 56.5And0 11 2eWrite a Python program to display a summary of the basic information about a specified DataFrame and its data.2Ans.import pandas as pdimport numpy as npexam_data = {'name': ['Anastasia', 'Dima', 'Katherine', 'James', 'Emily', 'Michael', 'Matthew', 'Laura', 'Kevin', 'Jonas'],'score': [12.5, 9,16.5, np.nan, 9, 20,14.5, np.nan, 8,19],'attempts': [1, 3, 2, 3, 2, 3,1,1, 2,1],'qualify': ['yes', 'no', 'yes', 'no', 'no', 'yes', 'yes', 'no', 'no','yes']} labels = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j'] df = pd.DataFrame(exam_data , index=labels)print("Summary of the basic information about this DataFrame and its data:")print(())fWrite the program to convert a panda module series to python list and its types.2Ans.import pandas as pdds = pd.Series([2, 4, 6, 8, 10])print("Pandas Series and type")print(ds)print(type(ds))print("Convert Pandas Series to Python list")print(ds.tolist())print(type(ds.tolist()))gWrite a python program to sort the following data according to Brand in ascending order.(Using Dataframe named Car )3Ans.Cars = {'Brand': ['Honda Civic','Toyota Corolla','Ford Focus','Audi A4'], 'Price': [22000,25000,27000,35000], 'Year':[2015,2013,2018,2018] } df = DataFrame(Cars, columns= ['Brand', 'Price','Year'])# sort Brand - ascending orderdf.sort_values(by=['Brand'], inplace=True)3 marks for correct program.hWhat is full form of CSV.ma Separated ValuesiWrite ouput of following code:import pandas as pdmy_series=pd.Series({'Indore':20,'Ujjain':35,'Bhopal':40})print(my_series[my_series>20])2Ans.Ujjain 35Bhopal 40jWrite a program to query data in an SQLite database from Python. ORWrite steps to query data in an SQLite database from Python.3Ans. import sqlite3conn = sqlite3.connect("test.db")cur = conn.cursor()cur.execute("select * from first;")results = cur.fetchall()print(results) ORSteps to query data in an SQLite database from Python:First, establish a connection to the the SQLite database by creating a Connection object.Next, create a Cursor object using the cursor method of the Connection object.Then, execute the SELECT statement.After that, call the fetchall() method of the cursor object to fetch the data.Finally, loop the cursor and process each row individually.4 aName any two advantages of DBMS..1Ans.Data sharing, data security.BDefine following with example.Primary Key, Candidate Key, Alternate Key, Foreign key2Ans.? mark for each.CWhat types of commands are used in following categories?(1) DDL (2) DML 2Ans.DDL- CREATE, ALTER, DROPDML- INSERT, UPDATE, DELETE1 MARK EACH FOR ANY 02 EXAMPLES FOR EVERY CATEGORYD Consider the following table details and answer (i) to (iv)(4 x 1 =4)4Ans. i)CREATE TABLE Employee(Emp_ID varcher(8) primary key not null, name varchar(20),salary integer(6),designation varchar(15));ii)ALTER TABLE Employee add mobile_no integer(10);iii)UPDATE EMPLOYEE SET Emp_ID=’KVS1001’WHERE Emp_ID=’KVS1011’;iv)DELETE from EMPLOYEE;EWhich keyword is used to eliminate redundant data?1Ans.Distinct5.AList any two names of social networking sites.1Ans.Facebook, tweeter whatsapp, Telegram (any two)BWhat is the use of CAPTCHA .1Ans.CAPTCHA or Completely Automated Public Turing test to Tell Computers and Humans Apart is a technique to distinguish between humans and computers.CWhat is cyber crime ?2Ans.Cyber Crime is that takes place over digital devices like cell phones, computers, and tablets. Cyber Crime can occur through SMS, Text, and apps, or online in social media, forums, or gaming where people can view, participate in, or share content. DWhat is the difference between Virus and Worms?2Ans.The Virus attaches itself to executable files and transfers from one system to the other. A Worm is a malicious program that replicates itself and can spread to different computers via Network.EWhat are DoS attacks? Explain any two.2Ans.A DoS attack can be done in a several ways. The basic types of DoS attack include:Flooding the network to prevent legitimate network trafficDisrupting the connections between two machines, thus preventing access to a serviceFWhat safety precautions will you take to safely browse the web? Give Details?2AnsDownload from the trusted site. Do not click on any auspicious link.Use online keyboard while online transactionsInstall good firewall in a system Do not respond to any unknown email. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download