FREE Bachelor of Science in Computer Science : Database Management Systems Questions and Answers
Among the options listed, which one does NOT fall under the category of advantages associated with a DBMS?
The correct answer is Increase data isolation. Among the provided options—Increased data consistency, Reduced data redundancy, Improved data security, and Increase data isolation—the concept "Increase data isolation" is not typically considered an advantage associated with a Database Management System (DBMS). DBMS aims to provide centralized control over data and ensure its efficient and secure management, while the term "data isolation" does not align with the common benefits offered by a DBMS.
Which option corresponds to the intermediate level of Data Independence?
The correct answer is A. Conceptual Schema. Among the options—Conceptual Schema, Internal Schema, External Schema, and None—the intermediate level of Data Independence is associated with the Conceptual Schema. The Conceptual Schema defines the overall logical structure of the entire database, serving as an abstraction that separates the physical storage details from the logical view presented to users.
What does the DBMS catalog hold information about, which is the description of the database?
The correct answer is B. Metadata. The DBMS catalog is responsible for storing information about the database's structure, organization, and characteristics. This information, collectively referred to as metadata, includes details about the tables, attributes, relationships, constraints, and other components of the database.
Which of the following is an instance of an Entity?
The correct answer is A & B. Among the options—Name and Place, Event, Emp_Id, and A & B—the instances "Name and Place" and "Event" are both examples of entities. An entity represents a real-world object, concept, or item of interest that can be stored and managed within a database.
An _______ within a table signifies a connection or link between a group of values.
The correct answer is Record. A record within a table indeed represents a connection or relationship among a set of values. In a database context, a record is a collection of related data elements that together form a unit of information. It corresponds to a row in a table and contains data attributes or fields that collectively describe a specific entity or item.
Which of the options listed below cannot be chosen as a primary key?
The correct answer is Street. Among the options provided—ID, RegistrationNo, DepartmentID, and Street—the attribute "Street" cannot be chosen as a primary key. A primary key is required to be unique for each record in a database table, and since streets can have multiple occurrences and are not inherently unique identifiers, they are not suitable for serving as primary keys.
What does the term "Attribute" refer to?
The correct answer is B. It is the characteristics of entity. In the context of a database, an attribute refers to the distinct characteristics or properties of an entity. An entity represents a real-world object or concept, and its attributes are the specific pieces of information that describe and define it. Therefore, the correct answer accurately highlights that an attribute is associated with the characteristics of an entity within a database.
The expression _______ is employed to denote a row.
The correct answer is Record. The term "Record" is indeed used to signify a row within a database table. In a database context, a record represents a collection of related data elements that correspond to a particular entity or item. Each record is typically associated with a set of attributes or fields that collectively describe the characteristics of that entity.
Which among the options provided is NOT an instance of data?
The correct answer is The boy received RM10. Among the options presented—RM10, The, The boy received RM10, and Boy—the phrase "The boy received RM10" is not a direct instance of data. While the other options can be seen as individual pieces of information, the given phrase represents a sentence that conveys an action and its context rather than a standalone data point.
What term is used to refer to the individuals who actively utilize and manage the content?
The correct answer is B. Actors on the scene. The term "Actors on the scene" is used to describe the individuals who actively engage with and oversee the content within a system or process. These individuals are directly involved in utilizing, managing, and interacting with the content, making decisions and contributing to the functioning of the system.
The term attribute pertains to a ________ within a table.
The correct answer is Field. The term attribute indeed refers to a field within a table. In the context of a database, an attribute represents a specific data element or characteristic associated with an entity. It corresponds to a column in a table, where each field holds a specific piece of data related to the items or entities described by the records in the table.
Disjoint subtypes are characterized by containing non-overlapping subsets of the entity set of the supertype.
The correct answer is False. Disjoint subtypes are subtypes that do not share any common entities between them within the supertype entity set. In other words, they have distinct and separate subsets of entities.
What is the definition of a database management system (DBMS)?
The correct answer is Software system used to create, maintain, and provide controlled access to a database. A database management system (DBMS) is precisely defined as software designed to facilitate the creation, maintenance, and regulated access to a database. It offers functionalities that enable users to efficiently organize, store, retrieve, and manage data while ensuring data integrity and security.
What components are encompassed within the DBMS subsystem?
The correct answer is All of the above. The DBMS subsystem includes various components such as the Security System, Recovery System, Integrity System, and Concurrency Control System. These components collectively contribute to the efficient and secure management of data within the database management system.
Among the attributes ID, CITY, and NAME, which one can be regarded as a primary key?
The correct answer is ID. Among the attributes provided—ID, CITY, and NAME—the attribute "ID" can be considered a primary key. A primary key is a unique identifier for each record in a database table, and since IDs are typically unique for each entity, they are commonly used as primary keys to uniquely distinguish records within the table.
Which of the following is not a function performed by a DBMS?
The correct answer is Creating and processing forms. Among the listed options, the function of creating and processing forms is not typically a direct role of a Database Management System (DBMS). While DBMS is responsible for tasks like creating and managing databases, processing data, and administering databases, the creation and processing of forms often involve additional software components or application layers.