Information Technology in Financial Services - Stage-II
ISQ Examination (Summer-2007)


Q.1 Please write the alphabate of selected choice in the answer column: (10)
i

Which of the following is not an input device.

A)       Keyboard             B)        Optical reader                   C)        VR System
D)       Scanner                E)        None of the above

ii

Which of the following is not related to a data storage medium.

A)        RAM                      B)          EPROM                          C)      Magnetic disk
D)       Optical reader          E)          None of the above

iii

Which of the following storage mediums is volatile

A)       Magnetic tape         B)         Optical disk                         C)      Cache memory
D)       Hard Disk              E)          None of the above

iv

Which of the following is not a type of printer

A)      Dot Matrix              B)            Line                                C)             CRT
D)      Bubble jet                E)           None of the above

v

Which of the following does not relate to Operating Systems

A)      Multi-tasking           B)          B. Kernel                         C)               System Overhead
D)      User Interface         E)           None of the above

vi

Which of the of the following is a Local Area Network Topology

A)      TCP/IP          B)       Co-Axial       C)        HUB          D)      STAR        E)     None of the above

vii

Which of the following is not a Database Model

A)      Relational       B)         Hierarchical                                 C)             Network
D)      Object Relational        E)          None of the above

viii

Which of the following is not an Information System for organizations

A)          Transactional Processing System              B)         Knowledge Work System
C)          Database Management System                D)         Office Automation System
E)          None of the above

ix

Which of the following is not an element of Systems Analysis

A)       Feasibility        B)       ERP        C)      Analysis        D)        Design      E)      None of the above

x

EDI is

A)      Personal Computer Banking              B)                Meta Search Engine
C)      Exchange of structured information between computers
D)      Digital Certificate                              E)                 None of the above


Q.2 The following terms fit into the blanks in the following sentences. Place the letter of the correct term in the blank/blanks of the sentence to which it belongs. (10)
 
potential loss
algorithm
security policy
online
bus
passwords
routers
Repeaters
macros
object-oriented
encryption
i
Data security controls should consist of _________________ that allow only certain people to access to the system or to certain areas of the system. While you may want to grant employees access to their payroll data You must make sure they cannot access data of other employees.
ii
With _____________________ processing., there is the risk that two people will try to update the same record at the same time. To avoid this, we can lock the record. This prevents anyone else from trying to update the record.
iii
____________________ are like a computer program which instructs the spreadsheet to carry out a series of steps. The ability to write these allows spreadsheets to be used for many tasks which would otherwise need a specially written computer program.
iv
We need to draw a distinction between risks and threats. A threat is anything which could compromise the confidentiality availability or integrity of data. The risk associated with that threat is a measure of the ______________ to the organization which could arise from that threat.
v
___________ is the process of obscuring information to make unreadable without special knowledge.
vi
A cipher is an ________________ for performing encryption or decryption. It is a series of well defined steps that can be followed as a procedure.
vii
A firewall is a piece of hardware and / or software which functions in a networked to prevent some communication forbidden by the____________.
viii
Other methods keep data and processes separate. ______________________ software development combines the two and treats them as one object.
ix
A _______________________ LAN uses a continuous communication cable to which the servers and workstations are attached. This type of LAN is sometimes called an Ethernet LAN, or a Carrier Sense Multiple Access with Collision Detect. (CSMA/CD) LAN.
x
_______ extend network segments. They amplify the incoming signal received from one segment and send it on to all other attached segments. This allows the distance limitations of network cabling to be extended.

Q.3 What does each of the following acronyms stand for? (05)
i
OCR  
ii
EPROM  
iii
SCSI  
iv
WORM  
v
TCP/IP  
vi
EFTPOS  
vii
PCMCIA  
viii
HTML  
ix
BCP/DRP  
x
ISDN  

Q.4
State and explain a LAN, its main components and at least two network topologies with their relative benefits and drawbacks. (10)

Q.5
Explain the Basic concepts of Databases, elucidating the different components and aspects that comprise a database including database management, schemas and datamodels, access methods and data dictionary. (10)

Q.6
What is BCP. How does an organization develop and maintain a BCP. (10)

Q.7
Write a brief note on Electronic Banking, including EFT and E-commerce. (10)

Q.8
What do you understand by the term ‘DELIVERY CHANNEL’? Name any 4-delivery channels that are used in banking sector? Describe the salient features of them. (10)

Q.9
Write a note on Mobile Banking with reference to the services offered and security factors involved. (05)

Q.10
Write short note on any two of the following: (10)
A)     4th Generation Language        B)        Video Conferencing
C)     Referential Integrity                D)        Synchronous and Asynchronous data transmission

Q.11 Define the following: (10)
  A)         Relational database             B)       Multi-Processing
C)         Expert System                      D)       Computer-Aided Design             E)       Byte