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)2-( )10 ii) (179.615)10 –( )2
(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 |
No comments:
Post a Comment