Nepal Bank Limited, IT Officer 2078/06/12

 

Public Service Commission

Nepal Bank Limited

Information Technology 

2078/06/12

1. Most common types of a computer network is

a. PAN

b. LAN

c. WAN

d. MAN

2. What is the advantages of on-line UPS over offline UPS?

a. It gives stable output frequency

b. Supplies constant power output

c. Free form change over and transition problem

d. Works on single or three-phase supply

3. The convenient place to store contact information for quick retrieval in e-mail is

a. Address box

b. Message box

c. Address book

d. Message box

4. The data link control portion of most LAN protocol is use today is based on

a. ANSI

b. IDDI

c. SDLC

d. HDLC

5. The use of technology to enhance learning process is called___in education.

a. IT

b. ICT

c. Network Technology

d. Communication Technology

6. Which of the following is the first step in the software development life cycle?

a. Coding

b. Preliminary investigation and analysis

c. System testing

d. System design

7. The entity relationship set is represented in ER-diagram as

a. Double diamonds

b. Undivided rectangles

c. Dashed lines

d. Diamond

8. Graphical notation to describes the data flow between various processes of a system is called

a. Entity Relational Diagram

b. Data Analysis Diagram

c. Data Flow Diagram

d. State Diagram

9. A horizontal bar chart that shows project tasks against a calendar is called

a. Goal

b. Miles stone

c. Deliverable

d. Gantt chart

10. Process data is called

a. Field

b. Information

c. Record

d. File

11. Which topology of LAN uses circuit switching?

a. Ring

b. Star

c. Tree

d. Bus

12. Bluetooth is a type of radio wave information transmission system that is good for about

a. 30 feet

b. 30 yard

c. 30 miles

d. 300 miles

13. Each database system supporting ODBC provides a/an

a. Modules

b. Interfaces

c. Library

d. Data dictionary

14. The simplest approach to introducing redundancy to duplicate every disk is called

a. Mirroring

b. Imaging

c. Copying

d. All of the above

15. Which of the following is not a recovery technique?

a. Deferred update

b. Two-phase commit

c. Immediate upgrade

d. Recovery management

16. There are__types of indexed in SQL server.

a. 1

b. 2

c. 3

d. 4

17. Which one of the following cannot be a primary key in RDBMS?

a. Office ID

b. Identification number

c. City name

d. All of the above

18. What do you mean by "ROLL BACK" in a database?

a. DDL

b. DML

c. DCL

d. TCL

19. Forms are based on the concept of function dependency

a. 1 NF

b. 2 NF

c. 3 NF

d. BC NF

20. Who designs and implements database structures?

a. Programmers

b. Project managers

c. Database designers

d. Database administrators