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.
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.
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|
|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|