Saturday, 19 December 2015

Free computer Quiz for Ibps IT Officer Exam 98

Free computer Quiz for Ibps IT Officer Exam

Expected Computer Awareness questions answers (mcq) for techincal aptitude for IBPS PO IT Officer Exam , MT Exam, Bank PO, Clerk, SBI, RBI, CLAT, CTET and other competitive exams.



Q.1. A report generator is used to
A. update files
B. print files on paper
C. data entry
D. All of the above
E. None of the above

Q.2. Which of the following is not a logical data-base structure?
A. tree
B. relational
C. network
D. chain
E. All of the above

Q.3. Which of the following is a database administrator's function?
A. database design
B. backing up the database
C. performance monitoring
D. user coordination
E. All of the above

Q.4. Primitive operations common to all record management systems include
A. Print
B. Sort
C. Look-up
D. All of the above
E. None of the above

Q.5. Each of data files has a _____ that describe the way the data is stored in the file.
A. File structure
B. Records
C. Fields
D. Database
E. None of the above

Q.6. After you _____ a record, many data management the environments require you to issue a command to save the changes you made.
A. Delete
B. Update
C. Sort key
D. Index
E. None of the above

Q.7. What is the language used by most of the DBMSs for helping their users to access data?
A. High level language
B. Query language
C. SQL
D. 4GL
E. None of the above

Q.8. Data item characteristics that are important in data management include
A. punctuation
B. language
C. spelling
D. width
E. None of the above

Q.9. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
A. ZIP
B. PACK
C. COMMIT
D. SAVE
E. None of the above

Q.10. Periodically adding, changing and deleting file records is called file
A. Updating
B. upgrading
C. restructuring
D. renewing
E. None of the above

Q.11. Sort/report generators
A. are faster than index/report generators
B. require more disk space than index/report generators
C. do not need to sort before generating a report
D. both (a) and (b)
E. None of the above

Q.12. The data dictionary tells the DBMS
A. what files are in the database
B. what attribute are possessed by the data
C. what these files contain
D. All of the above
E. None of the above

Q.13. In SQL, which command(s) is(are) used to enable/disable a database trigger?
A. MODIFY USER
B. CHANGE USER
C. ALTER TRIGGER
D. All of the above
E. None of the above

Q.14. If the record management system allows you to edit values before they are recorded on disk, you can
A. correct spelling changes before they are recorded
B. change the name of a field
C. change the width of a field
D. All of the above
E. None of the above

Q.15. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
A. record
B. field
C. file
D. data base
E. data item

Q.16. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
A. Bits
B. Characters
C. Data field
D. Schema
E. None of the above

Q.17. Which command is used to remove an index from the database in SQL?
A. DELETE INDEX
B. DROP INDEX
C. REMOVE INDEX
D. ROLL BACK INDEX
E. None of the above

Q.18. An-owner-member set in the CODASYL specifications may have
A. only one owner but many owner occurrences
B. only one member but many member occurrence
C. more than one member but only one occurrence per member
D. All of the above
E. None of the above

Q.19. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
A. Full media
B. Graphics media
C. Multimedia
D. Hypertext
E. None of the above

Q.20. A top-to-bottom relationship among the items in a database is established by a
A. Hierarchical schema
B. Network schema
C. Relational schema
D. All of the above
E. None of the above

No comments:

Post a Comment

Advertisement