1.
What is an Attribute?
Correct Answer
B. It is the charecteristics of entity
Explanation
An attribute refers to the characteristics or properties of an entity. In the context of a database, an attribute represents a specific piece of information or data that can be associated with an entity. For example, in a database of students, attributes could include their name, age, and grade. Attributes help to define and describe the entities within a database and provide a way to organize and categorize data.
2.
Which one is the middle level of Data Independence?
Correct Answer
A. Conceptual Schema
Explanation
The middle level of Data Independence is the Conceptual Schema. This level provides an abstract view of the entire database, defining the overall structure and organization of the data. It describes the relationships between different entities and the constraints that apply to the data. The Conceptual Schema is independent of any specific database management system, allowing for changes to be made at the internal or external schema levels without affecting the conceptual schema.
3.
Which one is the function of DBMS?
Correct Answer
C. Both (i) and (ii)
Explanation
The correct answer is Both (i) and (ii). A DBMS (Database Management System) is responsible for data storage, retrieval, and update. It provides a user-accessible catalog that allows users to view and manage the data stored in the database. Therefore, both options (i) and (ii) are functions of a DBMS.
4.
Users who actually use and control the content are
Correct Answer
B. Actors on the scene
Explanation
The correct answer is "Actors on the scene" because actors are the individuals who directly engage with and perform in the content, whether it be in movies, plays, or television shows. They are the ones who bring life to the characters and deliver the content to the audience. While workers behind the scenes and creators also play important roles in the production and development of the content, it is ultimately the actors who have the most direct control and influence over the content when it comes to performance and delivery.
5.
DBMS catalog stores the description of the database called
Correct Answer
B. Metadata
Explanation
The DBMS catalog stores the description of the database, which includes information about the structure, organization, and properties of the data. This information is known as metadata. Metadata provides details about the tables, columns, indexes, constraints, and other objects in the database. It helps in managing and manipulating the data effectively and efficiently. Therefore, the correct answer is metadata.
6.
Which is the example of Entity? (Multiple Answers)
Correct Answer(s)
A. Name
B. Place
C. Event
Explanation
The examples given (Name, Place, Event) are all entities because they represent specific objects or concepts that can be identified and distinguished from others. Each of these examples refers to something that exists in the world and can be considered as a separate entity.
7.
DBMS subsystem includes (Multiple Answers)
Correct Answer(s)
A. Security System and Recovery System
B. Integrity System
C. Concurrency control system
Explanation
The DBMS subsystem includes the security system, recovery system, integrity system, and concurrency control system. The security system ensures that only authorized users can access the database and protects against unauthorized access or data breaches. The recovery system ensures that in the event of a system failure or data loss, the database can be restored to a consistent state. The integrity system maintains the accuracy and consistency of data by enforcing constraints and rules. The concurrency control system manages multiple users accessing the database simultaneously, ensuring that their actions do not interfere with each other and maintaining data consistency. The binding system is not included in the DBMS subsystem.
8.
Which of these are kinds of data independence?
Correct Answer
D. Option (i) and Physical
Explanation
Logical and physical data independence are both types of data independence.
Logical data independence refers to the ability to modify the logical schema or structure of the database without affecting the external schema or the application programs that use the database. This means that changes in the way data is organized or stored internally do not require changes to be made to the application programs.
Physical data independence, on the other hand, refers to the ability to modify the physical schema or storage structure of the database without affecting the logical schema or the application programs. This means that changes in the physical storage or organization of data do not require changes to be made to the way data is accessed or manipulated by the application programs.
9.
DBMS is a software that enables users to: (Multiple Answers)
Correct Answer(s)
A. Control
C. Maintain
Explanation
DBMS (Database Management System) is a software that allows users to control and maintain databases. It provides tools and functionalities to manage and manipulate data, ensuring data integrity and security. With DBMS, users can control access to the database, restrict certain operations or permissions, and maintain the overall structure and organization of the data. It enables users to have centralized control over the database system, ensuring efficient data management and retrieval.
10.
Manipulating the Database means:
Correct Answer
D. All the above
Explanation
Manipulating the database refers to performing various operations on the database, including querying the data to retrieve specific information, generating reports based on the data stored in the database, and making modifications or changes to the content of the database. Therefore, all of the given options - querying, generating reports, and modifications to the content - are correct explanations of what manipulating the database entails.
11.
Database designers need not need to communicate with the end users
Correct Answer
B. False
Explanation
Database designers need to communicate with end users in order to understand their requirements, gather feedback, and ensure that the database design meets their needs. This communication is essential for designing a database that effectively stores and retrieves the required data. Without proper communication, there is a risk of designing a database that does not align with the end users' expectations and requirements. Therefore, the statement "Database designers need not need to communicate with the end users" is false.
12.
DBMS provides interface between :
Correct Answer
C. Applications Programs & data
Explanation
DBMS (Database Management System) acts as an interface between application programs and data. It allows application programs to access and manipulate data stored in a database. The DBMS provides a set of functions and commands that enable applications to perform operations such as inserting, updating, deleting, and retrieving data from the database. It also ensures data integrity, security, and concurrency control. Therefore, the correct answer is "Applications Programs & data".
13.
DBMS does not support Data communication
Correct Answer
B. False
Explanation
DBMS, or Database Management System, actually supports data communication. It allows users to access and manipulate data stored in databases, as well as share and exchange data with other users or systems. DBMS provides various mechanisms for data communication, such as APIs, network protocols, and query languages, enabling users to retrieve, update, and transmit data between different applications or platforms. Therefore, the statement "DBMS does not support Data communication" is false.
14.
__________________ mechanism is used for recovering damaged data
Correct Answer
Recovery Service
Explanation
The given answer, "Recovery Service," suggests that a recovery service mechanism is used for recovering damaged data. This implies that there is a specific service or process in place that helps in recovering data that has been damaged or corrupted. However, without further context or information, it is difficult to provide a more detailed explanation.
15.
Data Dictionary is a part of disk storage and DBMS architecture
Correct Answer
A. True
Explanation
A data dictionary is a centralized repository that stores metadata about the data in a database. It contains information about the structure, organization, and relationships of the data elements. As it is a part of the disk storage and DBMS architecture, it is responsible for managing and providing access to the data dictionary. Therefore, the statement "Data Dictionary is a part of disk storage and DBMS architecture" is true.
16.
The distinguishing parts of the record are called fields
Correct Answer
B. False
Explanation
The distinguishing parts of the record are not called fields. Fields are actually the individual pieces of data within a record that hold specific information. So, the correct answer is False.
17.
Data Abstraction provides:
Correct Answer
A. Conceptual view
Explanation
Data Abstraction provides a conceptual view of data. This means that it allows users to understand and interact with data at a high level, without needing to know the specific details of how the data is stored or implemented. It focuses on the essential aspects of the data and hides the unnecessary details, making it easier for users to work with and analyze the data.
18.
Integrity service is a function of DBMS
Correct Answer
A. True
Explanation
Integrity service is indeed a function of a Database Management System (DBMS). DBMS ensures the integrity of the data stored in the database by enforcing rules and constraints to maintain consistency, accuracy, and reliability. It includes features like data validation, referential integrity, and transaction management to prevent data corruption and maintain data integrity. Therefore, the statement "Integrity service is a function of DBMS" is correct.
19.
Buffer Manager and data manager are a part of storage manager
Correct Answer
B. False
Explanation
The statement is false because the buffer manager and data manager are not a part of the storage manager. The buffer manager is responsible for managing the buffer pool, which is a cache for frequently accessed data, while the data manager is responsible for managing the actual data stored in the database. The storage manager, on the other hand, is responsible for managing the physical storage of the database, including disk space allocation and access methods.
20.
_________________ mechanism will ensure that all updates made or not
Correct Answer
Transaction Support
Explanation
Transaction support is a mechanism that ensures that all updates made, whether successful or unsuccessful, are either committed or rolled back. This means that if any part of a transaction fails, all changes made within that transaction will be undone, and the database will be returned to its previous state. Transaction support guarantees data integrity and consistency by ensuring that updates are atomic, consistent, isolated, and durable (ACID properties). It provides a reliable and secure way to manage database operations, especially in multi-user and concurrent environments.