MASTER OF COMPUTER APPLICATIONS
(PGDCA/MCA 1st Yr)
ASSIGNMENTS
Year 2012
JAIPUR NATIONAL UNIVERSITY
JAIPUR
Course Code | : | PGDCA/MCA – 101 |
Course Title | : | Fundamental of Computer |
Maximum Marks | : | 30 |
There are Three questions in this assignment. Answer all questions. All questions
are equal marks.
Q.1 a) Write a note on
a) Third generation computers.
b) Write the applications of computer in business.
c) With a neat diagram, explain the functional unit of computer.
d) Explain application software.
Q.2 a) Write notes on :
a) RAM and ROM
b) Optical media.
c) What are sign numbers and explain the conditions of overflow and underflow by
using 2’s complement?.
b) Explain different items in desktop.
c) LAN and WAN
d) What is a transmission mode? Explain various transmission modes of data.
Q 3. Write notes on :
a) Computer virus
b) E-mail.
c) Topologies
d) De Morgan’s Theorem
Course Code | : | PGDCA/MCA – 102 |
Course Title | : | PC Software |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q.1 (a) What is Mail Merge? Write all steps to create mail merge.
(b) Write short note on.
(a) Goal Seek
(b) Function in Excel
(c) Differentiate between VLOOKUP() AND HLOOKUP() functions in MS_EXCEL.
(c) Define Macro. Write steps to create Macro.
Q.2 (a) What is a template ? Explain with an example.
(b) Explain the process of Auto Correct.
(c) Write steps to perform the following tasks:-
(i) Setting up a mail account
(ii) Applying stationery
(iii) Sending & Receiving Mails
(iv) Creating a contact in Address Book
Q.3 (a) Explain the ways to apply transition in slides.
(b) How do you draw different shapes using AutoShapes.
(c) Explain the process to insert sound & Image in Power Point Presentation.
Course Code | : | PGDCA/MCA – 103 |
Course Title | : | Database Management System |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q.1 (a) List Five Responsibilities of the DB manager.
(b) Give the limitations of E-R model? How do you overcome this?
(c) What are the types of transparencies that a distributed database must support? Why?
Q.2 (a) What is an active database?
(b) (i) Highlight the features of object oriented database
(Ii) Compare file system with database system (
(c) Explain the architecture of DBMS. (
Q.3 (a) What are the steps involved in designing a database application? Explain with an
application.
(b) What is Normalization? Explain 1NF, 2NF, 3NF and BCNF with suitable example
(c) What is concurrency control? How is it implemented in DBMS? Explain.
Course Code | : | PGDCA/MCA – 104 |
Course Title | : | Programming in ‘C’ & Data Structure |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q1 (a) Differentiate between call by value & call by reference. Explain recursive function with
an example.
(b) Write a ‘C’ program to find a second largest number from the single array of 10 values.
(c) What are pre-processor directives? And also define command line arguments?
Q.2 (a) Create a structure student with data members roll no., name, and write a program to read & display data of 5 students?
(b) Explain user define function? Differentiate between user defined & Library function?
(c) Write a ‘C’ program to find largest between 3 numbers using recursive function.
Q3 (a) Describe stack and write algorithm for push and pop operations.
(b) What are the difference between tree and binary tree? Give an example to differentiate
pre-order and post order traversals.
(c) Define push table? Describe the difference between quick sort and merge sort with an
example
Course Code | : | PGDCA/MCA – 105 |
Course Title | : | Operating System Principles |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q1 (a) Define file. Discuss various file operations including file structure, file sharing and
file protection.
(b) Define deadlock. What are the different methods to solve the deadlock problem?
Explain deadlock prevention algorithms.
(c) What is operating system? Describe the following operating system:-
(i) Batch processing system (ii) Time sharing system
(iii) Real time system (iv) Personal Computer system
Q2 (a) Explain the following:-
(i) Paging
(ii) Segmentation
(iii) Swapping
(iv) Fragmentation
(b) Explain First Fit, Best Fit and Worst Fit allocation algorithm.
(C) Define the concept of demand paging. Explain hardware support for demand
paging.
Q3 (a) Explain the following page replacement algorithm:-
(i) FIFO
(ii) LRU
(iii) Optimal
(iv) Second chance algorithm
(b) What do you understand by I/O Interface. Explain various I/O techniques.
(c) What is disk scheduling? Explain FCFS and SSTF scheduling techniques.
Course Code | : | PGDCA/MCA – 106 |
Course Title | : | Computer Networks & Internet Concept |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q1 (a) What is OSI security architecture? Explain different approaches of security model
and different phases of security lifecycle.
(b) What do you mean by E-Commerce? How computer is useful in e-governance and
common public services?
(c) What is digital signature? Explain the properties and requirements of digital
signature.
Q2 (a) Define a Virus? What are the typical phases of operation of virus or worms?
Differentiate between Trojan horse, Virus and worms.
(b) Explain the following:
(i) IP Address
(ii) URL
(iii) DNS
(iv) Subnet Mask
(c) Explain the ATM reference model. Define ATM virtual circuit.
Q3 (a) Distinguish between peer to peer and client server network. Explain advantage
and disadvantage of Network.
(b) Differentiate between IEEE 802.3, 802.4 and 802.5 standards. Explain frame
format of the above.
(c) Write short notes on :-
(i) FTP
(ii) DHCP
(iii) NFS
(iv) SMTP
(v) TCP/IP
Course Code | : | PGDCA/MCA – 107 |
Course Title | : | System Analysis & Design |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q1 (a) Why is data processing essential? Explain advantage and disadvantages of manual
and electronic data processing comparing them.
(b) What do you mean by nature of information and principal source of information?
(c) What are the measures of Physical security? Explain it?
Q2 (a) What is system development life cycle? How it is related to system analysis?
Differentiate between system analysis and system designing.
(b) Define the system. Explain its features. Describe the different types of systems.
(c) What do you mean by system testing? What are the levels of quality assurance?
Explain briefly.
Q3 (a) How many types of software’s are there? Explain the various phases of hardware
and software selection processes.
(b) What do you mean by system security? What are the measures of physical
security? Explain.
(c) What is normalization? Explain different forms of normalization?
Course Code | : | PGDCA/MCA – 108 |
Course Title | : | OOP’s Programming Using in ‘C++’ |
Maximum Marks | : | 30 |
There are three questions in this assignment. Answer all the questions. All Questions are equal marks.
Q1 (a) What is polymorphism? What are the difference between compile time and run
time polymorphism?
(b) Explain different types of data types with example.
(c) What is virtual base class? How do you pass base class constructors in the
derived class?
Q2 (a) What is inheritance? Explain various types of inheritances with example to
show inheritance.
(b) What are manipulators? How do you use manipulators to format I/O? Explain.
(c) What is constructor? Explain default constructor and implicit constructor? Give an
example to declare multiple constructor in a class.
Q3 (a) What is inline function? What is difference between friend function and inline
function?
(b) What is function overloading and operation overloading? Give a suitable example
to show the both types of overloading.
(c) Write short notes on :-
(i) Recursion
(ii) Command line arguments
(iii) Storage class specifies
