Computer in Management 1A

Assignment – A

Q1: What do you understand by generations of computers? To which generation the personal computers fall? Describe the characteristics and capability of personal computers.
Q2: Explain the concept behind Batch processing and transaction processing system.
Q3: What do you understand by interactive input devices? Discuss a situation where they are used appropriately.
Q4: What are the major categories of application software? Discuss each category in details.
Q5: Write short notes on any three of the following.
a. DBMS
b. Transaction Processing systems & Management Processing Systems
c. DNS
d. Operating System
e. Ethernet
Q6: What is computer network? What do you understand by network topology? Describe three network topologies with appropriate examples.
Q7: What are the various security threats that computer organizations are facing today and why providing security is necessary? What is the advantage of using fire wall?
Q8: What do understand by electronic data interchange along with its advantage and disadvantage? Also discuss the components of EDI system.

Case study:
Please read the case study given below and answer questions given at the end.

Banking industry now a day’s depends heavily on automation of its operations that not only automates its functioning but at the same time provides enough intelligent information for quick and effective decision making. The total branch automation system covers all retail banking functions performed in a branch both in front office and also in back office. Its powerful management information system enables senior management to take timely strategic decisions in most dynamic market environment.

XYZ is a nationalized bank with more than 1000 branches with focus on information technology Tyra Information System has obtained the Total Branch Automation tender competing with number of companies at the RFI stage and also against established players at RFP stage. The system has been implemented at 300 branches. It runs on UNIX WARE business edition operating system and standard Oracle RDBMS It supports following modules and functions.

Modules.
. Demand Liabilities (Savings, Current, Flexi Deposits)
. Time Liabilities (Term Deposit, Daily Deposits)
. Fund based advances (Cash Credits, Overdrafts, Loans, Bill Discounting)
. Non Fund Based Advances (Bank Guarantee, Letter of Credit)
. Customer Services (Issue of Cheque Books, Cheque stock maintenance, Stop Payments, Standing Instructions, Lockers, Tax Collection, Pension)
. Remittances (Demand Drafts, Pay Orders, Mail Transfers, Telegraphic Transfers)
. Online Transactions Processing (Cash ,Transfer, Clearing)
. Signature & Photograph maintenance & retrieval
. Nonperforming Assets
. Share Accounting
. Branch General Ledger Accounting

Interfaces
. ATM interface
. Tele banking/IVRS Interface
. Mobile Banking Interface
. Remote Banking/Information Kiosk Interface
. Any Branch Banking
Questions: Highlight the advantages and limitations of computer applications in Indian Banking Industry

Assignment – C

Q1: Computers are also known by the name–
a) Two state Back device
b) Two state Front device
c) Two state forward device
d) One state front device

Q2: Cache Memory is–
Small memory between CPU main memory whose access time in close to processing speed of CPU
Programmable Memory
Non-volatile memory
Erasable non-programmable memory
Q3: What provides an interface between Hardware and user?
Utility Programme
Language Programme
Operating System
Compiler

Q4: RAM is known by–
Primary Memory
Main Memory
Random Access Memory
Auxiliary Memory

Q5: 1 B1Byte is equals to
a) 1/8 Bits
b) 8 Bits
c) 800 Bits
d) 8000 Bits

Q6: Computers carrying operation on data which can vary continuously and are measurable such as time, lengths, weights etc–
Analog Computers
Digital Computers
Hybrid Computers
None of the above
Q7: A group of conducting wires or lines over which electrical signals corresponding to data and instructions are transmitted is–
Bus
Path
System
Stock
Q8: Which of the following is not a Programming Language?
Fortran
Pascal
Primavera
C++
Q9: A database structures that treats files as tables is–
Relational Database

Hierarchal Database
Network Database
Data Dictionary
Q10: Which of the following is a language?
QBE
SQL
QUEL
C++
Q11: A processing system wherein data is gathered for a time and collected into a group before they are entered into the computer system–
Transaction Processing
On-line Processing
Real time Processing
Batch Processing
Q12: Which of the following is not property of DBMS?

Increase date Redundancy
Integration of data
Improved in Security
Achieving Data Independence
Q13: The facility which defines the conceptual scheme and also gives some details about how to implement this scheme in the physical devices is called–
DML Pre Compiler
DDL Compiler
Data Manipulation Language
Data definition Language
Q14: Users who interact with the system by writing database application like computer aided design system are called–
Application Programmers
Sophisticated Users
Specialized Users
Naïve Users

Q15: Groups of specially wrapped and insulated wire lines that are able to transmit data at high rates–
Wire Pairs
Coaxial Cable
Optical Fibers
Microwave System
Q16: Which of the following is not a type of computer network?
Local Area Network
Metropolitan Area Network
City Area network
Wide Area Network
Q17: Which of the following is a DBMS?
Excel
Access
dBase
Foxpro

Q18: Web Browser is a–
Software
Hardware
Operating System
Hyperlink

Q19: Which of the following is not a device used in LAN?
Mouse
Repeater
Hub
Switch

Q20: Which of the following is not a domain name?
.sys
.gov
.com
.org

Q21: To install multimedia facility into a computer, one does not essentially need–
Sound Card
Speakers
Mouse
CD-ROM

Q22: Malicious programs that damages your computer is called–
Virus
Bacteria
Bugs
Worms
Q23: What is the name of the screen symbol that shows the placement of the next character?

Mouse
Cursor
Track Ball
Space bar
Q24: Which of the following is not an impact device?
Joy Stick
Track Ball
Mouse
Printer
Q25: Which of the following file formats is used for art work?
GIF
GIF
PNG
MPEG
Q26: A system which involves the digitization of telephone network so that voice, data, text, music etc. can be provided to end users from single end-
user terminals–

Dial-up Connection
ISDN
VSAT
Cable Modem
uestion No. 27

—
The two kinds of main memory are–
Floppy drive and CD Drive memory
Primary and Secondary Memory
Random and Sequential Memory
RAM and ROM
Q28: Data Elements of related type are grouped into–
Title
String
Record
File
Q29: A command that lets you change one or more fields in a record is–

Modify
Inset
Delete
Cut
Q30: Which of the following is not a search engine?
Infoseek
AltaVista
Lycos
Gopher
Q31: The floppy discs comes in two sizes they are–
3.5 inch & 5.25 inch
2 inch and 3.5 inch
2 inch and 4.25 inch
2.5 inch and 5.5 inch
Q32: Which of the following topology is least affected by addition or removal of a node?

Star
Ring
Mesh
Bus
Q33: A host on the internet finds another host by its–
Postal Address
I.P. Address
Electronic Address
E-mail Address
Q34: Which of the following browser is not free?
Opera
Netscaffe
Internet Explorer
Lynx
Q35: Which of the following is not the main component of EDI SYSTEM?

Application Service
Processing Service
Translation Service
Communication Service36.
Q36: Which of the following is essentially not a pre-requisite of E-commerce?
A Web Site
A shopping Cart Programme to list the products or services and a way to collect purchases information
To have a printer
A method to get the funds in bank account
Q37: What is the method of safeguard used for the safeguarding highly confidential information such as corporate data or credit card information is
being transmitted across the Internet?
Cryptography
Antiviral Package
Firewalls and Proxy Servers
Digital Certificates
Q38: What is the full form of HTML?

High transfer markup language
High transmission metropolitan language
Hyper test markup language
Hyper text metropolitan language
Q39: URL stands for–
Ultimate Resource Locator
Uniform Resource Locator
Uniform Retrieval Language
Ultimate Retrieval Language
Q40: Multimedia S/W used for video editing is–
Adobe Illustrator
Adobe Photoshop
Adobe Premier
Macromedia Director