IBPS SO IT Officer Practice Questions – Set 1 (DBMS)
1. A report
generator is used to
A) update
files
B) print
files on paper
C) data
entry
D) All of
the above
2. 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
3. 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
4. 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
5. A
database management system
A) allows
simultaneous access to multiple files
B) can do
more than a record management system
C) is a
collection of programs for managing data in a single file
D) both (a)
and (b)
E) None of
the above
6. In a
_____ a parent record type can be linked to one or more "child"
record types, but a child record type can have only one parent.
A) Network
database
B) Relational
database
C) Distributed
database
D) Hierarchical
database
E) None of
the above
7. Which
command is used to remove a table from the database in SQL?
A) DELETE
TABLE
B) DROP
TABLE
C) ERASE
TABLE
D) UNATTACH
TABLE
E) None of
the above
8. In SQL,
GRANT command is used to
A) allow
user to access databases
B) allow
user to create databases
C) grant
system privileges, roles, and object privileges to uses and roles
D) choose
auditing for specific SQL commands
E) None of
the above
9. When you
have finished entering information into a form
A) the
template is written to the data file
B) the
contents of the form are written to the data file
C) the
contents of the form can be printed
D) All of
the above
E) None of
the above
10. If you
want to group the records in the abc database, you could use the Jobcode as the
_____.
A) Delete
B) Update
C) Sort Key
D) Index
E) None of
the above
11. A
number of related records that are treated as a unit is called
A) file
B) field
C) data
D) batch
E) None of
the above
12. In SQL,
which command(s) is(are) used to enable/disable all triggers on a table?
A) ALTER
TRIGGERS
B) ALTER
TABLE
C) MODIFY
TRIGGERS IN TABLE
D) All of
the above
E) None of
the above
13. Which
of the following is true of a network structure?
A) It is a
physical representation of the data
B) It
allows a many-to-many relationship
C) It is
conceptually simple
D) It will
be the dominant data base of the future
E) None of
the above
14. Which
of the following is not a relational database?
A) dBASE IV
B) 4th
Dimension
C) FoxPro
D) Reflex
E) None of
the above
15. Sophisticated
report generators can
A) print
row-oriented reports
B) perform
arithmetic operations
C) selectively
retrieve and print portions of a list
D) All of
the above
E) None of
the above
Answers:
1. B) 2. B)
3. B) 4. C) 5. D)
6. D) 7. B) 8. C)
9. B) 10. C) 11. A)
12. B) 13. B) 14. D)
15. D)
