Thursday, September 28, 2017

IJP Assignment

INTERNET JAVA PROGRAMMING  ASSIGNMENT 1


1. Explain basic concepts of OOPS.
2. Why is JAVA known as platform independent language
3. How is JAVA more secure than other languages
4. Describe in detail the steps involved I implementing a stand-alone program
5. WAP to find the number and sum of all integers greater than 100 and less than 2000 that are divisible by 7
6. WAP to compute the sum of digits of a given integer number
7. Explain the following: a. Static Members b. Final Method c. Final Class d. Abstract class e. Abstract method
8. How does String class differ from StringBuffer Class
9. Give an example where the interface can be used to support multiple inheritance. Give Example
10. Discuss Various levels of access protection available for packages and their implications 

Saturday, July 29, 2017

Internet and Java Programming Important Questions- MCA-302

Important 20 Questions

Course:                       M.C.A
Subject:                       Internet and Java Programming
Paper Code:                MCA-302
Semester:                    III

Questions from Unit I

Q.1. What is the Internet? Explain type of Internet connections
Q.2. What is E-mail? Explain advantages of E-mail.
Q.3. What do you mean by Video conferencing? Explain type and benefits of Video conferencing.
Q.4. Explain purpose of following
        a) XML b) HTMP c) DNS d) ISP e) JVM f) ISDN & FTP
Questions from Unit II
1. What is the difference between a constructor and a method?
2. What is the difference between an Interface and an Abstract class?
3. Explain different way of using thread? Also, define multithreading.
4. Write short notes on
     (a) What are the different ways to handle exceptions?
     (b) What is the difference between Overriding and Overloading?
     (c)What is string buffer? How does it differ from a string? Give the three ways of creating a string object.
    (d) Explain the usage of Java packages.
    (e) What is the “java applet? What is the life cycle of Java Applets?
    (f)  What is an interface? What is the use of interface?
Questions from Unit III
Q1. The difference between Swing and AWT?
Q2. Which method can be used to obtain the length of the String? How do you concatenate Strings?
Q3. Which method can be used to compare two strings for equality? Which method can be used to perform a comparison between strings that ignores case differences?
Q4. Short Notes.
a. HTTP request, Write programs in Java using sockets programming.
b. What is meant by Stream and what are the types of Streams and classes of the Streams?
Questions from Unit IV
Q1. What is a Java Bean? Discuss the state of bean state of Bean. In this reference describe indexed properties of a class with the help of suitable example.
Q2. What do you mean by JAR filters? Discuss.
Q3.What is the difference between the Reader/Writer class hierarchy and the InputStream/OutputStream class hierarchy?
Q4. How do I select a URL from my Applet and send the browser to that page?
Questions from Unit V

Q1. Discuss the role of JSP in the development of a website.
Q2. Explain the basic components of JDBC. Explain in detail the different drivers of JDBC.
Q3. Define following in brief:
i. Servlet Life Cycle.
ii. Net Bean.
Q4. Explain the steps to create RMI based clients and server. Explain the various methods for registering and gaining access to the Remote Object.

DBMS List of Lab Exercises


SCA of Computer Application
DBMS Lab
IFTM,University,Moradabad


1 Database Schema for a customer-sale scenario
Customer(Cust id : integer, cust_name: string)
Item(item_id: integer, item_name: string, price: integer)
Sale(bill_no: integer, bill_data: date, cust_id: integer,
item_id: integer, qty_sold: integer)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the bills for the current date with the customer names
and item numbers
d) List the total Bill details with the quantity sold, price of the
item and the final amount
e) List the details of the customer who have bought a
product which has a price>200
f) Give a count of how many products have been bought by
each customer
g) Give a list of products bought by a customer having
cust_id as 5
h) List the item details which are sold as of today
i) Create a view which lists out the bill_no, bill_date,
cust_id, item_id, price, qty_sold, amount
Create a view which lists the daily sales date wise for the last
one week

2 Database Schema for a Student Library scenario
Student(Stud_no : integer, Stud_name: string)
Membership(Mem_no: integer, Stud_no: integer)
Book(book_no: integer, book_name:string, author: string)
Iss_rec(iss_no:integer, iss_date: date, Mem_no: integer,
book_no: integer)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the student names with their membership numbers
d) List all the issues for the current date with a student .
e) List the details of students who borrowed book whose author is ABC.
f) Give a count of how many books have been bought by each student
g) Give a list of books taken by student with stud_no as 5
h) List the book details which are issued as of today
i) Create a view which lists out the iss_no, iss _date,stud_name, book name
j) Create a view which lists the daily issues-date wise for the last one week
3 Database Schema for an Employee-pay scenario
employee(emp_id : integer, emp_name: string)
department(dept_id: integer, dept_name:string)
paydetails(emp_id : integer, dept_id: integer, basic: integer,
deductions: integer, additions: integer, DOJ: date)
payroll(emp_id : integer, pay_date: date)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity
constraints
b) Insert around 10 records in each of the tables
c) List the employee details department wise
d) List all the employee names who joined after particular date
e) List the details of employees whose basic salary is between 10,000 and 20,000
f) Give a count of how many employees are working in each department
g) Give a name of the employees whose netsalary>10,000
h) List the details for an employee_id=5
i) Create a view which lists out the emp_name, department, basic, deductions, net salary
j) Create a view which lists the emp_name and his net salary
4 Database Schema for a Video Library scenario
Customer(cust_no: integer,cust_name: string)
Membership(Mem_no: integer, cust_no: integer)
Cassette(cass_no:integer, cass_name:string, Language:
String) Iss_rec(iss_no: integer, iss_date: date, mem_no: integer,
cass_no: integer)

For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the customer names with their membership
numbers
d) List all the issues for the current date with the customer
names and cassette names
e) List the details of the customer who has borrowed the
cassette whose title is “ The Legend”
f) Give a count of how many cassettes have been borrowed
by each customer
g) Give a list of book which has been taken by the student
with mem_no as 5
h) List the cassettes issues for today
i) Create a view which lists outs the iss_no, iss_date,
cust_name, cass_name
j) Create a view which lists issues-date wise for the last one
week
5 Database Schema for a student-Lab scenario
Student(stud_no: integer, stud_name: string, class: string)
Class(class: string, descrip: string)
Lab(mach_no: integer, Lab_no: integer, description: String)
Allotment(Stud_no: Integer, mach_no: integer, day of week: string)
For the above schema, perform the following—
a) Create the tables with the appropriate integrity constraints
b) Insert around 10 records in each of the tables
c) List all the machine allotments with the student names,
lab and machine numbers
d) List the total number of lab allotments day wise
e) Give a count of how many machines have been allocated
to the ‘CSIT’ class
f) Give a machine allotment etails of the stud_no 5 with his
personal and class details
g) Count for how many machines have been allocated in
Lab_no 1 for the day of the week as “Monday”
h) How many students class wise have allocated machines in
the labs
i) Create a view which lists out the stud_no, stud_name,
mach_no, lab_no, day of week
j) Create a view which lists the machine allotment details for
“Thursday”.
6 Write a program to find the largest number from the given three numbers.
7 Simple programs using a loop, while and for iterative control statement.
8 Write a program to check whether the given number is Armstrong or not
9 Write a program to generate all prime numbers below 100.
10 Write a program to demonstrate the GOTO statement.
11 Write a program to demonstrate %type and %rowtype attributes
12 Write a program to demonstrate predefined exceptions
13 Write a program to demonstrate user defined exceptions
14 Create a cursor, which displays all employee numbers and names from the EMP table.
15 Create a cursor, which updates the salaries of all employees as per the given data.
16 Create a cursor, which displays names of employees having salary > 50000.
17 Create a procedure to find reverse of a given number
18 Create a procedure to update the salaries of all employees as per the given data
19 Create a procedure to demonstrate IN, OUT and INOUT parameters
20 Create a function to check whether given string is palindrome or not.
21 Create a function to find the sum of salaries of all employees working in depart number 10.
22 Create a trigger before/after update on employee table for each row/statement.
23 Create a trigger before/after delete on employee table for each row/statement.
24 Create a trigger before/after insert on employee table for each row/statement.
25 Create a Form to display employee details using SQL
26 Create a Report to generate all employee annual salaries….

Additional Programs
S. No Name of the Program
1 Create a form using Forms 6i to display Employee table data.
2 Create a Master/details relationship form which performs Add New, Search, Delete, Save and Update on the records
3 Generate a report to calculate employee’s salaries department wise from employee table.
4 Create a Report to generate the details of employee table including sum and average salaries department wise.

Assignments and Question Bank(Data communication and Networking)


SCA,IFTM University,Moradabad
ASSIGNMENTS(Data communication and Networking)
MCA/BCA


(a) ASSIGNMENT-1

1. What is mean by data communication?
2. What are the three criteria necessary for an effective and efficient network?
3. What are the three fundamental characteristics determine the effectiveness of data
communication system?
4. What are the advantages of distributed processing?
5. Why are protocols needed?
6. Why are standards needed?
7. For n devices in a network, what is the number of cable links required for a
mesh and ring topology?
8. What is the difference between a passive and an active hub?
9. Distinguish between peer-to- peer relationship and a primary-secondary
relationship.
10. Assume 6 devices are arranged in a mesh topology. How many cables are
needed? How many ports are needed for each device?
11. Group the OSI layers by function.
12. What are header and trailers and how do they get added and removed?
13. The transport layer creates a communication between the source and
destination. What are the three events involved in a connection?
14. What is the DC component?
15. List out the advantages and drawbacks of bus topology.
16. List out the advantages and drawbacks of the ring topology.
17. Why star topology is commonly preferred?
18. Is there any relationship between transmission media and topology?
19. What are the functions of OSI layers? Discuss.
20. Explain in detail about the types of topologies.
21. Explain detail about the transmission media for data transmission.
22. a. i. What is a protocol? List the three key elements of a protocol.
ii. With relevant examples differentiate between simplex, half duplex, and full duplex
communication.
23. Explain ISO OSI in detail with an explanation of each layer explicitly.
24. Explain TCP/IP.

25. Differentiate between OSI and TCP/IP.
26. Which of the following protocols are examples of TCP/IP transport layer protocols?
a. Ethernet
b. HTTP
c. IP
d. UDP
e. SMTP
27. What are the major advantages of STP over UTP?
28. Describe the components of fiber optic cable. Draw a picture.
29. What is the difference between network layer delivery and transport layer delivery?
30. What are the principles that were applied to arrive at the seven layers in OSI model?
31. Why transport layer protocols like TCP and UDP are called end-to- end protocols. W
is the difference between them?
32. Differentiate between:
(i) Baseband coaxial cable and broad band coaxial cable
(ii) Optical fiber and twisted pair

(b)ASSIGNMENT-2

1. What is the difference between a protocol and a service interface? Explain in terms of a
ISO seven layer model.
2. a. List the four properties by which transmission media can differ
b. Three packet switching networks each contain n nodes. The networks have a star
topology with a central switch, a ring respectively and a third is fully interconnected with
a wire from every node to every other node. What are the best, average and worst case
transmission paths in hops?
3. a. Describe the key elements of protocols and the standards.
b. Explain in detail the data transmission in OSI reference model.
4. What are the responsibilities of data link layer?
5. Mention the types of errors.
6. Define the following terms.
7. What is the redundancy?
8. List out the available detection methods.
9. Write short notes on VRC.
10. Write short notes on LRC.
11. Write short notes on CRC.
12.Write short notes on CRC generator.
13. Write short notes on CRC checker.
14. Give the essential properties for a polynomial.
15. Define checksum.
16. What are the steps followed in checksum generator?
17. List out the steps followed is checksum checker side.
18. Write short notes on error correction.
19. Mention the types of error correcting methods.
20. What is the purpose of hamming code?
21.Define flow control.
22. What is a buffer?
23. Mention the categories of flow control.

(H) ASSIGNMENT-3

1. a. Define CRC. Explain CRC generator & CRC checks in detail with one example
b. Explain in detail about error correction using Hamming code.
2. Explain HDLC and explain it in detail.
3. a. Given a 10 bit sequence 1010011110 and a divisor of 1011 find the CRC. Check the
answer.
b. Bit stuff the following data
i.0001111110111110011110011111001
ii. 00011111111111111111111111111111111110011111001
4. What is IEEE 802.3? What are the types of Ethernet? Discuss.
5. Draw the sender and receiver window for a system using Go Back N ARQ and
selective repeat ARQ, given the following
a. Frame 0 is sent, frame 0 is acknowledged
b. Frames 1 and 2 are sent, frames 1 and 2 are acknowledged
c. Frames 3,4 and 5 are sent; frame 4 is acknowledged; timer for frame 5 expired.
Frames 5,6
and 7 are sent; frames 4 through 7 are acknowledged
6. Discuss Token Bus & Token Ring networks in detail.
7. Define FDDI & its needs in detail.
8. a. What is SONET?
b. Name some layers of SONET &its functions.
c. Discuss SONET frame in detail with a neat diagram.
9. a. Define bridges?
b. Difference between bridges and repeaters.
c. Explain the loop problems solved by bridges.
10. What are the network support layers and the user support layers?
11. With a neat diagram explain the relationship of IEEE Project to the OSI model?
12. What are the functions of LLC?
13. What are the functions of MAC?
14. What is protocol data unit?
15. What are headers and trailers and how do they get added and removed?
16. What are the responsibilities of network layer?
17. What is a virtual circuit?
18. What are data grams?
19. What are the two types of implementation formats in virtual circuits?
20. What is meant by switched virtual circuit?
21. What is meant by Permanent virtual circuit?
22. Define Routers.
23. Define DNS and explain the major sections of DNS in detail?
24. With a neat diagram explain the basic model of FTP?
25. What is public key cryptography and explain RSA in detail with one example.
26. Explain various types of substitution techniques.
27. a. SMTP, FTP and HTTP are protocols to transfer messages from one point to
another. Compare and contrast their use
b. Write short notes on HTTP Request and Response messages
28. Explain in detail about SMTP.
29. a. Use the following encryption algorithm to encrypt the message,
a. Replace each character with its ASCII code
b. Add a 0 bit at the left to make each character 8 bits longc. Swap the first 4 bits
with the last 4 bits.d. Replace every 4 bits with its hexadecimal equivalent What is the
key in this method

30. Using the RSA algorithm, encrypt and decrypt the message “BE” with key pairs(3,15)
and (5,15).


Sample Questions

1. What are the major advantages of STP over UTP?
2. Describe the components of fiber optic cable. Draw a picture.
3. Why are slots used in DQDB?
4. What is the difference between network layer delivery and transport layer
delivery?
5. How can a device have more than one IP address?
6. Which control bit is involved in setting up a TCP session?
7. What factors effect the data rate of a link?
8. What are the advantages of FDDI over a basic token ring?
9. What 3 functions can SNMP perform to manage network devices?
10. What is the purpose of the timer at the sender in systems using ARQ?
11. Is there any drawback of using piggybacking?
12. Which of the following address does not belong to the same network(no
subnetting)? Explain why?

1. 130.31.23.31
2. 130.31.24.22
3. 130.32.23.21
4. 130.31.21.23
1. What are the two reasons for using layered protocols?
2. What do you mean by link to link layers of OSI reference model? Explain their
functions briefly?
3. Write a short note on ISDN?
4. What is the difference between boundary level masking and non- boundary level
masking? Give examples
5. Draw the IP datagram header format. “IP datagram has a checksum field still it is
called an unreliable protocol”. Justify?
6. What are the principles that were applied to arrive at the seven layers in OSI
model?
7. Explain the working of 3-bit sliding window protocol with suitable example.
8. Explain the following ARQ techniques in detail
1. Stop and wait for ARQ
2. Selective repeat ARQ

9. What are the reasons for using layered protocols?
10. 10 Enumerate the main responsibilities of data link layer?
11. Is the Nyquist theorem true for optical fiber or only for copper wire? Explain.
12. Why do data link layer protocols position the checksum in the trailer and not in
the header?
13. Compare the maximum window size in go-back- N and selective-repeat ARQs.
14. Why does ATM use the cell of small and fixed length?
15. Give the equivalent binary word for the polynomial x 8 +x 2 +x+1.
16. In which of the 7 layers of OSI will a service handling conversion of characters is
from EBCDIC to ASCII be normally implemented?
17. Where is the special IP address 127.0.0.0? used ?
18. Convert the IP address 197.228.17.56 into binary ?
19. Compare satellite with fiber as a communication medium and enumerate the
application areas where satellite still holds a niche(or special)marker.
20. A binary signal is sent over a 3-khz channel whose signal-to- noise ratio is 20
db.Calculate the maximum achievable data rate ?
21. What does ‘data transparency’ mean ? With the help of a flow chart, explain the
process of bit de-stuffing at the receiver’s end.
22. Assuming classful addressing, find the no of subnets and the no of hosts per
subnet foe the following blocks:
(i) 122.45.77.32/20

(ii) A class B block having mask of 255.255.192.0
23. Write short note on any four of the following:
(a) The ATM reference model
(b) HDLC
(c) Salient difference between ISO-OSI and TCP/IP models.
(d) Network Topologies and their uses.
(e) Wireless networks.
24. (a) Differentiate between static and dynamic channel allocation.
(b) List out the main responsibilities of the network layer.
(c) Give two examples of a ‘collision-free’ protocol ?
(d) Why is IP called ‘best-effort delivery’ protocol?
(e) What is a transparent bridge?
(f) what are the two sub layers of data link layer called ?
(g) What are the other names of IEEE 802.11 protocol or standard?
(h) What is the baud rate of a standard 10 mbps Ethernet LAN ?
(i) What is a minimum data size of an Ethernet frame ?
25. Explain distance vector routing . What are its limitations and how are they overcome?
26.Explain pure-ALOHA and slotted- ALOHA systems.Give the expression for
throughout for each,clearly explaining the various terms.
27. Explain 1-persistent, p-persistent and 0-persistent CSMA giving strong and weak
points of each.
28. Explain network equipment used in wired-LANS and explain the function of Hub,
Switch, and bridge.
29. Write short note on any four of the following:
(a) Token ring
(b) Various fields in Ethernet frame format
(c) Difference between congestion control and QoS(or Quality of service)
(d) FDDI
(e) Traffic shaping using token bucket algorithm
(f) CSMA/CD
30. If the transmitted code word is 10011000 and the received code word is 11001001.
What is the error word ? Write transmitted code word , received code word and error
word as polynomials.
31.Why transport layer protocols like TCP and UDP are called end-to- end protocols.
What is the difference between them?

32. Differentiate between:
(i) Baseband co-axial cable and broad band coaxial cable
(ii) Optical fibre and twisted pair
(iii) SMTP and SNMP
33. What are the basic functions of the data link layer? Write down the basic features of
HDLC protocol? Could HDLC be used as a data link protocol for a LAN? Justify your
answer.
34. The physical layer service is a non-confirmed service. Assume that some bits of data
are lost during transmission over physical media,which layer will detect the loss and take
some remedial measures. Explain any one method clearly depicting how this operation is
performed.
35. What are the advantages of cell switching that is used in ATM?
36. Outline and discuss the main fields in Ethernet IEEE 802.3 frame. What are the main
objectives of preamble ?

37. What is the average number of transmission required to send a frame of length 1600
bytes correctly, if the bit error rate is 1 x 10 -6 .
38. Explain what is meant by the term ‘integrated service digital network’. Give three
reasons a company might choose an ISDN link in preference to a leased line.
39. Subnet the class C network address 198.67.25.0 into eight subnets. Why are the ‘all
ones’ and ‘all zeroes’ subnets not used ?
40.What do you understand by the term ‘structured cabling’. State the main rules that
should be used when installing a cable. Show that maximum cabling area for LAN for
horizontal cabling runs is approximately 200m.
41. What are the various classes of IP addressing? Calculate the maximum number of
class A, B and C network Ids.
42. Why is a data link layer switch preferred over a hub ?
43. Which device is needed to connect two LANs with different network Ids ?
44. When is a translating bridge used ?
45. Can a switch be used to connect two LANs with different network IDs ?
46. Write two ways in which computer applications differ from network applications ?
47. What is count to infinity problem ?
48. What was the reason for selecting a speed of 155.52 Mbps in the original ATM
standard ?
49. Contrast link state and distance vector routing protocols, giving an example of each.
50. What is ISO-OSI reference model ? Compare it with TCP/IP reference model. Why
TCP/IP reference model is more popular than OSI model ? Which layer is used for the
following :
(i) to route packets
(ii) to convert packets to frame
(iii) to detect and correct errors
(iv) to run services like FTP, Telnet etc.
51. Discuss Shannon’s capacity. What implications does it have ?
52. Discuss how satellite network differs from traditional networks such as Ethernet,
Tokenbus.
53. What is packet switching ? Explain two different approaches of packet switching. ?
54. Doscuss the different factors affecting congestion control algorithms. ?
55. How does a token ring network work ? In what way is it different from Ethernet ?
56. Describe and distinguish between FDMA, TDMA, and CDMA.
57. Discuss the following terms with respect to ATM: VPI, UNI, asynchronous, AAL,
Cell , PVC.
58. What is sliding window protocol ? Differentiate between stop-and wait ARQ and
Go-back- N protocol.
59. Differentiate between ISO-OSI and TCP/IP reference model.
60. Explain leaky bucket algorithm and compare it with token bucket algorithm.
61. Explain ATM reference model.
62. Explain different kinds of Switching techniques.
63. Differentiate between Link state and Distance Vector Routing algorithm.
64. Explain network layer in ATM,
65. Differentiate between IEEE 802.3, IEEE 802.4 and IEEE 802.5 standards.

66. Explain any three error detection and correction techniques.
67. Explain various cabling techniques used in IEEE 802.3 standard,





(P) UNIT WISE QUESTION BANK

UNIT I

DATA COMMUNICATIONS
PART A ( 2 Marks)


1. Define Data communication
2. List out the characteristics of data communication
3. What are the components of data communication?
4. What are the various forms of data?
5. What are the various types of data flow?
6. Define networks
7. Define Distributed Systems
8. Define Distributed Processing
9. Define Transit time and Response time
10. Define Topology
11. What are the types of topology available and the number of links required to connect n
match
12. Define Protocol.
13. Why are protocols needed?
14. What are the key elements of a protocol?
15. Why are standards needed?

16. Who is the standard committee?
17. Define OSI model
18. What are the seven layers of OSI Model?
19. Define Network architecture
20. Define Protocol stack
21. Define Transmission medium
22. Define Guided Media
23. Define Unguided media
24. Define Line coding
25. What is the relationship between the data element and signal element?
26. Define data rate and signal rate
27. Define Bandwidth
28. What is the line coding scheme available?
29. How does NRZ – L differ from NRZ – I?
30. Define Modem
31. What are the standards available in modem?
32. Discuss the mode for propagating light along optical channels
33. What is the difference between a passive and an active hub?
34. What are the three criteria necessary for effective and efficient networks?

PART B
1. What are the functions of OSI layers? Discuss. (16)
2. a. Explain the types of line coding with neat diagrams. (8)
b. Explain about the RS-232 interface. (8)
3. Explain in detail about the types of topologies. (16)
4. Explain detail about the transmission media for data transmission. (16)
5. a. i. What is a protocol? List the three key elements of a protocol. (4)
ii. With relevant examples differentiate between simplex, half duplex, and full duplex
communication. (4)
b .i. A sine wave completes one cycle in 25 microseconds. What is its frequency?
Express the frequency in kHz. (4)
ii. A digital signal has a bit interval of 40 microseconds. What is the bit rate? Express
the bit rate in Kbps. (4)
6. What is the difference between a protocol and a service interface? Explain in terms of a
ISO seven layer model. (16)
7. a. List the four properties by which transmission media can differ (4)
b. Three packet switching networks each contain n nodes. The networks have a star
topology with a central switch, a ring
respectively and a third is fully interconnected with a wire from every node to every
other node. What are the best, average and
worst case transmission paths in hops? (12)
8. a. Describe the key elements of protocols and the standards. (8)
b. Explain in detail the data transmission in OSI reference model. (8)

UNIT II
DATA LINK LAYER
PART A ( 2 Marks)

1. List out the functions of data link control.

2. Define errors.
3. List out the types of error.
4. Define error detection.
5. Define error correction.
6. List out error correction mechanism.
7. Define Block coding.
8. Draw the process of error detection in block coding?
9. Define hamming distance.
10. Find the Hamming distance
11. Define simple parity check code.
12. Define flow control.
13. Define error control.
14. Define ARQ
15. Define Piggybacking
16. Define sliding window
17. Define HDLC and its transfer mode.
18. List out the frames in HDLC and its purpose.
19. Draw the neat diagrams of a frame format of various frames of HDLC.
20. List out the control field for S frames.
21. Define LAN & List out the technologies.
22. What are the two sublayers of Data Link layer and define its functional
23. Draw the frame format of Ethernet.
24. List out the Ethernet types.
25. Define CSMA /CD
26. Define NAV.
27. Define the frame format of IEEE 802.5
28. Define FDDI.
29. What are the devices used in SONET.
30. What are the four SONET layers?

PART B


1. a. Define CRC. Explain CRC generator & CRC checks in detail with one example(10)
b. Explain in detail about error correction using Hamming code. ( 6 )
2. Explain HDLC and explain it in detail. (16)
3. a. Given a 10 bit sequence 1010011110 and a divisor of 1011 find the CRC.Check the
answer (10)
b. But stuff the following data (6)i. 0001111110111110011110011111001
ii.
0001111111111111111111111111111111111001111100
14. What is IEEE 802.3? What are the types of Ethernet? Discuss. (16)
5. Draw the sender and receiver window for a system using Go Back N ARQ and
selective repeat ARQ, given the following (16)
a. Frame 0 is sent, frame 0 is acknowledged. Frames 1 and 2 are sent, frames 1 and 2 are
acknowledge. Frames 3,4 and 5 are sent;
frame 4 is acknowledged; a timer for frame 5 expires. Frames 5,6 and 7 are sent; frames 4
through 7 are acknowledged
6. Discuss Token Bus & Token Ring networks in detail. (16)
7. Define FDDI & its needs in detail. (16)
8. a. What is SONET? (2)
b. Name some layers of SONET &its functions. (6)
c. Discuss SONET frame in detail with a neat diagram. (8)

9. a. Define bridges? (2)
b. The difference between bridges and repeaters. (4)
c. Explain the loop problems solved by bridges. (10)
UNIT III
NETWORK LAYER
PART A ( 2 Marks)


1. Define internetworking?
2. Distinguish between networking and internetworking.
3. What are the devices used for internetworking?
4. What do you mean by switching and mention its types?
5. What is the difference between packet switching and circuit switching?
6. Mention any two advantages of subnetting.
7. What are the approaches in packet switching?
8. What are the two main elements of distance vector routing?
9. What is the role of packet lifetime?
10. Give the fields available in IP address.
11. What is meant by classful addressing?
12. Define Unicast, multicast, and broadcast.
13. Compare Ethernet address with IP address.
14. What are the functions of IP Protocol?
15. Identify the class and default subnet mask of the IP address 217.65.10.7.
16. Distinguish between bridges and routers.
PART B


1. What is the internet? Imagine an organization where the internet is needed & discuss it in
detail with a neat diagram. (16)
2. Explain in detail about datagram approach and compare with circuit switching.(16)
3. a. Explain Routing Table and Routing Module (8)
b. A company is granted the site address 201.70.64.0. The company needs 6
subnets.Design the subnets. (8)
4. a. How is the looping problem solved by switches and by routers? How
do switches/routers handle link failure? (8)
b. Explain the IP addressing. (8)
5. a. Change the following IP address from dotted decimal notation to binary notation. (2)
i. 114.34.2.8 ii. 129.14.6.8b.
Change the following IP address from binary notation to dotted decimal notation. (2)
i. 01111111 11110000 01100111 01111101
ii. 11110111 11110011 10000111 11011101c.
Find the net and host id of the IP addresses (2)
i. 241.34.2.8
ii. 11101111 11110111 11000111 00011101d.
In a class C subnet, find out the network address (2)i.IP address: 182.44.82.16Mask:
255.255.255.192e.
What is the maximum number of subnets in class A / B using the following masks.(8)i.
255.255.192.0ii.
255.192.0.0iii.255.255.0.0iv. 255.255.224.0

UNIT IV
TRANSPORT LAYER
PART A ( 2 Marks)


1. What are the services provided by the transport layer?
2. Define reliability and its aspects.
3. Define multiplexing.
4. Define RTT.
5. What is the purpose of the Urgent pointer in the TCP header?
6. What is meant by the slow start in TCP?
7. Define socket.
8. Define datagram socket.
9. Draw a neat diagram of a transport layer segment.
10. Differentiate between TCP and UDP.
11. Define QoS.
12. What are the steps in the call set up the process?
13. Define integrated services.
14. Name some tuples which are used to identify a TCP socket.
15. What do you mean by congestion?
16. What are the types of congestion control? Explain.
17. Define flow control?

PART B


1. A client uses UDP to send data to a server. The data are 16 bytes. Calculate the
efficiency of the transmission at the UDP Level (16)
2. Explain the concepts behind in the Silly Window Syndrome. (16)
3. a. Draw and explain in detail about the State Transmission diagram of TCP (8)
b. Explain in detail about congestion avoidance in TCP (8)
4. a. Define UDP. (2)
b. Explain the segment format of UDP (6)
c. Explain in detail about congestion control (8)
5. a. Explain the three phases of TCP (8)
b. Explain the segment format of TCP (8)
6. Explain in detail about various techniques to improve Qos (16)
7. Explain in detail about integrated services (16)
UNIT V
APPLICATION LAYER
PART A ( 2 Marks)

1. Define DNS.
2. Name some generic domain labels
.3. What are the four main properties of HTTP?
4. Describe why HTTP is designed as a stateless protocol.
5. Define virtual terminal.
6. What do you mean by active web pages?
7. What are the transmission modes of FTP?
8. Compare HTTP and FTP.
9. What are the types of source records?
10. What do you mean by FTP?
11. Draw the basic model of FTP.
12. What are the things supported by SMTP?

13. Draw the General format of HTTP request messages.
14. What are the categories of web documents and specify the languages which it issued
for each
15. What are the things define by URL?
16. What are the aspects of information security?
17. Name some security services.
18. What are the types of security attacks?
19. Define AES.
20. Write the steps for an RSA.
21. What is the relationship between CGI & dynamic documents?
22. What is an active document?
23. What is conventional encryption?
24. Define the structure of data in FTP.
25. Define Catching in DNS.


PART B


1. Define DNS and explain the major sections of DNS in detail? (16)
2. With a neat diagram explain the basic model of FTP? (16)
3. What is public key cryptography and explain RSA in detail with one example.(16)
4. Explain various types of substitution techniques. (16)
5. a. SMTP, FTP, and HTTP are protocols to transfer messages from one point to another.
Compare and contrast their use (8)
b. Write short notes on HTTP Request and Response messages (8)
6. Explain in detail about SMTP. (16)
7. a. Use the following encryption algorithm to encrypt the message, a. Replace each
character with it’s ASCII codeb. Add
a 0 bit at the left to make each character 8 bits longc. Swap the first 4 bits with the
last 4 bits.d. Replace every 4 bits
with its hexadecimal equivalentWhat is the key in this method (8)
b. Using the RSA algorithm, encrypt and decrypt the message “BE” with key
pairs(3,15) and (5,15). (8)

PART B

UNIT I
1. Explain in detail the error detection and error corrections.(UQ)
2. Discuss in detail about the layers of OSI model. (UQ)
3. Discuss in detail about HDLC.
4. Discuss in detail about SONET.
5. Explain the different approaches of framing in detail.
6. Write the Sliding Window Algorithm and explain it in detail.
7. Compare Stop and Wait for ARQ scheme with sliding window ARQ scheme.
8. Write in detail about the flow control mechanisms.
UNIT II

1. Name the four basic network topologies and explain them giving all the relevant
features.(UQ)
2. Explain the functioning of wireless LAN in detail.(UQ)
3. Explain Ethernet in detail.
4. Discuss the frame format of a token ring in detail.
5. Differentiate FDDI from token ring
6. Write in detail about Resilient Packet Ring.
7. Write short notes on WI-Fi, Wi- Max.
8. Write short notes on Cellphone technologies.

UNIT III
1. Write notes on the following(UQ)
(i) Internet Protocol.
(ii) Routers.
2. Discuss in detail the various aspects of IPV6. (UQ)
3. What are the different approaches in Packet Switching?Explain them in detail.
4. Write in detail about bridges.
5. Discuss the spanning tree algorithm in detail.
6. What are the limitations of bridges?
7. Explain in detail the ATM cell format.
8. Explain about the different AAL protocols.
9. Discuss DHCP in detail.
10. Explain Distance Vector routing in detail.
11. Explain OSPF in detail.
12. Discuss RIP in detail.
13. Problems in subnetting.
14. Write short notes on the following
i. Broadcasting
ii. Multicasting
iii. ARP
iv. RARP

UNIT IV
1. With neat architecture, explain TCP in detail.

2. Explain adaptive flow control in detail and its uses.
3. With neat architecture, explain UDP in detail.
4. Discuss the different Queuing Discipline in detail.
5. Explain the Congestion Avoidance techniques in detail.
6. Explain TCP Congestion control techniques in detail.
7. Explain how QoS is provided through Integrated Services.
8. Explain how QoS is provided through Differentiated Services.

UNIT V
1. Explain the SMTP and HTTP. Give their uses, state strengths, and weaknesses.
2. Explain the role of a DNS on a computer network.
3. Explain Email protocols in detail.
4. Discuss FTP in detail.
5. Discuss SNMP and Telnet in detail.
6. Write short notes on
i. PGP
ii. SSH

Assignments and Question Bank (SYSTEM ANALYSIS AND DESIGN)


 
IFTM University Moradabad
School of Computer Applications
Assignments
SYSTEM ANALYSIS AND DESIGN
 ASSIGNMENT -1
UNIT-1
1.  What is a system? Explain with example
2.  What are characteristics of a system?
3.  Which are the elements of a computer system? Explain it.
4.  Define the System Concepts.
5.  Explain prototyping method with its steps and uses.
6.  What is system analyst? The role of the System analyst.
7.  Discuss Structured English with types and Example.
8.  Explain feasibility study and cost benefit analysis.
9.  Explain decision table.
10. List and Explain fact finding technique with its merits and demerits of each method.
11. Who is system analyst? Explain the role of system analyst in system development.
12. Which are the different methods for system development? Explain one of them.
13. Explain the type of system in detail.
14. Write a short note on system prototype method.
15. The difference between system analysis and system design.
16. Explain feasibility study and cost-benefit analysis.
17. Explain DFD.
18. Write down short note on SDLC.
ASSIGNMENT -2
UNIT-2
1.  Explain the benefits and weakness of code tools.
2.  Why code is required? Explain four significant codes with suitable example.
3.  Which are the basic principles of output design? When you design output which
      consideration you keep in mind.
4.  Write the principals of code design.
5.  What are the form design considerations?
6.  What is data validation? Explain validation checks with example.
7.  What is CASE? Explain the component of CASE tools.
8.  Explain basic steps for data capture.
9.  Explain CASE component with its advantage and disadvantage.
10. Discuss the type of code in detail.
11. Explain principals of input design.
12. What is code? Write down the type of code in detail.
UNIT-3
1.  List out the method of training in detail.
2.  Explain HIPO chart with an example.
3.  explain type of documentation in detail
4.  Explain all principals of software design.
5.  What is a conversion? Explain conversion method in detail.
6.  What is testing? Explain level of testing.
7.  Explain HIPO diagram.
8.  Explain quality assurance activity.
9.  Write a short note on documentation.
 ASSIGNMENT -3
1.  Draw the symbol of the database for example.
2.  What is data flow?
3.  What is DFD? Explain the rules for drawing the DFD.
4.  Write down the type of information system.
5.  PDFDs are implementing dependent.
6.  Context level DFD and 0 levels DFD both are same.
7.  What is the system to describe any system’s name?
8.  “Arrow” symbol defines what in DFD?
9.  Give the name of two techniques which describe DFD symbol.
10. Discuss and draw the zero level DFD and other different-different level DFDs for any
one system of the following in detail.
a.  Library System.
b.  Financial accounting system
c.  Payroll system.
d.  Inventory/Stock system.
e.  Billing system.
11. Discuss the symbol used in DFD.


UNIT WISE QUESTION BANK OF MCQ QUESTION FOR

QUIZ
Unit-1


Definition

1. System
2. Interface
3. System Analysis
4. Data Dictionary
5. Open System
6. Close System
7. Black box
8. Structure Flow Chart
9. System Design
10. Physical System
11. Abstract System
12. User Manager
13. Interface
14. Feedback
15. behaviors
Long Questions:-


1. Explain SDLC.
2. Explain various activity involved in system design.
3. Explain role of system analysist in system development process.
4. Explain System Prototype method.
5. Explain Types of users.
6. Explain Decision Table with an example.
7. Explain Decision Tree with an example.
8. Explain Structure English.
9. Explain the types of System.
10. Discuss the Fact Finding technique.
11. What is System? Explain its Elements.
12. What is System Analysis? Explain the role of it.
13. Write the characteristics of system
14. Difference Between system analysis and system design.
15. Which are the tools used for documenting procedures and design? Explain any one in detail?
Unit-2

Long Questions:-

1. Explain Case Tools. Explain with its Components.
2. Explain the benefits of Case Tools.
3. Describe Output Media in detail.
4. What is Operational Output?(2 marks)
5. What is Verification? (2 marks)
6. What is Validation? (2 marks)
7. Definition of Non-Significant code. (2 marks)
8. Explain different validation check.
9. Explain the principle of code design.
10. Write the form design consideration.
11. Explain Design Principle of Output.
12. Different between Significant code & Non-Significant code.
Short Questions

1. What is Turn Around Output? (2 marks)
2. What is data capture
3. Explain Check Digit Code.
4. Explain Data Validation of Input design.

Unit-3

Long Questions:-


1. What is In-hose Training?(2 marks)
2. What is Site Preparation? (2 marks)
3. Explain HIPO diagram with an example.
4. Explain the Principle of Software Design.
5. Explain Cohesion and Coupling.
6. what is Code Testing? (2 marks)

7. What is Conversion Plan? (2 marks)
8. Explain Nastier Scheming Man(Structure flow Chart)
9. Describe the need for documents.
10. Write the Advantages of HIOP chart.
11. What is a conversion? Explain its method.
12. Explain the types of Testing.
13. What is Training?
14. Explain Testing Principle.
15. Explain Level of Testing.
16. Explain Warnier/Orr Diagram with an example.
17. The difference between Alpha testing and Beta testing.
18. What is Training? Explain the method of Training.
19. Short Question: Definition of Software Engineering
Definition of Quality Assurance.
Unit-4

Long Questions:-


1. The difference between Logical DFD and Physical DFD.
2. What is DFD? List out the Symbol used in DFD.
3. Draw the Payroll System.
4. Draw the Inventory System.
5. Draw the Library System.
6. Draw the Finance Accounting System.
7 .What is a data dictionary?
8 .Why is a data dictionary necessary?
9. What are the main advantages of creating a data dictionary?
10. What data about a data element is stored





INTERNET JAVA PROGRAMMING LAB (MCA 351)


SCHOOL OF COMPUTER APPLICATIONS
IFTM UNIVERSITY,MORADABAD
JAVA PROGRAMMING LAB
(MCA 351)
LIST OF LAB EXERCISES

Prog.No.
List of Programs
1
WAP to swap two numbers without using third variable.
2
WAP to check whether a number is Armstrong or not.
3
WAP to implement the Concept of Function Overloading.
4
WAP to implement the Concept of Function Overriding.
5
WAP to implement the Exceptional Handling.                    
6
WAP of an applet that receives two numerical values as the input from user and displays the sum of these two numbers.
7
WAP for displaying product list along with their prices and then allow user to buy any1 item from them with required quantity.
8
WAP to implement multithreading (three threads using single run method).
9
WAP to implement the calculator.
10
WAP to implement the URL.
11
WAP to implement the InetAddress.
12
WAP for Sending e-mail in Java.
13
WAP to implement Single Client-Server Communication.
14
WAP to implement the Login_Id Form using JDBC.
15
WAP to implement the SQL commands using JDBC.
16
WAP to implement the List.
17
WAP to implement the JTrees.
18
WAP to implement the JTable.
19
WAP to create the table using JDBC.
20
WAP to implement Remote Method Invocation.
IFTM 

Machine Learning for Agriculture

  Machine learning has the potential to revolutionize agriculture by helping farmers make more informed decisions and optimize their operati...