IBPS SO IT Officer Practice Questions – Set 3 (DBMS)

Mentor for Bank Exams
IBPS SO IT Officer Practice Questions – Set 3 (DBMS)
Dear Students,
Welcome to Mentor for Bank Exams. IBPS SO (IT- Officer) Exam 2017 is going to be conducted, we hope you all have been preparing well for this exam. To brush up your preparation at this stage, here are some most important questions for IBPS SO (IT) exam. As we Know that the DBMS is an important chapter for IBPS SO (IT), so we have collected most repeatedly asked questions from previous papers. All the best!!!
1. 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
2. Data item characteristics that are important in data management include
A) punctuation
B) language
C) spelling
D) width
E) None of the above
3. In SQL, which command(s) is(are) used to enable/disable a database trigger?
D) All of the above
E) None of the above
4. 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
5. The PROJECT command will create new table that has
A) more fields than the original table
B) more rows than the original table
C) both (a) and (b)
D) all the fields of master table
E) None of the above
6. When using a database management system, the first thing that you must do is to
A) create a database file
B) activate file editor
C) load the software into your micro¬computer
D) keep a floppy disk in readiness
E) None of the above
7. A file produced by a spreadsheet
A) is generally stored on disk in an ASCII text format
B) can be used as it by the DBMS
C) can be used for graphic
D) All of the above
E) None of the above
8. The logical data structure with a one-to-many relationship is a :
A) network
B) tree
C) chain
D) relational
E) None of the above
9. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A) the pin code
B) the last name
C) a compound key consisting of the first name and the last name
D) All of the above
E) None of the above

10. To have a file hold a list, it is necessary to
A) identify the records in the list
B) identify the name, width and type of the fields of each record.
C) decide which fields will be used as sort or index keys
D) All of the above
E) None of the above
11. 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
12. 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
13. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
E) None of the above
14. 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
15. 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
1. E)   2. D)   3. C)   4. A)   5. E)   6. C)   7. A)   8. B)   9. C)    10. D)   11. C)   12. A)   13. C)   14. C)   15. A)