UCO BANK IT OFFICER DESCRIPTIVE QUESTIONS(EXAM HELD ON 12.07.2009 JMGS - 1)

Q1). (a)
i). What is a Database Trigger?
ii).Explain the concept of Stored Procedure and briefly describe the advantage of using triggers?
(b)
i).What is a view?
ii).How it is related to data independence?
Q 2).
a). (i). What is a distributed system?
(ii). What are the advantages of distributed systems?
b). (i).What is a remote query ?
(ii).How it is processed?
Q 3).
a). Explain the need of concurrency control.
What is its significance in Banking Transaction?
b). (i). Explain what you understand by cookies? How are they useful?
(ii)What are the advantages of using sessions over cookies and URL Rewriting?
Q 4).
(a). (i). What is the difference between an Applet and Servlet?
(ii). What is a life cycle of a Servlet?
(b) .
(i). Why is a XML important for a database application?
Q 5). (a). Discuss in details the use of a Computer Network?
(b). (i). What is ICMP?
(ii). What is difference between ARP and RARP?
Q 6). (a). What security techniques are used to protect computer systems ?
(b). How is data protected during transmission over a network?
Q 7). (a). How has E-Business changed the definition of enterprise systems ?
(b). Distinguish between the various Normal forms in a database ?
Q 8). (a). (i).What are the different types of Back UP possible for the data in a database ?
(ii). Briefly describe them ?
(b). (i). What is a Data Warehouse?
(ii). How it is difference from a database?

Descriptive Question of Canara Bank (IT Officer Scale-2)

Exam held on 15.03.2009

Questions are :

1. How do you manage the users in Unix?

2. What is meant by SCSI? what are the back up methods available ?

3. What are events? what is event driven programming in Dot Net?

4. What is SQL server replication? what are the other replication methods?

5. What are the issues to be considered while implementing E-Commerce?

P.S.: I got this contents from one of readers . I would like to thanks him for his contribution..