IBPS IT Officer MCQ – 23 (DBMS)

Previous MCQs on DBMS:
DBMS 1

DBMS 2
DBMS 3
DBMS 4
DBMS 5

DBMS 6
DBMS 7
DBMS 8
DBMS 9
DBMS 10

1. Processed data is called ………………..
A) Raw data
B) Information
C) Useful data
D) Source

2. …………….. is a utility to capture a continuous record of server activity and provide auditing capability.
A) SQL server Profile
B) SQL server service manager
C) SQL server setup
D) SQL server wizard.

3. Data items grouped together for storage purposes are called a
A) record
B) title
C) list
D) string

4. …………. contains data assisting day to day activities of the organization.
A) Control database
B) Operational database
C) Strategic database
D) Sequential database

5. ………………… approach reduces time and effort required for design and lesser risk in database management.
A) Single global database
B) Top-down approach
C) Multiple databases
D) None of the above

6. HSAM stands for ……….
A) Hierarchic Sequential Access Method
B) Hierarchic Standard Access Method
C) Hierarchic Sequential and Method
D) Hierarchic Standard and Method

7. SQL server stores index information in the ………… system table
A) systindexes
B) systemindexes
C) sysind
D) sysindexes

8. The one guideline to be followed while designing the database is
A) A database design may be ambiguous.
B) Unrelated data should be in the same table so that updating the data will be easy.
C) It should avoid/reduce the redundancy.
D) An entity should not have attributes.

9. Which of the following is not a logical database structure?
A) Chain
B) Network
C) Tree
D) Relational

10. ……………. is a preferred method for enforcing data integrity
A) Constraints
B) Stored procedure
C) Triggers
D) Cursors

 

ANSWER

1. B) Information
2. B) SQL server service manager
3. A) record
4. B) Operational database
5. C) Multiple databases
6. A) Hierarchic Seque … Method
7. D) sysindexes
8. C) It should avo … redundancy.
9. A) Chain
10. A) Constraints


Check out our latest videos on youtube