INFOTECH MODEL PAPERS - IPCC

INFOTECH  MODEL 1 for Nov2013

Question NO.1 is compulsory.                                          

Answer any five questions from the rest

1.Answer all following questions in brief:   1 x       10 = 10

a) SQL   b)  Operating systems c) Replicated database

d) Gateway in networks.  e) Volatility in  File concept

f) modularity g) usage of browser

h) Item i) Electronic/ Digital  cash j) Isp

2. (a) What are various transmission techniques (4)

(b) Explain the architecture of Database (4)

3.(a) Discuss the sequential file organization (4)

(b) What are the constituents of data centers ? (4)

4.a)Explain different types of electronic Fund Transfer . (4)

b) Discuss the Bullwhip or Whiplash effect (4)

5) Draw a flow chart for the below problems

i) 3,33,333,3333,………….  Upto 10 terms

ii)  1,1,2,3,5………………  4+4 =8   

6. (a) Explain the characteristics of DSS?  (4)

(b) What is Web casting *** (4)

7.Answer any four questions:  2*4=8

 (a) What are the types of Network architecture ?

 (b) Explain  smart card?.

 (c) What is the job of compiler ? Explain it briefly .

 (d) Write a note on Encryption ?.

 (e) What is a Alternate key ?

INFOTECH  MODEL 2 for MAY2013

Question NO.1 is compulsory.

Answer any five questions from the rest

1.Answer all following questions in brief:   5 x 2 = 10

(a) What is the importance of DATAWARE HOUSE  (2)

(b) TCP / IP (2)

(c) What is guided & unguided media  ? (2)

(d) Define SCM .  (2)

(e) Firewall  (2)

2. (a) Distinguish the various type of network structures (4)

(b) Explain the functions of Operating Systems (4)

3.(a) Explain the characteristics of Client server(4)

(b) What are the types of Disaster recovery Plan for Eliminating down time ? (4)

4.a) What are the stages of Data mining  (4)

b.) Explain the types & methods of Backup ?(4)

5.a) Draw a flowchart which reads the following Customer  name , model number, no.of days hired calculate and print Customer name, model number , Hire charges, Discount amt , nett amt including the deposit of  500 rupees(5)

Model Alto car	Charges/day 800
Indica	900
Innova	1500
Others	2000

The hirer gives the discount as follows

• For more than  5 days 10%
• For more than 10 days 15%
• For more than 20 days 25% is given

b.) What are the types of Decision Tables  (2)

6. (a) Distinguish LAN and WAN (4)

(b) specify the following terms   (1*4=4)

i)Data mart  ii) Mode of transmissions  iii) Network structure

iv) Declarative Data

7.Answer any four questions:  2*4=8

 (a) Encryption

 (b) External databases 

 (c) What is HTTP/ HTML?.

 (d) Write about OOP / L ?.

 (e) What are the industries which are affected by M-commerce

INFOTECH  MODEL 3 for MAY2013

Question NO.1 is compulsory.

Answer any five questions from the rest.

1.Answer all following questions in brief:   5 x 2 = 10

(a) Convert the following for one number system to another (4)

    i)  (10100110.1011)₂-( )₁₀  ii) (179.615)₁₀ –(  )₂

(b) What is Transaction Log  (2)

(c) What is the purpose of Bridge (2)

(d) Data independence. (2)

 2. (a)List out the differences between Multiprocessing and Multiprogramming. (4)

(b) What are the duties of Database administrator (4)

3.a.What are the LAN & WAN  (4)

b. What are various types of  Record Relationship (4)

4.a.What are the various types of TIER’s explain (4)

b. Explain OSI architecture of Protocols (4)

5. Convert the following Decision Table   to Flow chart (8)

	Condtions	R1	R2	R3	R5	R5	R6
C1	PT=”WM”	Y	N	N	N	N	N
C2	PT=”DI”	-	Y	N	N	N	N
C3	CT=”W”	-	-	Y	Y	N	N
C4	OV>=20000	-	-	Y	N	Y	N
	Actions	ACT	ION	ENTR		IES
A1	D=0.20	X	-	-	-	-	-
A2	D=0.18	-	X	-	-	-	-
A3	D=0.15	-	-	X	-	-	-
A4	D=0.10	-	-	-	-	X	-
A5	D=0.05	-	-	-	-	-	X
A6	D=0	-	-	-	X

KEYS

PT=Product Types

WM=Washing Machine , DI=Decorative Item else Others

CT=Customer Type

W=wholesaler else retailer

OV =Order value

D=Discount

6. (a) What is downtime and what are the types of sites.? (4)

    (b)What is the difference between  WWW and Internet (4)

7.Answer any four questions:

 (a) What is a Modularity?        (b) Explain VOIP & CGI?

 (c) What is Multithreading ?     (d) Online intermdeiaries.

 (e) Define SCM ?.

INFOTECH  MODEL 4 for MAY2013

Question NO.1 is compulsory.

Answer any five questions from the rest.

1.Answer all following questions in brief:   5 x 2 = 10

(a) What is UNICODE (2)

(b) Explain CRM (2)

(c) What is Interpreter? (2)

(d) what is Multitasking . (2)

(e) What is a Realtime (OLRT) ? (2)

 2. (a)what  are various types of keys explain with examples. (4)

(b) Distinguish DDL vs DML . (4)

3.(a) What are the responsibilities of librarian for documentation activities? (4)

(b) Explain Extranet and the rules of Extranet to manage Dynamic environment (4)

4.a.Explain the following  terms ?

   i) BCD ii) ASCII iii) DIGIT iv) EBCDIC 1*4=4

b) What are the prerequisites of good CRM (4)

5. A company has two types of customers like Dealer and Agent, the company gives  credit facilities for purchases made .The input consist of

·         Customer type, Order value,Bill date,Payment date

Print Customer type , Order value ,Discount  amount, Surcharge and Nett amt the schedule of calculation as follows

Customer type	No of days	Discount	Surcharge
Dealer	< 15	0.10	=
Dealer	15-30 days	0.05	=
Dealer	31-60 days	=	0.10
Dealer	> 60 day	=	0.15
Agent	< 15	0.20	=
Agent	15-30 days	0.15	=
Agent	31-60 days	=	0.12
Agent	> 60 day	=	0.18

6. (a) What are the applications of Internet ?

    (b) What are the various characteristics of Client server?

7.Answer any four questions:

 (a) Explain the various types of DSL ?

 (b) Write short notes on communication software ?

 (c) What is AI .

 (d) What is VPN ?.

 (e) What is Shareware ?.

Some  more important topics for concentration :

Vdisk	Client server databases	Dependent data mart	Device drivers	Candidate keys
Parity bit	Foreign key	Schema	Data mart	Image database
Meta data	Fault tolerance	Hub	Guided media	Packet switching
NIC	vulnerabilities	Network Intrusion detection	Arpanet	Fat client and Fat server