WorksheetsDISA Review Questions - P1
Total questions: 45
Worksheet time: 34mins
The KEY components of IT Infrastructure are ___________________
Users, Applications, DBMS, System Software, Network & Hardware
Computing systems, satellite dishes, ISDN lines, Radio towers
Concrete building, air conditioning, fire extinguishers, sprinklers
Large servers, desktop computers, laptops, tablets
Auditors dealing with organizations deploying IT need to have ______________
Adequate working knowledge of IT hardware & software
Expertise in all areas of IT technology
Thorough knowledge on the financial aspects alone
Expertise both in financial and IT technology aspects
People, the most import element of information systems, comprise _________________
Users of the system in the head office and branches
All users of the system and all information system personnel
All employees except information system personnel
Employees involved with maintenance of the information system
Application software is a collection of programs which ______________
Operates computer hardware & facilitates use of system software
Exclusively use for generating applications to govt. bodies
Addresses a real life problem for its end users
Helps users generate complaints to IT services dept. alone
Hardware refers to___________________
All computer parts except those which are soft, made of glass or plastic
Devices performing Input, output, processing & data storage functions of a computer
All connecting tubes, hoses, joints, cables and pipelines carrying IT cables
All parts of the computer which are complex and hard to understand
The basic sequential steps of the machine cycle performed by the CPU are _____________
Fetch, Decode, Execute and Store
Decode, Execute, Store and Fetch
Store, Fetch, Decode and Execute
Execute, Fetch, Decode and Store
Cache memory ________________
Is a large, slow memory which is no longer used in computers
Helps bridge speed difference between Registers and Primary Memory
Is a virtual memory which is an image of another memory
Is a memory where only valuable, secret information is stored
Secondary Memory _______________
Is volatile memory with large storage capacities
Is non-volatile memory which is fast & responsive
Is non-volatile memory with large storage capacities
Involves higher cost per unit of information than RAM
One Megabyte is equal to ___________________
1024 x 1024 Bytes
1000 Kilobytes
1000 Bytes
1,000,000 Bytes
Unicode _____________
Uses 16 Bytes for character coding & has replaced other major coding systems
Uses 7 bits for character coding
Uses 16 bits for character coding & has replaced other major coding systems
Uses 8 bits for character coding
Implementing Hardware Monitoring Procedures ______________
Is expensive and not cost effective
Reduces Total Cost of Ownership & improves Return on Investment
Is cumbersome & time consuming
Leads to increased server downtime
Some factors that affect the requirement & capacity of various hardware are ____________
Number of employees in the organization
Variety of markets in which operations happen
Nature of the products dealt with in the organization
Transaction volume, Computation complexity
A KEY issue in retirement of hardware is security & disposal of data. Robust policies need to be in place for hardware retirement cycles, archiving of data, closure of licensing and/or contracts.
FALSE
TRUE
Software _________________
Software consists of clearly-defined instruction sets that upon execution, tell a computer what to do
Refers to all the soft parts of any computer system
Is not as important as hardware; a system can operate even without it
Are only those programs which convert machine language to English
System Software _______________
Is specific to each application software and cannot be interchanged
Co-ordinates instructions between application software and hardware
Cannot be used for application development
Is not involved in I/O devices connectivity
Application Software __________________
Microsoft Office is not an example of application software
Cannot be directly interacted with by end users
Is a set of software that performs a function directly for the end user
Can be directly used on a computer even without system software
An Operating System is ______________
An intermediary agent that manages computer resources among various processes
An application software which is in operation in a computer network
A new type of software which has been introduced in the latest computers only
A computer system which has been switched on and is in proper operation
State True or False : Operating Systems can be single user / multi user, multi processing or real time.
FALSE
TRUE
Processor Management refers to _______________
Management of the various processors by the Systems Executive
Training of the end-user for optimal user of computer systems
Optimisation of use of application software on a personal computer
Process or task scheduling carried out by the Operating System
Which of the following is performed by the Operating System ________________
Supports virtual memory by carving out an area of hard disk
Supports virtual memory on external storage device
Supports secondary memory by allocating an area of hard disk
Supports end user in carrying out specific functions
Which of the following is a role of the Operating System ______________
Helps manage Data bases of various types
Facilitates use of spread sheets by end users
Manages device communication with respective drivers
Helps programmers to create computer programs
Fifth Generation programming language _________________
It comprises machine language & code
Is mainly used in Artificial intelligence
Cannot solve a problem without a programmer
It uses long instructions & is machine dependent
What is the function of a Compiler ?
It translates Assembly language into Machine language
It translates statements of a program into machine code, line by line
A compiler translates a high level language program into a machine language program
It allows a user to create and edit files
Which software controls, among other things, ownership assignment of all data for accountability ?
Access Control Software
Data Communications Software
Utility programs
Defragmenters
Access control lists in the OS manage OS Controls. The lowest level of control that can be exercised is, generally, up to :
The level of an individual directory
The level of a particular page in a file
The level of individual words in a file
The level of individual files
State Yes or No In a newly formed organization, the System Administrator is faced with requests for access to particular files from multiple users. On closer scrutiny, he finds that though the users are different, he is able to detect a pattern whereby individuals handling particular functions all seek access to the same files. The System Administrator is aware that, while the individuals handling these functions may change, the actual functions, by and large, are permanent. He feels that it would be simpler to provide access control for files to particular functions and would like to know the feasibility of doing so in the Operating system. What is your view ? Is it possible to provide access to ‘Roles’ which could comprise multiple users, instead of creating individual access controls for each of the users ?
Yes, it would be possible
No, it would not be possible
What is the first step in Software acquisition ?
Establish criteria for selecting and rejecting alternatives
Carry out Cost/Benefit analysis, including make or buy decision
Establish scope, objectives background & proj
Software acquisition ?
Establish criteria for selecting and rejecting alternatives
Carry out Cost/Benefit analysis, including make or buy decision
Establish scope, objectives background & project charter
Determine supplier’s technical capabilities & support services
What is an Endpoint device ?
A device used as a pointer during Power point presentations
The key-board or a mouse on a computer
A device which identifies the end of each software program
An internet-capable computer hardware device on a TCP/IP network
What is Digital Rights Management ?
Management of binary digit codes in the system software
Technology used for preventing users from using the content in any manner other than that permitted by the content provider
Conversion of analog records to digital mode
Optimization of binary digit codes in application software
Does the Operating system need auditing ?
Yes; there is risk of the OS being compromised
No; the application software prevents direct access to the OS
No; the OS is a robust system which cannot be tampered with
No, it is adequate if the application software are audited
Which of the following is the correct sequence of data hierarchy?
File, Database, Record, Field, Characters
Database, Record, File, Field, Characters
Database, File, Record, Field, Characters
Database, File, Field, Character, Records
What are Characters ?
Characters are a group of bytes
Characters are a collection of bits
Characters are a group of 8 records
Characters are a group of 16 records
What are some of the major outcomes of the non-existence of an efficient database ?
High redundancy and low data integrity
Improved data sharing
Reduced dependence between data and application software
Better linkages between data originating from different sources
What is a Database Management System?
A set of pre-loaded data relating to specific industries
Customer profile data used for managing an organization
Software for creation, control & manipulation of a database
Hardware specifically designed to handle databases
What are the major risks of having a Database management system ?
Reduced speed of access to records
High redundancy & duplication
Reduced data integrity
Cost and data security threats
Which of the following is the logic typical of a Relational Database Management System ?
Records have a one to many relationship in parent/child format
Collection of one or more relations in two dimensional table form
Records have many-to-many relationship in network form
Data is organized in a tree structure, in hierarchical format
Use of integrity constraints and normalisation is strongly typical of which type of software?
Relational Database Management System
Network Database Management System
Hierarchical Database Management System
Foxpro, Excel systems of spreadsheet
Which of the following defines the logical structure of the database, its relations & constraints ?
Internal Schema
External Schema
Conceptual Schema
Logic unit in CPU
Which of the following is a database language used to define & describe data & relationships ?
Data Manipulation Language or DML
Data Control Language or DCL
Data Definition Language or DDL
Excel and Lotus 123
Which of the following are typical features of Data Definition Language?
Not used by Database administrators or designers
SQL commands dealing with data
Generally used by a common user
Used to define both conceptual & internal schemas
Which of the following are typical of Data Manipulation Language ?
Cannot be used for querying the database
Used to retrieve, insert, delete or modify data
SQL commands which do not allow changing of data
Application software will not be able to access it
What is a Data Dictionary ?
It provides a definition of terms and data elements
A dictionary which facilitates conversion of bytes into numbers
A software which helps convert machine language to English
A software which helps convert assembly language to English
What are Meta Data ?
Metadata refers to data of large sizes, millions, billions, etc.
Metadata is data about one or more aspects of data
Metadata is data relating to meteorological parameters
Metadata is data that is universal to different types of software
Centralised Deployment Strategy involves _______________
Centralized database & de-centralized decision making
De-centralized database and centralized decision making
Centralized database & centralized decision making
Multiple server usage
