CBSE Computer Science Sample Paper12 Class XII 2011

http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com Sample Paper – 2011 Class – XII Subject – Computer Science Time allowed : 3 hours Maximum Marks : 70 Instructions : (i) All questions are compulsory (ii) Programming Language : C++ 1. (a) Write the major differences between Object Oriented Programming and Procedural Programming. (2) (b) Name the header file, to which following built-in function belong: (1) puts (2) toupper (3) isdigit (4) atoi (2) ( C) Write the output of the follwoing program segment char *NAME="CoMpuTeR"; for(int x=0;x>name; cin>>place; } void display() { cout<> Jokeid; cin>> Type; } void display() { cout<< Jokeid; cout<< Type; } }; 2 V (a)Write SQL commands for (a) to ( j) and write output for (h) on the basis of Teacher relation given below. No Name Age Department Date of Join Salary Sex 1. jigal 34 Computer 10/01/97 12000 M 2. Sharmila 31 History 24/03/98 20000 F 3. Sandeep 32 Maths 12/12/96 30000 M 4. Sangeeta 35 History 01/07/99 40000 F 5. Rakesh 42 Maths 05/09/97 25000 M 6. Shyam 50 History 27/02/97 30000 M 7. Shiv Om 44 Computer 25/02/97 21000 M 8. Shalakha 33 Maths 31/07/97 20000 F (a) To show all information about the teacher of history department. (b) To list the names of female teachers who are in Maths department http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com (c) To list names of all teachers with their date of joining in ascending order. (d) To display students name, fee,age for male teacher only (e) To count the number of teachers with age>23. (f) To insert a new row in the TEACHER table with the following data: 9,”Raja”,26,”Computer”,13/05/95,2300,”M”. (g)To show all information about the teachers in this table (h)Add a new column named “Address”. (i)Arrange the whole table in the alphabetical order to name (j)Display the age of the teachers whose name starts with „S,. (k)Give the output of following statement. (i) Select COUNT(distinct department) from TEACHER. (ii) Select MAX(Age)from Teacher where sex=”F” (iii) Select AVG(Salary) from Teacher where Dateofjoin<12/07/96 (iv) Select SUM(Salary) from teacher where Dateofjoin<12/07/96 (14) (b) Define the following terms: (m) Primary Key (ii) Candidate key (1) VI(a) State and verify Demorgans Laws (2) (b)Write the equivalent Boolean expression for the following Circuit (1) ( c) For the given truth table, give canonical sum-of-products(SOP) and canonical product-of-sum (POS) expression X Y Z F 0 0 0 0 0 0 1 1 0 1 0 0 0 1 1 0 1 0 0 1 1 0 1 1 http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com 1 1 0 0 1 1 1 1 (2) (d) If F(a,b,c,d)= (1,3,4,5,7,9,11,12,13,15) obtain the simplified form using K-Map (2) (e) Write the dual of the Boolean Expression: (B` + C) + A (f) Represent the Boolean expression (X+Y)(Y+Z)(X+Z) with help of NOR gate only (g) Represent the Boolean function F(X,Y,Z)= (X`+Y)(Y`+Z) with help of NOR gate only VII (a) Write one advantage and one disadvantage of the following topologies in network: (i)BUS Topology (ii) STAR Topology (iii) RING Topology (1) (b) Define Circuit Switching and Packet Switching (1) (c) Give one advantage and one disadvantage of optical fibre and coaxial cable used in communication. (1) (d) Explain the following terms (1) Repeater (2) TCP\IP (2) (d) Knowledge Supplement Organization has set up its new center at Mangalore for its office and web based activities. It has 4 blocks of buildings as shown in the diagram below. Block A Block B (i) Suggest a cable layout of connections between the blocks. Block C Block D http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com (ii) Suggest the most suitable place(i.e.block ) to house the server of this organization with a suitable reason. (iii) Suggest the placement of the following devices with justification. (a) Repeater (b) Hub/Switch (iv) The organization is planning to link its front office situated in the city in a Hilly region where cable connection is not feasible, suggest an economic way to connect it with reasonably high speed. (2) SHEKHAR TRIPATHI PGT Comp Sc DELHI PUBLIC SCHOOL BULANDSHAHR UP E Mail : etwshekhar@gmail.com