What is the primary definition of a Database Management System (DBMS)?
A DBMS is defined as a collection of interrelated data and a collection of programs enabling users to access, update, and manage the database efficiently and securely.
Which of the following is considered a major limitation of traditional file-processing systems compared to a DBMS?
File processing systems suffer from data redundancy, inconsistency, difficulty in accessing data, lack of concurrency control, security enforcement limitations, and failure atomicity problems. Hence, more than one of the above is correct.
The information or data describing the structure, definition, and constraints of data stored in a DBMS is termed as:
Metadata is defined as 'data about data', which includes schemas, constraints, storage descriptions, and mapping rules stored in the system catalog or data dictionary. Therefore, none of the first three statements is correct.
Which of the following is NOT a recognized type of database management system model?
Recognized data models include Relational, Object-Oriented, Hierarchical, and Network models. 'Sequential DBMS' is not a standard category of DBMS.
In the ANSI-SPARC Three-Level Architecture of a DBMS, which level describes how data is physically stored on disk storage?
The internal level (physical schema) describes the physical storage structure, file organizations, access paths, and indexing mechanisms used to persist data on secondary storage.