Learn and practice the placement papers and interview questions answers of ICICI and find out how much you score before you appear for your next interview and written test.
Which of the following is the product of data processing ?
A. information
B. data
C. software program
D. system
Ans. A
The process of putting data into a storage location is called
A. reading
B. writing
C. controlling
D. hand shaking
Ans. B
The process of copying data from a memory location is called
A. reading
B. writing
C. controlling
D. booting
Ans. A
A list of instructions used by a computer is called
A. program
B. CPU
C. text
D. output
Ans. A
The application layer of the OSI model is the
A. seventh layer
B. sixth layer
C. fifth layer
D. fourth layer
Ans. A
Working of the WAN generally involves
A. Satellite
B. frame delay
C. ATM
D. user agent
Ans. A
Which of the following technique provides dedicated communication channel between two stations.
A. switch network
B. circuit switching
C. packet switching
D. none of these
Ans. B
End-to-end conncectivity is provided from host-to-host in
A. network layer
B. session layer
C. data link layer
D. transport layer
Ans. D
Base band is
A. transmission of signals without modulation
B. a signal all of whose energy is contained within a finite frequency range
C. the simultaneous transmission of data to a number of stations
D. All of the above
Ans. A
The simultaneous transmission of data to a number of stations is known as
A. broad cast
B. bandwidth
C. Aloha
D. analog transmission
Ans. A
The communication mode that supports data in both directions
A. simplex
B. half duplex
C. duplex
D. multiplex
Ans. B
Modulation is the process of
A. sending a file from one computer to another computer
B. converting digital signals to analog signals
C. converting analog signals to digital signals
D. echoing every character that is received
Ans. B
A distributed network configuration in which all data/information pass through a central computer is
A. bus network
B. star network
C. duplex
D. multiplex
Ans. D
To connect a computer with a device in the same room, you might be likely to use
A. a coaxial cable
B. a dedicated time
C. a ground station
D. All of the above
Ans. A
Administrative supervision of database activities is the responsibility of the
A. data base administrator
B. DP Manager
C. DB Manager
D. VP-DP administrator
Ans. A
Which of the following component of a computer system is the most important to a data base management system ?
A. mouse
B. high resolution video display
C. printer
D. high speed, large capacity disk
Ans. D
What is the ser ious pr oblem(s) of file management systems ?
A. data redundancy
B. difficult to update
C. program dependence
D. All of the above
Ans. D
Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time ?
A. master file
B. transaction file
C. report
D. query file
Ans. B
In a database, related fields are grouped to form
A. record
B. file
C. bank
D. field group
Ans. A
A table consists of
A. fields and columns
B. rows and columns
C. rows and cells
D. None of these
Ans. B
The purpose of an index is to provide ……….. to the file it is indexing
A. strorage area
B. access path
C. name
D. number
Ans. B
The database environment has all of the following components execpt
A. users
B. separate files
C. database
D. database adinistrator
Ans. B
When changes occur in a data item, if every file which contains that field should not be updated then, it leads to
A. data redundancy
B. data inconsistancy
C. data security
D. data loss
Ans. B
Which of the following is an advantage of the database approach ?
A. elimination of data redundancy
B. ability to associate related data
C. increased security
D. All of the above
Ans. D
When the same data field is stored more than once in a file, then it leads to
A. data redundancy
B. data inconsistancy
C. data dependancy
D. data independancy
Ans. A
Data security threats include
A. privacy invasion
B. hardware failure
C. fraudulent manipulation of data
D. All of the above
Ans. D
Updating a database means
A. revising a file structure
B. reorganizing the database
C. modifying or adding records
D. all of the above
Ans. D
Firmware means
A. software
B. hardware
C. software available on hardware
D. None of these
Ans. C
For each instructions of program in memory the CPU goes through a
A. decode – fetch – execute sequence
B. execute – store – decode sequence
C. fetch – decode – execute sequence
D. fetch – execute – decode sequence
Ans. C
Which of the following is the ascending order of data hierarchy
A. bit – byte – record – field – data base – file
B. bit – byte – field – record – file – database
C. bit – byte – file – field – record – database
D. bit – record – byte – field – file – database
Ans. B