Database Management System By Hexogan
-
What is an Attribute?
-
It is the charecteristics of a relation
-
It is the charecteristics of entity
-
It is the charecteristics of the table
-
None
-
About This Quiz
20 Questions each carries 1 mark and the time limit is 20mins
Quiz Preview
- 2.
Which one is the middle level of Data Independence?
-
Conceptual Schema
-
Internal Schema
-
External Schema
-
None
Correct Answer
A. Conceptual SchemaExplanation
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.Rate this question:
-
- 3.
Which one is the function of DBMS?
-
Data Storage,retrival and update
-
A user accessible catalog
-
Both (i) and (ii)
-
None of the above
Correct Answer
A. 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.Rate this question:
-
- 4.
Users who actually use and control the content are
-
Workers behind the scene
-
Actors on the scene
-
Creators on the scene
-
All the above
Correct Answer
A. Actors on the sceneExplanation
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.Rate this question:
-
- 5.
DBMS catalog stores the description of the database called
-
Data Set
-
Metadata
-
File
-
Disk
Correct Answer
A. MetadataExplanation
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.Rate this question:
-
- 6.
Which is the example of Entity? (Multiple Answers)
-
Name
-
Place
-
Event
-
Emp_Id
Correct Answer(s)
A. Name
A. Place
A. EventExplanation
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.Rate this question:
-
- 7.
DBMS subsystem includes (Multiple Answers)
-
Security System and Recovery System
-
Integrity System
-
Concurrency control system
-
Binding System
Correct Answer(s)
A. Security System and Recovery System
A. Integrity System
A. Concurrency control systemExplanation
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.Rate this question:
-
- 8.
Which of these are kinds of data independence?
-
Logical
-
Entity
-
Attribute
-
Option (i) and Physical
Correct Answer
A. Option (i) and PhysicalExplanation
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.Rate this question:
-
- 9.
DBMS is a software that enables users to: (Multiple Answers)
-
Control
-
Restrict
-
Maintain
-
Permit
Correct Answer(s)
A. Control
A. MaintainExplanation
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.Rate this question:
-
- 10.
Manipulating the Database means:
-
Querying
-
Generating reports
-
Modifications to the content
-
All the above
Correct Answer
A. All the aboveExplanation
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.Rate this question:
-
- 11.
Database designers need not need to communicate with the end users
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 12.
DBMS provides interface between :
-
Data & Files
-
Users & Data
-
Applications Programs & data
-
None
Correct Answer
A. Applications Programs & dataExplanation
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".Rate this question:
-
- 13.
DBMS does not support Data communication
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 14.
__________________ mechanism is used for recovering damaged data
Correct Answer
Recovery ServiceExplanation
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.Rate this question:
- 15.
Data Dictionary is a part of disk storage and DBMS architecture
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 16.
The distinguishing parts of the record are called fields
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 17.
Data Abstraction provides:
-
Conceptual view
-
Logical View
-
Physical View
-
Multiple Views
Correct Answer
A. Conceptual viewExplanation
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.Rate this question:
-
- 18.
Integrity service is a function of DBMS
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 19.
Buffer Manager and data manager are a part of storage manager
-
True
-
False
Correct Answer
A. FalseExplanation
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.Rate this question:
-
- 20.
_________________ mechanism will ensure that all updates made or not
Correct Answer
Transaction SupportExplanation
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.Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 31, 2011Quiz Created by
Hexagon
Back to top