IBPS Specialist IT Officer Previous Paper 2013 (Mitraj) Question 1 to 25 Which of the following microprocessors is not 8bit microprocessor? 8085 6502 Z80 68000 None of these Microprocessor 8085 is the enhanced version of which essentially the same construction set 6800 8080 6800A 8000 All of these Which of the following interrupts has the lowest priority? RST 5.5 RST 7.5 TRAP INTR None of these The Data control language (DCL). is used to manage user access to data bases is used to manipulate the contents of a database in some form Both (1) and (2) Used for inserting, deleting and updating data in a database None of these A collection of fields is called a record with respect of DBMS, a record corresponds to Tuple Relation File Attribute None of these. Multiplexer means One into many Many into one Many into many All of these None of these Which gate is known as universal gate ? NOT gate NAND gate AND gate XOR gate None of the above Which of the following is the first integrated logic family? TCL T1L DTL MOS RTL A top to bottom relationship among the items in a database is established by a Hierarchical schema Network Schema Relational Schema Both (1) and (2) Both (2) and (3) In the relational schema, each tuple is divided into fields called. Relations Domains Queries Both (1) and (2) Both (1) and (3) The modify operation is likely to be done after. Delete Insert Look up All of the above None of these The way a particular application views the data from the database that the application uses is a : Module Relational model Schema Subschema None of these Which two files are used during operation of the DMBS? Query language and utilities Data manipulation language and query language: Data dictionary and transaction log Data dictionary and query language None of these Which normal form is considered adequate for relational database design? 2 NF 3 NF 4 NF BCNF None of these An attribute of one matching the primary key another table, is called as Foreign key Secondary key Candidate key Composite key None of these Which of the following SQL commands can be used modify existing data in a database table? MODIFY UPDATE CHANGE NEW None of these Each node in a linked list must contain at least: Three fields Five fields Four fields One fields Two fields The average number of key comparisons done in a successful sequential search in a list of length “n” is Log n (n-1)/2 n/2 (n+1)/2 None of these The order of the binary search algorithm is n n2 nlog(n) log(n) None of these Which of the following is useful in implementing quick sort? Stack Set List Queue None of these OSI model consists of ____ layers Three Five Six Eight Seven Which data communication method is used to transmit the data over a serial communication link. Simplex Full duplex Half duplex Both (1) and (2) Both (2) and (3) Encryption and decryption are functions of the ____ layer. Transport Session Application Physical Presentation Which of the following is not a connecting device? Bridge Trans receiver Router Repeater None of these Repeaters function in the ___ layer Physical Data link Network Both (1) and (2) None of these
Posted on: Fri, 21 Feb 2014 07:13:59 +0000