
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

CBSE Class 12 Pre Board 2021 : Computer Science (Kendriya Vidyalaya (KV) No 1, Armapur, Kanpur)

6 pages, 73 questions, 0 questions with responses, 0 total responses,

	CBSE 12 Pre Boards	+Fave Message
	Profile Timeline Uploads

Home > cbse12_pre_boards > F Also featured on: School Page cbse12

Formatting page ...

KENDRIYA VIDYALAYA SANGATHAN Maximum marks: 70 FIRST PRE-BOARD EXAM 2020-21 COMPUTER SCIENCE (083) CLASS-XII SET-1 Duration: 3 Hours General Instructions: 1. 2. 3. a. b. 4. 5. a. b. c. 6. This question paper contains two parts A and B. Each part is compulsory. Both Part A and Part B have choices. Part-A has 2 sections: Section I is short answer questions, to be answered in one word or one line. Section II has two case studies questions. Each case study has 4 case-based sub-parts. An examinee is to attempt any 4 out of the 5 subparts. Part - B is Descriptive Paper. Part- B has three sections Section-I is short answer questions of 2 marks each in which two question internal options have. Section-II is long answer questions of 3 marks each in which two questions have internal options. Section-III is very long answer questions of 5 marks each. All programming questions are to be answered using Python Language only. PART A Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Section-I Select the most appropriate option out of the options given for each question. Attempt any 15 questions from question no 1 to 21. Find the valid identifier(s) from the following: i) 4th Sum ii) Total iii) Numbers&# iv) _Data1 Given the list L=[ Z , X , W , J , G , H ] , write the output of print ( L [-1 : -len(L)-1 : -2] ) Name the Python Library modules which need to be imported to invoke the following functions i) floor() ii) randint() Suppose a tuple T is declared as Tup = (10, AB , 22.2 , 5,3,7), which of the following is incorrect: a. print(Tup[2]) b. print(Tup(1) = 2) c. print(Tup[4] = G ) d. print(max(Tup)) How many types of files can be handled by Python programming? Write a statement in Python to declare a dictionary whose keys are 1, 2, 3 and values are Monday, Tuesday and Wednesday respectively. Write the output of the following code: T = (11,12,13,14,15,16,17) print ( T [-2 : : 1] ) Name the built-in mathematical function / method that is used to return an absolute value of a number. What is the full form of SMTP? Central Computer which is powerful than other computers in the networks is called as ______________. a. Client b. Server c. Hub d. Switch In SQL, name the clause that is used to place conditions on groups in contrast to WHERE clause that places conditions on individual rows. In SQL, what is the use of IS NULL operator? Write any one aggregate function used in SQL. Write any one TCL command? Which topology requires a central computer/controller? Identify the valid data type of SCHOOL out of given options: SCHOOL = 1,2,3,4 a. Integer b. List c. Tuple d. none of these 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Q17 If the following code is executed, what will be the output of the following code? str = "CBSE SAMPLE Question Papers 2020-21" print( str[ 3:-5 ]) Q18 In SQL, write the query to set a database EMPLOYEE active stored in a database. Q19 Write the expanded form of MIME. Q20 Name the column constraint which can prevent the entry of NULL values in a column? Q21 What is the full form of TDMA? Section-II Both the Case study based questions are compulsory. Attempt any 4 sub parts from each question. Each question carries 1 mark Q22 An Organization KVZONE tech is considering to maintain their Employees details using SQL to store the data. As a database administer, KVZONE has decided that : 1 1 1 1 1 a) Name of the data base KVZONE b) Name of the table Employee. c) The Attributes of a table as follows : a. EmpID - Numeric b. EName - String c. DeptNo - Numeric d. Gross - Float EmpID EName DeptNo Gross 100 ANUSHKA 10 25000 110 ARMAN 20 25000 111 GOURANG 10 36000 112 ASIF 30 20000 114 RAVI 30 22000 115 PRANAV 10 25000 102 NAVEESHA 20 30000 104 NULL 0 0 106 ABHISHEK 255 25666 a) Identify the attribute best suitable to be declared as a primary key. b) Write the degree and cardinality of the table EMPLOYEE c) Insert the following data into the attributes ItemNo, ItemName and SCode respectively in the given table EMPLOYEE. EmpID = 101 ; EName = Sunny ; DeptNo = 10 ; Gross = 25000 d) Aviral wants to remove the EMPLOYEE table s data, Which command will he use from the following: a) DELETE FROM EMPLOYEE; b) DROP TABLE EMPLOYEE; c) DROP DATABASE EMPLOYEE; d) DELETE EMPLOYEE FROM Amaze; e) Now Aviral wants to display the structure of the table Employee, i.e, name of attributes and their respective data types that he has used in the table. Write the query to display the same. Q23 Aman Singh of class 12A is writing a program to create a CSV file stu.csv which will contain ROLL NO and NAME for some students. He has written the following code. As a programmer, help him to successfully execute the given task. import _____________ # Line 1 def writeData(Roll,Name): # to write data into the CSV file fout=open(' user.csv','________') # Line 2 newFileWriter = csv.writer(fout) newFileWriter.writerow([Roll,Name]) fout.close() def readData(): # to read data from CSV file with open(' user.csv','r') as newFile: newFileReader = csv._________(newFile) # Line 3 1 1 1 1 1 for row in newFileReader: print (row[0],row[1]) newFile.______________ writeData(2, ABC ) writeData(15, XYZ ) writeData(12, PQR ) readData( ) a) b) c) d) e) # Line 4 #Line 5 Name the module he should import in Line 1. In which mode, Amar should open the file to add data into the file. Fill in the blank in Line 3 to read the data from a csv file. Fill in the blank in Line 4 to close the file. Write the output he will obtain while executing Line 5. 1 1 1 1 1 PART B SECTION I Q24 Evaluate the following expressions: a) 4* 6 + 15**2 // 5 4 b) (5 < 10) and (10 < 5) or (3 < 18) and not 8 < 18 Q25 Differentiate between MAN and WAN. OR Differentiate between LAN and PAN. Q26 Write two advantages of Micro wave transmission. Q27 Differentiate between Actual Argument(s) and Formal Parameter(s) with a suitable example for each. OR Explain the use of global key word used in a function with the help of a suitable example Q28 Rewrite the following code in Python after removing all syntax error(s). Underline each correction done in the code. for=20 for1=50: for3=for+for1+for2 2 2 2 2 2 print(for3) Q29 What are the possible outcome(s) executed from the following code? Also specify the maximum and minimum values that can be assigned to a variable Number. import random STR = CBSEONLINE NUMBER = random.randint(0,3) N= 9 while STR[N] != L : print ( STR[N] + STR[NUMBER] + # , end = ) NUMBER += 1 N=N-1 a) ES#NE#IO# b) EE# NO# IN# c) NS#IE#LO# d) EC#NB#IS# Q30 Find and write the output of the following python code: Msg="CompuTer" Msg1='' for i in range(0, len(Msg)): if Msg[i].isupper(): Msg1=Msg1+Msg[i].lower() elif i%2==0: Msg1=Msg1+'*' else: Msg1=Msg1+Msg[i].upper() print(Msg1) Q31 What do you understand by Foreign Key in a table? Give a suitable example of Foreign Key. 2 Q32 Write a recursive function to calculate the Fibonacci Series up to n terms. 2 Q33 Differentiate between file modes r+ and rb+ with respect to Python 2 2 2 Q34 Q35 Q36 Q37 Q38 Section-II Write a function LeftShift(Array,n) in Python, which accepts a list Array of numbers and n is a numeric value by which all elements of the list are shifted to left. Sample Input Data of the list Array= [ 10,20,30,40,12,11], n=2 Output Array = [30,40,12,11,10,20] Write a function in Python that counts the number of Me or My words present in a text file STORY.TXT . If the STORY.TXT contents are as follows: My first book was Me and My Family. It gave me chance to be Known to the world. The output of the function should be: Count of Me/My in file: 4 OR A text file Quotes.Txt has the following data written in it: Living a life you can be proud of Doing your best Spending your time with people and activities that are important to you Standing up for things that are right even when it s hard Becoming the best version of you Write a user defined function to display the total number of words present in the file. Write a function in Python PUSH (Arr), where Arr is a list of numbers. From this list push all numbers divisible by 5 into a stack implemented by using a list. Display the stack if it has at least one element, otherwise display appropriate error message. OR Write a function in Python POP (Arr), where Arr is a stack implemented by a list of numbers. The function returns the value deleted from the stack. Find and write the output of the following python code: def Change(P ,Q=30): P=P+Q Q=P-Q print( P,"#",Q) return (P) R=150 S=100 R=Change(R,S) print(R,"#",S) S=Change(S) Section-III 3 3 3 3 5 Q39 Trine Tech Corporation (TTC) is a professional consultancy company. The company is planning to set up their new offices in India with its hub at Hyderabad. As a network adviser, you have to understand their requirement and suggest them the best available solutions. Their queries are mentioned as (i) to (iv) below. 5 1. 2. Which will be the most appropriate block, where TTC should plan to install their server? Draw a block to block cable layout to connect all the buildings in the most appropriate manner for efficient communication. 3. What will be the best possible connectivity out of the following, you will suggest to connect the new set up of offices in Bangalore with its London based office. o Satellite Link o Infrared o Ethernet 4. Which of the following device will be suggested by you to connect each computer in each of the buildings? o Switch o Modem o Gateway 5. What is the difference between star topology and bus topology of network? Q40 A binary file Book.dat has structure [BookNo, Book_Name, Author, Price]. i. Write a user defined function CreateFile() to input data for a record and add to Book.dat . ii. Write a function CountRec(Author) in Python which accepts the Author name as parameter and count and return number of books by the given Author are stored in the binary file Book.dat OR A binary file STUDENT.DAT has structure (admission_number, Name, Percentage). Write a function countrec() in Python that would read contents of the file STUDENT.DAT and display the details of those students whose percentage is above 75. Also display number of students scoring above 75% 5 *******************************************************************

Formatting page ...

Tags : cbse pre boards, prelims 2015 - 2016, preliminary examinations, central board of secondary education, india schools, free question paper with answers, twelfth standard, xiith std, board exams, mock, model, sample, specimen, past, free guess papers.india, delhi, outside delhi, foreign, cbse class xii, cbse 12, 12th standard, cbse papers, cbse sample papers, cbse books, portal for cbse india, cbse question bank, cbse question papers with answers, pre board exam papers, cbse model test papers, solved board question papers of cbse last year, previous years solved question papers, free online cbse solved question paper, cbse syllabus, india cbse board sample questions papers, last 10 years cbse questions papers, cbse important questions, specimen / mock papers.

cbse12_pre_boards chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: