Docstoc

Institute of Human Resources Development First Semester PGDCA

Document Sample
Institute of Human Resources Development First Semester PGDCA Powered By Docstoc
					Institute of Human Resources Development First Semester PGDCA Examination, December 2006 Scheme 2005 - Regular/Supplernentary PGDCA 101 COMPUTER ORGANIZATION

Time:3Hrs PART A (Answer all questions. Each carries 1 mark) Fill in the blanks

Maximum: 100 Marks

1......................computers are used in applications requiring very high precision. 2. According to De Morgan's law Al +A2+ A3+-........................ + An =.................. 3......................is a bistable device used to store 1 or 0. 4. DDR-266 memory chips are specified to run with.......................MHz. 5. AMD stands for............................... ,. . 6. Processors are cooled by .............................. 7. The no of pins in USB port is ............................ 8.................................is a method for linking two or more display cards together to get a single o/p. 9. In.....................type of scanner the scan head is moved while the paper remains stable. 10........................is the very first dual core processor: Select the most appropriate answer from the choices. 11. Flash memory is a type of a) EEPROM b) EPROM 12. Intel 915G refers to a) processor b ) display card c ) chipset d) NIC c) PROM d) ROM

13. RDRAMS are available in the form of a) DIMM b) SIMM c )DIP d) RIMM

14. Which of the following slots is not used to install HSPdevices like modems, soundcards & network cards. a) AMR 15. SATA means a) Synchronous ATA b ) Serial ATA State whether true or false 16. The wavelength of the laser beam used in DVDs is higher than that in CDs. 17. System's setup parameters are stored in a CMOS RAM chip. 18. FSB is the path between processor and main memory. 19. Athlon is a processor from Intel. 20. Printer is connected to the computer through parallel port. c) Standard AT A d) Symmetric ATA b ) AGP c ) ACR d) CNR

PARTB
(Answer any FIVE questions. Each carries 4 marks.) 21. Explain any one of the flip flops with a neat figure. 22. Compare ClSC & RISC processors. 23. What is a memory module? Explain the different types of memory modules available today. 24. Explain the various types of ports in a PC. 25. Write a short note on processor packages. 26. What is parallel processing? How it i& achieved using pipelining?

PART C (Answer any THREE questions. Eac~ carries 20 marks.)

27. a) (127.65)10 = (X)2. Find the value of X. b) 1011.10 - 1100.11 (using l's complement method) c) Why NAND & NOR gates are called universal gates? Prove it.

(3) (3) (6)

d) A logic circuit has three inputs A,B &, C.It generates an output of 1 only when A=0, B=1 , C=0 or A=I, B=l,C=0. Design a logic circuit for this system. 28. a) Explain the different DRAM type memories. b) Explain the different ways by which a hard disk can be interfaced. ( 8) (8) (12)

29. a) What is chip set? Explain the functions of southbridge & northbridge_chips in a chip set. . (10)

b )What is aninterrupt? Explain The different types, & the way in which they are handled. 30. a) Suggest the typical specification for a home PC. (10)

b) Explain construction and working of the different types of optical storage devices used in a computer. 31. Write short notes on the following. a) PCl Express b) SLl c) Scanners d) Hyperthreading e) CMOS (10) (5X4=20)

Institute of Human ResourcesDevelopment First Semester PGDCA Examination December 2006 Scheme 2005 - Regular(Supplementary) PGDCA I02 PROGRAMMING TECHNIQUES
Time:3Hrs PART A (Answer ALL questions.1 mark each) Maximum: 100 Marks

Choose the correct answer from the choice.
1 ......................variable tries to keep the value inside the processor a. preprocessor b. register c. automatic d. none of these

2. ................ is the insertion operator
a. << b. >> c. cout d. cin

3. Which of the following is not a keyword in C++ a. int . b. float c. struct d. array

*

4. ...............is used to give an alternate name to a data type a. reference b.& c. typedef d. none of these

5. ........................ constant is used to open a file in append mode) a. ios::apd Fill in the blanks 6. --- no. of bytes required for char data type b. ios::ate c. ios::ins d. ios::in .

7. --- key word represent the object of an invoking function.

8. --- is used to achieve runtime polymorphism
9. --- data members are called class variables

10. --- operator is used to give multiple initialization statement in a for loop 11. class type variables are called --'

12. Arguments used with the function definition are called --B. The expression -15%-2 evaluates to ------------14. A member function called by another member function of the same class is called ---

.
15. ---library function is used to combine two strings. State whether true or false 16. = is a relational operator in c++ 17. Run time errors are handled by using exceptiop handling 18. Default arguments are added from left to right 19. Static variables are initialized to zero at the time of declaration 20. Destructors can be overloaded PART B (Answer ANY FIVE questions. 4 marks each) 21. Explain switch statement with example 22. Explain different visibility labels of a class with example 23. What is meant by function overloading. Illustrate with example 24. Explain any 4 string manipulation functions with example 25. Compare call by value and call by reference 26. Draw a flowchart to find the largest among 3 numbers

PART C (AnswerANY THREE full questions.)

27. a. Explain various storage classes available in c++ b. What are the features of object oriented programming 28. a. What is meant by constructor. Explain different types of constructors b. Write a program to overload ++ operator for a class 29. a. What is meant by inheritance. Explain single and multilevel inheritance b. Explain reference variables with example c. Write a program to sort n names in alph~betical order 30. a. Declare a class to represent a bank account with the following members Data member 1. Name 2. Account number 3. Balance Member functions 1. To input data members 2. To deposit money 3. for withdrawal of money after checking a minimum balance of 100

(10) (10)

(10) (04) (06)

4. To display data members Write a program by using the above class to manage the Account of a customer b. Explain recursive functions with example 31. a. Write a program to copy one file to another b.Compare break and contiue statements c.Distinguish between structure and union (14) (06) (10) (05) (05)

Institute of Human Resources Development
First Semester PGDCA Examination, December 2006 Scheme 2005 - Regular/Supplementary PGDCA l03 OPERATING SYSTEMS
Time:3Hrs PART A Choose the correct answer. Each Question carries 1 Mark. 1.......................is the default shell in LINUX a) BASH b) C Shell c) Kom Shell d) SH Shell Maximum: 100 Marks

2........................is a multi user OS a) DOS b) Windows 3.1 c) Windows XP d) None

3............................uses cooperative multitasking. a) Windows NT b) UNIX c) Windows ME d) Windows 3.x

4............................is a non preempitive scheduling policy a) FCFS b) SRT c) HRN d)RR

5..................................is a communication command in LINUX a) GREP b)Talk c)Kill d) Nice

6. Which is the sufficient condition for deadlock? a) No preemption b) Resource Holding c) Circular wait d) Mutual exclusion 7 .................................is virtual memory technique a) Relocatable b) Demand paged c ) Single contiguous d) Paged

8...........................is also known as process scheduling a) High-Level b) Medium Level c) Low Level d) Job Scheduling

9. The time taken by the computer to respond to processing request is known as a) Turn around time b) Latency Time c) Response Time d)None

10. In LINUX, directory infonnation is stored in . a) Directory structure b) Shell c) mode d) Root

Fill in the blanks. Each Question carries 1 mark. 11. The action of creating a new process is called................................... 12. The activity of determining the optimum sequence and timing of assigning processes to processor is called................................. 13. If a resource can be used by only one process at a time, it is called............................. 14. IDE stands for....................................... 15.........................................is the part of 1he OS which deals with I/O related system calls. 16. The subdivision of work within a process is called................................... 17..................................is the shell in MSDOS. 18. PCB stands for...............................

19.........................memory management ref1ect the logical structure of the process. 20. GNOME stands for.................................. PART B Answer Any FIVE. Each Question carries 20 marks 21. Explain Fragmentation in memory management. 22. Explain any two low level scheduling policies. 23. Describe device drivers. 24. Briefly explain various functions of OS. 25. Give a brief explanation of directory structure. 26. What are threads? Explain. PART C Answer Any THREE. Each. Question carries 20 Marks 27. a) Define deadlock. Explain different strategies for managing deadlock (15 Marks)

b) What are the different communication commands in LINUX

(5 Marks)

28. a) With a neat diagram explain the life cycle of a process b) Give the concept of Biometric systems c) Give the structure of INODE 29. a) What is Mutual Exclusion? How it is acheived using Semaphore?

(8 Marks) (7 Marks) (5 Marks) (8 Marks)

b) What is virtual memOty? Explain the different virtual memory techniques used in memory management (12 Marks)

30. a) illustrate the features of Windows and Linux b) Explain SPOOLING and Buffering 31. Write notes on a) Cryptography b) KDE & GNOME d) Language processors c) Distributed System

(10 Marks) (10 Marks) (4*5=20 Marks)

Institute of Human Resources Development First Semester PGDCA Examination, December 2006] Scheme 2005 - Regular/Supplementary PGDCA I04 DATABASE MANAGEMENT SYSTEMS
Time:3Hrs Maximum: 100 Marks

PART A) (Answer all questions. Each question carries 1 mark) Choose the correct answer 1. The database schema is defied using ......................... a)DDL b) DML c) DCL d) TCL

2. Entity integrity is related with.................................. a) Super Key b) Candidate Key c) Primary Key d )Foreign key

3. In ER diagram rectangle represents................................. a) Entity Set b) Relationship c) Attribute d) None of these

4. Which of the following is a binary operator in relational algebra? a) UNION b) SELECTION c) DIVISION d) None of these

5. A relation is in 3NF if it is in 2 NF and eliminate..................... a) Functional Dependency b) Transitive Dependency c) Multivalued Dependency d) Join Dependency 6. The number of attributes in a relation is called..................... a) Cardinality b) Degree c) Join. d)none of these

7. ...................language is used to give privileges to a user. a) DCL b) DDL c) DML d ) none of these

8. In INGRESS database system.....................is used as a query language. a) QUEL b) QBE c) SQL d) none of these

9. Which of the following operator is used when the inner query returns more than one row in SQL? a) ALL b) ANY c) IN d) all of these

10. The degree to which data can be accessed despite the failure of some links is termed as a) Reliability Fill in the blanks 11. The layer of software between the physical database and the users is called --------------------. 12. --------------------- is the set of values from which actual column values are drawn. 13 The overall database design is called ---------------------------- . 14 ------------------converts DML statements embedded in an application program to normal procedure calls in host language. 15. ----------------is a shortened name assigned to a table or view that may there after used to refer it. b) Availability c) Access Time d) None of these

State whether true or false 16. The physical level describes the entire database. 17. Relational Algebra is a non-procedural language. 18. Sparse index is faster than dense index. 19. A relation with no multivalued dependency will be in 4NF. 20. ALTER command is used to change the contents of a table. PART B (Answer any FIVE questions. Each question catries 4 marks)

21. What is meant by data abstraction? 22. Explain B-tree. 23. What is meant by query optimization? 24. What is meant by data independence? What are its types? 25. What are the advantages of distributed databases. 26. What is the role of cursor in PL/SQL?

PARTC (Answer any TIIREE questions. Each question carries 20 marks) 27. a) What are the advantages of database systems? b) Distinguish between relational and network data models. (10) (10)

28. a) Explain with examples the operators SELECTION,ROJECTION, JOIN and DIVISION in relational algebra. (10)

b) What is meant by normalisation? Explain Second, Third and BCNF normal forms. (10)

29. a) Explain integrity and security in database systems.

(10)

b) What is concurrency control? Why it is needed? Explain different methods used for concurrency control? (10)

30.a) A table STUDENT contains columns REGNO, NAME and MARKS. Write a PL/SQL block to read the details of students and find the grade of each student. The grade is Distinction if marks>=75, First Class if marks>=60 , Second Class if marks>=50, Passed if marks>=40 and Failed otherwise. The REGNO,NAME and

GRADE details should store to the table RESULT.
b) Explain package with example. 31. Write short notes on a) Dangling Pointers b) Recovery techniques c) Concurrency Control d) Join Dependency e) Views in SQL

i

(12)
(8)

(5x4=20)

===============================================================