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

CBSE Class 12 Board Exam 2016 : Informatics Practices

11 pages, 50 questions, 0 questions with responses, 0 total responses,

	cbse12	+Fave Message
	Profile Timeline Uploads Q & A

Home > cbse12 >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

Formatting page ...

SET-4 Series ONS Code No. Candidates must write the Code on the title page of the answer-book. Roll No. 90 Please check that this question paper contains 11 printed pages. Code number given on the right hand side of the question paper should be written on the title page of the answer-book by the candidate. Please check that this question paper contains 7 questions. Please write down the Serial Number of the question before attempting it. 15 minute time has been allotted to read this question paper. The question paper will be distributed at 10.15 a.m. From 10.15 a.m. to 10.30 a.m., the students will read the question paper only and will not write any answer on the answer-book during this period. INFORMATICS PRACTICES Time allowed : 3 hours Maximum Marks : 70 General Instructions : (i) All questions are compulsory. (ii) Answer the questions after carefully reading the text. 90 1 P.T.O. 1. (a) (b) (c) (d) (e) 2. (a) (b) (c) (d) 90 Vidya College has three departments that are to be connected into a network. Which of the following communication medium (out of the given options), should be used by the college for connecting their departments for very effective High Speed communication ? Coaxial Cable Optical Fiber Ethernet Cable Also name the type of network (out of PAN/LAN/WAN) formed. State reason why Star topology requires more cable length than Bus topology. Seema needs a network device that should regenerate the signal over the same network before the signal becomes too weak or corrupted. Amit needs a network device to connect two different networks together that work upon different networking models so that the two networks can communicate properly. Name the devices that should be used by Seema and Amit. How is a domain name related to an IP address ? How is firewall useful in ensuring network security ? 2 Identify the odd one out of the following Java statements. State reason for your choice. (i) for (ii) do while (iii) switch (iv) while Write the purpose of parseInt( ) method. Identify invalid variable names out of the following. State reason if invalid. (i) for (ii) - salary (iii) salary12 (iv) product What is the difference between statements (i) and (ii) ? (i) t 5 2; (ii) if (t552) d53; 1 2 2 2 2 2 1 1 1 (e) Write HTML tags to do the following : (i) Inserting a horizontal line in a web page. (ii) Inserting a line break 2 (f) What does XML stand for ? How is the purpose of HTML different from XML ? 2 (g) Rewrite the following code using if else if statement : 2 switch(depcode) { case 1 : allowance 5 4000; break; case 2 : allowance 5 3200; break; default : allowance 5 1000; } 3. (a) What is the meaning of Open Source in the term Open Source Database Management System ? 1 (b) In a table Employee , a column Occupation contains many duplicate values. Which keyword would you use if you wish to list only different values ? 1 (c) How is ALTER TABLE statement different from UPDATE statement ? 1 (d) Charvi wants to delete the records where the FirstName is Rama in the Emp Table. She has entered the following SQL statement. An error is being displayed. Rewrite the correct statement. 1 DELETE Rama FirstName FROM Emp; 90 3 P.T.O. (e) (i) Name 2 Group (Aggregate) functions of SQL. (ii) Consider the table : 2 Table : Company CompanyCode Donations C101 C102 C104 C105 13000 NULL 7000 4000 What output will be displayed by the following SQL statement ? SELECT AVG(Donations) FROM Company; (f) Given below is the Emp table : 2 ENO NAME 1 Anita Khanna 2 Bishmeet Singh SET AUTOCOMMIT 5 0; INSERT INTO Emp VALUES (5, Farzia ); COMMIT; UPDATE Emp SET NAME 5 Farzziya WHERE ENO55; SAVEPOINT A; INSERT INTO Emp VALUES(6, Richard ); SAVEPOINT B; INSERT INTO Emp VALUES(7, Rajyalakshmi ); SAVEPOINT C; ROLLBACK TO B; What will be the output of the following SQL query now ? SELECT * FROM Emp; 90 4 2 (g) Consider the table below : Table : Company EMPID E101 E102 E103 E104 E105 E106 DEPARTMENT SALARY PERSONNEL 60000 ACCOUNTS 65000 MARKETING 40000 PERSONNEL 62000 PERSONNEL 50000 MARKETING 35000 Identify error(s) in the following SQL statement. Rewrite the correct SQL statement. SELECT Department, Salary FROM Company GROUP BY Department; 4. (a) Identify programming languages out of the following : 1 HTML, C11,JAVA, MySQL (b) Write Java statement to extract selected item from a given listbox named jList1. 1 (c) What will be displayed in jTextField1 and jTextField2 after the following code is executed : 1 int t; int x; x512; t5(3*x11)/3; jTextField1.setText('' ''1t); jTextField2.setText('' ''1x); 90 5 P.T.O. (d) Write the output that will be displayed in the textfields by the following Java code : 2 String x; String stream5 Commerce ; jTextField1.setText((stream.length()19)1'' ''); x5stream.concat( Humanities ); jTextField2.setText(x); jTextField3.setText('' ''1x.substring(2,5)); jTextField4.setText(stream.toLowerCase()); (e) Write the value that will be stored in variable sum after execution of following code : 2 int sum50,m54; for(int i59;i>56;i--) { if (i%3550) sum5sum1i; else sum5sum2i; } (f) The following code has error(s). Rewrite the correct code underlining all the corrections made : int a50; int b515; do ; a5a13; b5b23; while a<5b; 90 6 2 (g) Ms. Sharma works as a programmer in ABC Car Rental Company where she has designed a software to compute charges to be paid by the client. A screenshot of the same is shown below : A client can take any car out of Deluxe/SemiDeluxe/Ordinary for rent. A client can also opt for services of a guide. Charges vary depending on the type of car opted. Charges of services of Guide are extra. Help Ms. Sharma in writing the code to do the following : 90 7 P.T.O. (i) After selecting appropriate Radio Button and checkbox(if required), when CALCULATE button is clicked, Amount, Guide Charges and Total Amount should be calculated and displayed in the respective text fields. Category of Car Deluxe Car Semi Deluxe Car Ordinary Car 2 Amount (in C) 1000 per day 800 per day 700 per day Amount is obtained by multiplying per day charges of Car with number of days for which the car is taken. 2 If Guide Required checkbox is selected, Guide charges per day are ` 500.00. Guide Charges is calculated as : Car required for No. of days * 500; Total Amount 5Amount1Guide Charges (ii) 5. (a) When CLEAR button is clicked, all text fields and checkbox should be cleared. (iii) When CLOSE button is clicked,the application should close. 1 Srishti has created the following table with the name Veterinary . 2 Column Name Constraint AnimalId Primary Key VaccinationsDate AnimalName Not Null OwnerName One of the rows inserted is as follows : AnimalId VaccinationDate AnimalName OwnerName A101 2015-02-12 Sheru Amit Sharma (i) 90 1 What are the data type of columns VaccinationDate in the table Veterinary ? 8 AnimalId and (ii) Srishti is now trying to insert the following row : AnimalId VaccinationDate AnimalName OwnerName A102 2015-08-09 NULL Abhimanyu Shah Will she be able to successfully insert it ? Give reason. (b) (c) 2 Write the output of the following SQL queries : (i) SELECT MID( LearningIsFun ,2,4); (ii) SELECT ROUND(76.384,2); (iii) SELECT INSTR( INFORMATION FORM , RM ); (iv) SELECT DAYOFYEAR ( 2015201230 ); Table Order is shown below. Write commands in SQL for (i) to (iv) and output for (v) and (vi) 6 Table : Order OrderId O101 O102 O103 O104 O105 OrderDate 2015-09-12 2015-08-15 2015-11-01 2015-12-09 2015-11-10 SalesPerson OrderAmount Ravi Kumar 34000 Rashmi Arora 50000 Ravi Kumar 55000 Manjeet Singh 60000 Rashmi Arora 50000 (i) To display names of SalesPersons (without duplicates). (ii) To list OrderId and respective OrderAmount in descending order of orderAmount. (iii) To count the number of orders booked by SalesPersons with names starting with R . (iv) To list Order ids, order dates and order amounts that were booked after 1st September 2015. (v) SELECT OrderId, OrderAmount FROM Order OrderAmount between 50000 and 60000; (vi)SELECT concat (OrderId, length(SalesPerson) FROM Order; 90 9 where SalesPerson), P.T.O. 6. (a) Write SQL query to create a table Song with the following structure : Field Songid Title Duration ReleaseDate (b) 2 Type Constraint Integer Primary key Varchar (50) Integer Date 2 Consider the tables given below : Table : Party PartyId P101 P102 P103 P104 Description CostPerPerson Birthday 400 Wedding 700 Farewell 350 Engagement 450 Table : Client ClientId C101 C102 C103 C104 (c) Address A.K. Antony A-151, Adarsh Nagar Fauzia Aria K-5/52,Vikas Vihar Rashi Khanna D-6, Hakikat Nagar 76-A/2, MG Colony, S.K. Chandra Adarsh Avenue. Phone NoOfGuests PartyId 99101956 893466448 981166568 80 500 50 P101 P102 P101 65877756 100 P104 (i) Name the Primary keys in both the tables. (ii) P101 data is present twice in column PartyId in Client table - Is there any discrepancy ? Give reason for your answer. With reference to the above given tables (in Q6 b), Write commands in SQL for (i) and (ii) and output for (iii) given below : (i) 90 ClientName To display Client names of clients, their phone numbers, PartyId and party description who will have number of guests more than 50 for their parties. 10 6 (ii) To display Client Ids, their addresses, number of guests of those clients who have Adarsh anywhere in their addresses. ClientId ClientName Address Phone NoOfGuests PartyId (iii) S E L E C T ClientId, ClientName,NoOfGuests, description, Costperperson,FROM Client, Party WHERE Client.PartyId5Party.PartyId AND NoOfGuests BETWEEN 50 AND 100; 7. (a) How is an e-commerce business more cost effective than traditional business ? Write two points. 2 (b) How is e-learning beneficial for old people ? Write one point. 1 (c) Ms. Ariya is creating a form for PAN CARD application. Help her to choose most appropriate controls from ListBox, ComboBox, TextField, TextArea, RadioButton, CheckBox, Label and Command Button for the following entries. 2 S.No Function 1 To enter NAME 2 To enter MOBILE NUMBER 3 To allow user to choose one CATEGORY out of the categories : Company, Trust, Individual. 4 90 To enter NATURE OF BUSINESS/PROFESSION in the form of a paragraph 11 P.T.O.

Formatting page ...

Tags : cbse, cbse papers, cbse sample papers, cbse books, portal for cbse india, cbse question bank, central board of secondary education, cbse question papers with answers, prelims preliminary exams, 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 papers, cbse question papers 2017, cbse guess sample questions papers, cbse important questions, specimen / mock papers 2018.

cbse12 chat

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