IBPS SO IT Officer Practice Questions – Set 2 (DBMS)
1. Which of
the following is not a logical data-base structure?
A) tree
B) relational
C) network
D) chain
2. 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
3. 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
4. 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
5. Which of
the following hardware components is the most important to the operation of a
database management system?
A) high-resolution
video display
B) printer
C) high
speed, large-capacity disk
D) plotter
E) mouse
6. Which
two files are used during operation of the DBMS?
A) query
language and utilities
B) data
manipulation language and query language
C) data
dictionary and transaction log
D) data
dictionary and query language
E) None of
the above
7. A large
computer information system maintains many different computer files. Which
amongst them is called a perpetual file?
A) Specialized
file
B) Log file
C) Master
file
D) Update
file
E) None of
the above
8. The
highest level in the hierarchy of data organization is called
A) data
bank
B) database
C) data
file
D) data
record
E) None of
the above
9. The main
idea behind computer files is that it is convenient to
A) arrange
them
B) store
information together
C) create
them
D) access
them
E) None of
the above
10. The
Management Information system (MIS) structure with one main computer system is
called a
A) hierarchical
MIS structure
B) distributed
MIS structure
C) centralized
MIS structure
D) decentralized
MIS structure
E) None of
the above
11. If a
calculation is embedded in a form
A) the
result of the calculations are stored with the form
B) the
calculations are stored with the form
C) the
result of the calculations are printed in report
D) All of
the above
E) None of
the above
12. In SQL,
which command is used to add new rows to a table?
A) ALTER
TABLE
B) ADD ROW
C) INSERT
D) APPEND
E) None of
the above
13. Updating
a database means
A) revising
the file structure
B) reorganizing
the database
C) modifying
or adding record occurrences
D) All of
the above
E) None of
the above
14. A form
defines
A) where
data is placed on the screen
B) the
width of each field
C) both (a)
and (b)
D) All of
the above
E) None of
the above
15. A
network schema
A) restricts
the structure to a one-to-many relationship
B) permits
many-to-many relation¬ships
C) stores
data in tables
D) All of
the above
E) None of
the above
Answers:
1. D) 2. B)
3. D) 4. B) 5. C)
6. C) 7. C) 8. B)
9. B) 10. C) 11. B)
12. C) 13. C) 14. C)
15. B)
