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?
A) MODIFY
USER
B) CHANGE
USER
C) ALTER
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?
A) ZIP
B) PACK
C) COMMIT
D) SAVE
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
Answers:
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)
Take a look:
IBPS SO IT Officer Practice Questions – Set 2 (DBMS)
Take a look:
IBPS SO IT Officer Practice Questions – Set 1 (DBMS)
