Page 1
DISTRICT LEVEL IIPUC PREPARATORY EXAM, JANUARY- 2025 Time: 3 Hours Sub: COMPUTER SCIENCE (41) Max. Marks: 70 PARI A Answer ALL the followingguestions. Each question carries 1mark: 15 x1 15 Select the correct answer from the choices given. (Repeated answer willnot be considered) 1. Where is L, cache located? (a) Motherboard (b) CPU (c) Control Unit (d) ALU 2. The involution of A is equal to (a) A (b) A (c) 1 (d) 0 3. The only gate that has 1input and 1output (a) AND (b) OR (c) NOT (d) X-OR 4. What is the function of Peek( ) operation (a)removes top item from stack (b) test stack is empty or not (c) returns the number of item in stack (d)returns top item from stack but does not remove 5. The class members can be accessed using operator (a) :: (Scope) (b). (dot) (c) & (address) (d) * (pointer) 6. The function overloading allows the user to create new (a) Data types (b)Variables (c) Abstract data types (d) Function types 7. Automatic initialization of object is carried out using a special member function called (a) Constructors (b) Destructors (c) Friend function (d) Inline functions 8. We can prevent multiple copies of base class being present in an object, from those objects by declaring the base class as (a) Virtual (b) Abstract (c) Derived (d) Private 9. An example for array of pointer declaration is (a) int a[10]: (b) int "a[10]; (c) both (a) and(b) (d) None of the above 10.Which of the following is any set of one or more columns whose combined values are unique among alloccurrences? (a) Candidate key (b) Foreign key (c) Alternate key (d) Super key 11.one Which of the following is used to sort the data in ascending or descending order, based on or more columns in SQL? (a) Order by (b) Group by (c) Where (d) Arrange 12.ldentify the device used to boost up a weak signal (a) Modem (b) Repeater (c) Switch (d) Router 13. Which of the following isn't a type of transmission mode? (a) Physical (b) Simplex (c) Fullduplex (d) Half duplex 14. Which of the following responds to the requests made by web browsers? (a) Web browser (b) Web server (c) Www (World Wide Web) (d) Telnet 15. Which of the following tag display the bullets? (a) <ul> (b)<ol> (c) <li> (d)<d> P.T.0.
Page 2
lI. Fillin the blanks choosing the appropriate word / words from those given in brackets: 5 x1 =5 (Repeated answers will not be considered) (Hierarchícal, Number, random file organization, tuple, Network, Microsoft access) 16. is anexample for DBMS Software. 17. is a data model that follows tree structure. 18.Each row in a table is called 19. stores data in random order in database. 20.An example for data type used in DBMS is PARI=B II. Answer any FOUR of the following Questions. Each question carries 2 marks: 4 x 2 =8 21.State and prove idempotence law. 22. Realize OR gate using NANDgate. 23.What are parameterized constructors? What is the advantage? 24.Name the streams generally used for file l/0. 25. Give the difference between data and information. 26.Write the syntax and example of DROP command. 27.Write any two group built - in functions in SQL. PART =C 12 IV. Answer any FOUR of the following Questions. Each question carries 3 marks: 4 x 3 = 28.Explain any three components ofa motherboard. 29.Explain any three operations performed on stacks. 30.Give any three differences between static and dynamic memory allocation. 31.Explain: (a) get() (b)getline () (c) read( ) 32.Write any three differences between manual and electronic data processing. 33.Write any three services used in E - Commerce. 34. What is web hosting? Mention the types of web hosting. PART D V. Answer any FOUR of the following Questions. Each question carries 5 marks: 4 x 5= 20 35. Explain the operations performed on liner array. 36. Write an algorithm to insert an item into the queue. 37. Mention the different applications of OOP. 38.What is an inline function? Explain with programming example. 39. Explain destructors with syntax and example. 40.What is inheritance? Explain hierarchical and hybrid inheritance. 41.What is topology? Explain any two topologies of networking. VI. Answer anyTWO of the following Questions. Each question carries 5 marks: 2 x5= 10 42. Give the Boolean function F(A, B, C, D)= )(0,1,2,3,4,5,8,9,10,11,13,15). Reduce the function F using k- map. 43. Define aclass named triangle with following conditions: (i) Date members: breath and height (ü) Member functions: getdata() and putdata() (iii) Define member functions outside the class to input and output breath and height values. 44. Give SQL commands to create EMPLOYEE table and find the Gross salary (basicsalary+DA), for the year and Calculate the DA as 45% of basic salary, income tax is 20% of yearly salary >5,00,000 and income tax is 10% If the yearly salary is <5,00,000. Emp. No. Name Basic salary DA Gross SalaryYearly salary Income tax