SOLVED PAPER
PUNJAB NATIONAL BANK SPECIAL OFFICERS EXAM., 2007
(Held on 8-7-2007)
Professional Knowledge (Officer IT)
(Based on Memory)
1. Single parity disk relying on the disk controller for finding out which disk has failed is used by—
(A) RAID level 5(B) RAID level 2
(C) RAID level 4
(D) RAID level 3
(E) RAID level 1
2. Which of these terms refers to the feature of an OS that allows a single computer to process the tasks of several users at different stations, in round-robin fashion ?
(A) Multiprocessing(B) Multiprogramming
(C) Multitasking
(D) Time processing
(E) Time-sharing
3. Which of the following statements is not true about two-tier client-server database architecture?
(A) SQL statements are processed on the server(B) SQL statements may be processed on some of the dients
(C) Business logic is mostly processed on clients
(D) Business logic may be processed on the server
(E) None of these
4. A Relational operator that yields all values from selected attributes is known as a—
(A) difference(B) product
(C) select
(D) project
(E) join
5. Normalisation is—
(A) the process of creating small stable data structures from complex groups of data when designing a relational database(B) a methodology for documenting databases illustrating the relationship between various entities in the database
(C) an approach to data management that stores both data and the procedures acting on the data as objects that can be automatically retrieved and shared
(D) a representation of data as they would appear to an application programmer or user
(E) a representation of data as they actually would be organized on physical storage media
6. The process of building a model that demonstrates the features of a proposed product, service or system is called a—
(A) JAD(B) RAD
(C) templating
(D) prototyping
(E) TAD
7. Which of the following is not a mandatory component of a URL?
(A) Resource Path(B) Protocol
(C) Port Number
(D) Domain Name
(E) None of these
8. DBMS allows you to extrapolate information from your data by using a—
(A) query language(B) table generator
(C) report generator
(D) wizard
(E) None of these
9. A subschema is—
(A) a description of the physical and logical structure of data and the relationships among the data(B) a file that identifies the subset of data that a group of users can access
(C) a detailed description of all data contained in the database
(D) a description of the types of modifications that users can make to a database
(E) Either (C) or (D)
10. Which of the following is not a type of hub ?
(A) Passive hub(B) Inactive hub
(C) Switching hub
(D) Intelligent hub
(E) None of these
11.
The ______lists the location of files on the disk.
(A) FAT
(B) boot sector
(C) root folder
(D) data area
(E) None of these
12. A proxy server is used for which of the following ?
(A) To process client request for Web pages(B) To process client requests for database access
(C) To provide TCP/IP
(D) To provide security against unauthorized users
(E) None of these
13. Where are cookies stored ?
(A) On the server(B) In web.xml.
(C) On the client
(D) In HTML
(E) None of these
14. When the connection does not have the same transmission speed in the download direction as in the upload direction this is known as
(A) asynchronous(B) synchronous
(C) asymmetric
(D) symmetric
(E) None of these
15. A Web _____is software, such as Internet Explorer or Netscape navigator, that lets you navigate the Web.
(A) server (B) browser(C) program (D) connection
(E) None of these
16. Bandwidth refers to—
(A) the cost of the cable required to implement of WAN(B) the cost of the cable required to implement a LAN
(C) the amount of information a peer-to-peer network can store
(D) the amount of information a communication medium can transfer in a given amount of time
(E) None of these
17. A command-line interface tells you it is waiting for the next command by using a—
(A) dialog box(B) menu
(C) system call
(D) prompt
(E) icon
18. The fastest recovery plan involves—
(A) mirrored disks(B) restore/rerun techniques
(C) checkpoints
(D) a database change log
(E) floppies
19. An Application Program Interface (API) is which of the following ?
(A) The same thing as ODBC(B) Middleware that does not provide access to a database
(C) Middleware that provides access to a database
(D) The same thing as JDBC
(E) None of these
20. A table is in the 4NF if—
(A) all attributes must be dependent on the primary key, and must be dependent on each other(B) all attributes are unrelated
(C) no row can contain two or more multivalued facts about an entity
(D) no column contains the same values
(E) None of these
21. A distributed database is which of the following ?
(A) A single logical database that is spread to multiple locations and is interconnected by a network(B) A loose collection of files that is spread to multiple locations and is interconnected by a network
(C) A single logical database that is limited to one location
(D) A loose collection of files that is limited to one location
(E) None of these
22. Which of the following is a proprietary multitasking operating system for multiple users that has built-in networking capability and versions that can run on all kinds of computers ?
(A) Linux(B) Microsoft.NET
(C) Windows NT
(D) Unix
(E) Solaris
23. Which of the following specification has little effect on the speed of a processor ?
(A) Cache(B) System bus speed
(C) Clock speed
(D) Socket type
(E) None of these
24. Inheritance is which of the following ?
(A) When a supertype entity inherits values of the subtype attribute(B) When a subtype entity inherits values of the supertype attribute
(C) When a supertype entity inherits values of another super- type attribute
(D) When a subtype entity inherits values of another subtype attribute
(E) None of these
25. What is used by Oracle to control concurrent access to data ?
(A) Locks(B) Session Manager
(C) Transaction manager
(D) Memory holes
(E) Net 8
26. Which type of database organisation allows a child record to have more than one parent record ?
(A) Network(B) Hierarchical
(C) Object-oriented (0) Relational
(E) None of these
27. In a network, the ends of
the network wires are attached to terminators.
(A) star (B) bus(C) hybrid (D) mesh (E) None of these
28. A condition that occurs when two transactions wait for each other to unlock data is known as a(n)-
(A) shared lock(B) exclusive lock
(C) binary lock
(D) two-phase lock
(E) deadlocks
29. The protects your system
from hackers.
(A) Snort (B) Backup (C) Hard disk (D) Anti-virus(E) Firewall
30. A program currently loaded in the system but not active is said to be running in the
(A) user session(B) background
(C) foreground
(D) kernel
(E) backup
31. XML is which of the following ?
(A) A scripting language that states the rules for tagging elements(B) A programming language that states the rules for tagging elements
(C) A programming language that allows the creation of customized tags
(D) A scripting language that allows the creation of customized tags
(E) None of these
32. Saving a file from the Internet onto your computer is called
(A) downloading(B) uploading
(C) transferring
(D) storing
(E) modifying
33. Two principal architectures for microprocessors are-
(A) AMD /HP(B) CISC / RLSC
(C) DEC/IBM
(D) MMX /CMOS
(E) None of these
34. 802°11 describes networks.
(A) coaxial(B) fibre optic
(C) wireless
(D) copper
(E) None of these
35. Which type of processing speed measurement is used primarily with supercomputers ?
(A) gigahertz(B) fractions of a second
(C) flops
(D) MIPS
(E) None of these
36. Data moves though the network in a structure called
(A) payload(B) paybacks
(C) datagrams
(D) packets
(E) tokens
37. The _______interface transmits one bit at a time.
(A) parallel (B) SCSI(C) serial (D) FireWire (E) None of these
38. Which method of database recovery involves frequent simultaneuous copying of the database to maintain two or more complete copies of the database ?
(A) Mirroring(B) Reprocessing
(C) Roll back
(D) Roll forward
(E) None of these
39. To add an internal card to cornputer, it must have an open
(A) expansion slot(B) bay
(C) bus
(D) USB port
(E) None of these
40. Which of the following is not true of extranets ?
(B) Provides controlled access
(C) Popularly used in transactions such as purchasing
(D) Connects only internal personnel
(E) None of theseAnswers with Explanation
ANSWERS
1. (D) 2. (E) 3. (C) 4. (D) 5. (A) 6. (D) 7. (E) 8. (A) 9. (E) 10. (B) 11. (A) 12. (A) 13. (C) 14. (C) 15. (B) 16. (D) 17. (D) 18. (A) 19. (C) 20. (C) 21. (A) 22. (A) 23. (A) 24. (B) 25. (A) 26. (A) 27. (B) 28. (E) 29. (E) 30. (E) 31. (D) 32. (A) 34. (C) 35. (C) 36. (D) 37. (C) 38. (A) 39. (A) 40. (D)
No comments:
Post a Comment