Database Management System By Hexogan

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Hexagon
H
Hexagon
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,169
Questions: 20 | Attempts: 1,169

SettingsSettingsSettings
Computer Quizzes & Trivia

20 Questions each carries 1 mark and the time limit is 20mins


Questions and Answers
  • 1. 

    What is an Attribute?

    • A.

      It is the charecteristics of a relation

    • B.

      It is the charecteristics of entity

    • C.

      It is the charecteristics of the table

    • D.

      None

    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.

    Rate this question:

  • 2. 

    Which one is the middle level of Data Independence?

    • A.

      Conceptual Schema

    • B.

      Internal Schema

    • C.

      External Schema

    • D.

      None

    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.

    Rate this question:

  • 3. 

    Which one is the function of DBMS?

    • A.

      Data Storage,retrival and update

    • B.

      A user accessible catalog

    • C.

      Both (i) and (ii)

    • D.

      None of the above

    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.

    Rate this question:

  • 4. 

    Users who actually use and control the content are

    • A.

      Workers behind the scene

    • B.

      Actors on the scene

    • C.

      Creators on the scene

    • D.

      All the above

    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.

    Rate this question:

  • 5. 

    DBMS catalog stores the description of the database called

    • A.

      Data Set

    • B.

      Metadata

    • C.

      File

    • D.

      Disk

    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.

    Rate this question:

  • 6. 

    Which is the example of Entity?                (Multiple Answers)

    • A.

      Name

    • B.

      Place

    • C.

      Event

    • D.

      Emp_Id

    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.

    Rate this question:

  • 7. 

    DBMS subsystem includes      (Multiple Answers)

    • A.

      Security System and Recovery System

    • B.

      Integrity System

    • C.

      Concurrency control system

    • D.

      Binding System

    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.

    Rate this question:

  • 8. 

    Which of these are kinds of data independence?

    • A.

      Logical

    • B.

      Entity

    • C.

      Attribute

    • D.

      Option (i) and Physical

    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.

    Rate this question:

  • 9. 

    DBMS is a software that enables users to:      (Multiple Answers)

    • A.

      Control

    • B.

      Restrict

    • C.

      Maintain

    • D.

      Permit

    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.

    Rate this question:

  • 10. 

    Manipulating the Database means:

    • A.

      Querying

    • B.

      Generating reports

    • C.

      Modifications to the content

    • D.

      All the above

    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.

    Rate this question:

  • 11. 

    Database designers need not need to communicate with the end users

    • A.

      True

    • B.

      False

    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.

    Rate this question:

  • 12. 

    DBMS provides interface between :

    • A.

      Data & Files

    • B.

      Users & Data

    • C.

      Applications Programs & data

    • D.

      None

    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".

    Rate this question:

  • 13. 

    DBMS does not support Data communication

    • A.

      True

    • B.

      False

    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.

    Rate this question:

  • 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.

    Rate this question:

  • 15. 

    Data Dictionary is a part of disk storage and DBMS architecture

    • A.

      True

    • B.

      False

    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.

    Rate this question:

  • 16. 

    The distinguishing parts of the record are called fields

    • A.

      True

    • B.

      False

    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.

    Rate this question:

  • 17. 

    Data Abstraction provides:

    • A.

      Conceptual view

    • B.

      Logical View

    • C.

      Physical View

    • D.

      Multiple Views

    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.

    Rate this question:

  • 18. 

    Integrity service is a function of DBMS

    • A.

      True

    • B.

      False

    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.

    Rate this question:

  • 19. 

    Buffer Manager and data manager are a part of storage manager

    • A.

      True

    • B.

      False

    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.

    Rate this question:

  • 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.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 31, 2011
    Quiz Created by
    Hexagon
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.