🧪 Data Base Management System (DBMS) MCQ Quiz Hub

1. ——- responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use and monitoring efficiency of operations.
Storage Manager
File Manager
Transaction Manager
Buffer Manager

2. ——- is a property that describes various characteristics of an entity
ER Diagram
Column
Relationship
Attribute

3. ——– level describes what data is stored in the database and the relationships among the data
Physical Level
Logical Level
Conceptual Level
None of the above

4. ——- denote derived attributes.
Double ellipse
Dashed ellipse
Squared ellipse
Ellipse with attribute name underlined

5. A ——— is an association between entities
Relation
One to One
Generalization
Specialization

6. —- stores metadata about the structure of the database
Physical database
Query Analyzer
Data Dictionary
Data Catalog

7. ——is a collection of operations that perform s single logical function in a database application
Transaction
Concurrent operation
Atomicity
Durability

8. The problem that is compounded when constraints involve several data items from different files are Called ——–
Transaction Control Management Problem
Security Problem
Integrity Problem
Durability Problem

9. Ensuring atomicity is the responsibility of the ————component
File Manager
Buffer Manager
DGA
Transaction Manager

10. —–manages the allocation of the space on the disk storage and the database structure used to represent information stored on disk
Disk Manager
File Manager
Memory Manager
None of the above

11. is the minimal super key .
Primary Key
Candidate Key
Unique Key
Alternate Key

12. -engine executes low-level instructions generated by the DML compiler
DDL Analyzer
Query Interpreter
Database Engine
None of the above

13. ————responsible to define the content, the structure, the constraints, and functions or transactions against the database
Transaction Manager
Query Analyzer
DBA
None of the above

14. In the ER model ————-denote derived attributes
Double ellipse
Diamond
Rectangle
None of the above

15. The ascending order of a data hierarchy is:
bit-byte-record-field-file-database
byte-bit-field-record-file-database
bit-byte-field-record-file-database
bit-byte-file-record-field-database

16. Which of the following is true of a network structure?
it is a physical representation of the data
It allows a many-to-many relationship
It is conceptually simple
It will be the dominant database of the future

17. Which of the following is true of a network structure?
it is a physical representation of the data
It allows a many-to-many relationship
It is conceptually simple
It will be the dominant database of the future

18. Which of the following is a problem of the file management system?
difficult to update
data redundancy
program dependence
All of the above

19. One data dictionary software package is called
DB/DC dictionary
TOTAL
Datapac
Data Manager

20. The function of a database is …
to check all input data
to check all spelling
to collect and organize input data
to output data

21. What is the language used by most of the DBMSs for helping their users to access data?
High-level language
SQL
Query Language
4GL

22. The model for a record management system might be
handwritten list
a Rolodex card file
a business form
All of the above

23. Primitive operations common to all record management system include
print
sort
Look-up
All of the above

24. In a large DBMS
each user can “see” only a small part of the entire database
each user can access every subschema
each subschema contains every field in the logical schema
None of these

25. Information can be transferred between the DBMS and a
spreadsheet program
word processor program
graphics program
All of the above

26. Which of the following fields in a student file can be used as a primary key?
class
Social Security Number
GPA
Major

27. Which of the following is not an advantage of the database approach
Ability of associate deleted data
increased security
program/data independence
all of the above

28. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
report writer
query language
data manipulation language
transaction log

29. In the DBMS approach, application programs perform the
access control
processing functions
all of the above
None of the above

30. et of programs that handle a firm’s database responsibilities is called
database management system (DBMS)
database processing system (DBPS)
data management system (DMS)
All of the above

31. Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
full media
graphics media
multimedia
hypertext

32. A record management system
can handle many files of information at a time
can be used to extract information stored in a computer file
always uses a list as its model
both a and b

33. A transparent DBMS
can not hide sensitive information from users
keeps its logical structure hidden from users
keeps its physical structure hidden from users
both b and c

34. A file produced by a spreadsheet
is generally stored on disk in an ASCII text fromat
can be used as is by the DBMS
both a and b
None of the above

35. An audit trail
is used to make backup copies
is the recorded history of operations performed on a file
can be used to restore lost information
None of the above

36. If a piece of data is stored in two places in the database, then
storage space is wasted
changing the data in one spot will cause data inconsistency
in can be more easily accessed
both and b

37. Sort/Report generators
are faster than index/report generators
require more disk space than indexed/report generators
do not need to sort before generating report
both a and b

38. In order to use a record management system
you need to understand the low level details of how information is stored
you need to understand the model the record management system uses
bother a and b
None of the above

39. Which of the following is not a relational database?
dBase IV
4th Dimension
FoxPro
Reflex

40. Large collection of files are called
fields
records
database
sectors

41. Batch processing is appropriate if
only a small computer system is avilbale
only a few transactions are involved
all of the above
None of the above

42. Which of the following hardware component is the most important to the operation of database management system?
high resolution video display
printer
high speed, large capacity disk
mouse

43. Which of the following is not true of the traditional approach to information processing
it is file oriented
programs are dependent on the file
it is inflexible
all of the above are true

44. The relational database environment has all of the following components except
separate files
database
query languages
database

45. The management information system (MIS) structure with one main computer system is called a
hierarchical MIS structure
distributed MIS structure
centralized MIS structure
decentralized MIS structure

46. A top-to-bottom relationship among the items in a database is established by a
hierarchical schema
network schema
relational schema
All of the above

47. The relational database environment has all of the following components except
users
separate files
database
query languages

48. Database management systems are intended to
establish relationship among records in different files
manage file access
maintain data integrity
All of the above

49. One approach to standardization storing of data?
MIS
structured programming
CODASYL specification
None of the above

50. The language used application programs to request data from the DBMS is referred to as the
DML
DDL
query language
any of the above