Tuesday, June 21, 2011

Solved Paper DENA BANK SPECIAL OFFICERS (IT) EXAM., 2007 (Held on 26-8-2007) Information Technology/Systems


1. The___________states that a foreign key
must either match a primary key value in another relation or it must be null.
(A) entity integrity rule
(B) referential integrity constraint
(C) action assertion
(D) composite attribute
(E) None of these


2. An applet________

(A) is an interpreted program that runs on the client
(B) tracks the number of visitors to a Website
(C) is a compiled program that usually runs on the client
(D) collects data from visitors to a Website
(E) None of these


3. A___________, sometimes called a boot

sector virus, executes when a computer boots up because it resides in the boot sector of a floppy disk or the master boot record of a hard disk.
(A) system virus
(B) Trojan horse virus
(C) file virus
(D) macro virus
(E) None of these


4. Which error detection method uses one's complement arithmetic?

(A) Simple parity check
(B) Checksum
(C) Two-dimensional parity check
(D) CRC
(E) None of these


5. A result of a computer virus cannot lead to

(A) Disk Crash
(B) Mother Board Crash 
(C) Corruption of program
(D) Deletion of files
(E) None of these


6. The network interface card of LAN is related to following layer of OSI Model—

(A) Transport (B) Network
(C) Data Link (D) Physical (E) All of these


7. Which of the following does not describe a data warehouse ?

(A) Subject-oriented
(B) Integrated
(C) Time-variant
(D) Updateable
(E) None of these