Computers in Management 2

Assignment – A

Question 1. Explain information system? Discuss various informatio n systems available in any organization.

Question 2. Explain the concept behind Batch Processing and transaction processing system.

Question 3. Show with reference block diagram the various components of a computer system in details

Question 4. What do you understand by classification of computers? Describe with example.

Question 5. Write note on memory of Computer.

Question 6. What do you mean by DBMS along with the facilities available? Also mention the role of database administrator.

Assignment – B

Question 1. What is meant by Network topology along with different network models.

Question 2. What are the different of base of data transmission media. Discuss their merits and Demerits.

Question 3. Explain the term UR L? What are the different components that make URL. Give example.

Question 4. What are the var ious security threats that computer organization are facing today and why providing security is necessary? What is the advantage of using fire wall.

Question 5. What do understand by electronic data interchange along with its advantage and disadvantage? Also discuss the components of EDI systems.

Case Study

Advance Computers India Ltd. is a Civil Consulting Company based in Denver. The company is engaged in provides design consultancy for construction of residential apartments all over U.S.A. and Europe. In order to have higher profit the CEO of the company has set up various offices across various cities of India and has staff strength of around 500 people working these offices. They are working five days a week. The Overseas offices comprise of around 35 people and they coordinate with various clients for getting the jobs, passing the jobs to their Indian counterparts, getting the designs done and passing back the design solution to the clients. The Company has pro gressed well since the last one year and they are getting lot of more jobs, but are finding it difficult to get the jobs done on time due to shortage of manpower. The company is also looking for ways to reduce some of its operating costs. They have hired one consultant for the purpose and he has prepared following list of expenses. He has to suggest means to reduce some of the costs and help in better way of the inter- departmental communications and managing o f database.

Operations Expenses

Telephone Costs $150,000 per year

Employee Policy Manual $5.25 per manual for printing and distribution.

Employee Benefit Counseling $50 per hour meeting

Photocopying $100 per day

Question a) Looking into the type of business the company is into, what will be good solution towards reducing costs?

Question b) What is the best way of sending the data from U.S. and Europe to India and vice versa? Give reason. Also for Inter-data exchange mechanism, which type off internet connection sho uld the company go ?

Question c) What will be the most effective active plan that will help in reducing cost in photocopying? Objective Type Question

Assignment – C

Assignment – C

S. No.	Question uestions	A	B	C	D
1.	Computers are also known by the name	Two state Back device	Two state Front device	Two state forward device	One state front device
2.	Cache Memory is	Small memory between CPU main memory whose access time in close to processing speed of CPU	Programm able Memory	Non-volatile memory	Erasable nonprogrammab le memory
3.	What provides an interface between Hardware and user	Utility Programme	Language Programm e	Operating System	Compiler
4.	RAM is known by	Primary Memory	Main Memory	Random Access Memory	Auxiliary Memory

5.	1 Bytes equals to	1/8 Bits	8 Bits	800 Bits	8000 Bits
6.	Computers carrying operation on data which can vary continuously and are measurable such as time, lengths, weights, etc.	Analog Computers	Digital Computers	Hybrid Computers	Non of the above
7.	A group of conducting wires or lines over which electrical signals corresponding to data and instructions are transmitted is	Bus	Path	System	Stock
8.	Which of the following is not a Programming Language	Fortran	Pascal	Primavera	C++
9.	A database structures that treats files as tables is	Relational Database	Hierarchal Database	Network Database	Data Dictionary
10.	Which of following is a language	Question BE	SQL	Question UEL	C++
11.	A Processing system wherein data is gathered for a time and collected into a group before they are entered into the computer system.	Increase data Redundancy	Integration of Data	Improved in Security	Achieving Data Independenc e
12.	Which of the following is not property of DBMS	Increase data Redundancy	Integration of data	Improved in Security	Achieving Data Independenc e
13.	The facility which defines the conceptual scheme and also gives some details about how to implement this scheme in the physical devise is	DML Pre Compiler	DDL Compiler	Data Manipulatio n Language	Data definition Language

	called
14.	Users who interact with the system by writing database application like computer aided design system are called	Application Programmers	Sophisticat ed Users	Specializaed Users	Naïve Users
15.	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
16.	Which of the following is not a type of computer network	Local Area Network	Metropolit an Area Network	City Area network	Wide Area Network
17.	Which of the following is a DBMS	Excel	Access	dBase	Foxpro
18.	Web Browser is a	Software	Hardware	Operating System	Hyperlink
19.	Which of the following is not a device used in LAN	Mouse	Repeater	Hug	Switch
20.	Which of the following is not a domain name	.sys	.gov	.com	.org
21.	To install multimedia facility into a computer, one does not essentially need	Sound Card	Speakers	Mouse	CD-ROM
22.	Malicious programs that damages your computer is called	Virus	Bacteria	Bugs	Worms
23.	What is the name of the screen symbol that shows the placement of the next character	Mouse	Cursor	Track Ball	Space bar
24.	Which of the following is not an impact device	Joy Stick	Track Ball	Mouse	Printer
25.	Which of the	GIF	JPEG	PNG	MPEG

	following file formats is used for art work
26.	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
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
28.	Data Elements of related type are grouped into	Title	String	Record	Files
29.	A command that lets you change one or more fields in a record is	Modify	Insert	Delete	Cut
30.	Which of the following is not a search engine	Infoseek	AltaVista	Lycos	Gopher
31.	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
32.	Which of the following topology us least affected bt addition or removal of a node	Star	Ring	Mesh.	Bus
33.	A host on the internet finds another host by its	Postal Address	I.P. Address	Electronic Address	E-mail Address
34.	Which of the following browser is not free	Opera	Netscaffe	Internet Explorer	Lynx
35.	Which of the following is not the main component of EDI system	Application Service	Processing Service	Translation Service	Communicat ion Serivce
36.	Which of the following is	A Web Site	A shopping	To have a printer	A method to get the funds

	essentially not a pre-requisite of E-commerce		Cart Programm e to list the products or services and a way to collect purchases informatio n		in bank account
37.	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	Firewall and Proxy Servers	Digital Certificates
38.	What is the full form of HTML	High transfer mark up language	High transmissi on metropolit an language	Hyper test mark up language	Hyper text metropolitan language
39.	URL stands for	Ultimate Resource Locator	Uniform Resource Locator	Uniform Retrieval Language	Ultimate Retrieval Language
40.	Multimedia S/W used for video editing is	Adobe Illustrator	Adobe Photoshop	Adobe Premier	Macromedia Director