Database Management Systems Quiz
45 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

-----------is an organized, related, and structured set of data about a particular mini-world.

  • Database management system
  • Database system
  • All the answers are true
  • Database (correct)

    • ------------------ is a computerized system that enables users to create and maintain a database.

  • Database model
  • Database system
  • Database
  • Database management system (correct)

    • The DBMS software together with the data itself and sometimes, the applications are also included is

  • Database management system
  • Database
  • Database system (correct)
  • Database Application

    • DBMS Facilitates such as

    <p>Construct the initial contents</p> Signup and view all the answers

    Database administrators DBAs are responsible for

    <p>All the answers are true</p> Signup and view all the answers

    The history of Data Models may be.

    <p>All the answers are true</p> Signup and view all the answers

    A set of concepts to describe the structure of a database, the operations for manipulating these structures, and certain constraints that the database should obey.

    <p>Database Schema</p> Signup and view all the answers

    Includes descriptions of the database structure, data types, and the constraints on the database.

    <p>Database Schema</p> Signup and view all the answers

    The actual data stored in a database at a particular moment in time.

    <p>Database State</p> Signup and view all the answers

    Describes physical storage structures and access paths

    <p>Internal schema</p> Signup and view all the answers

    Describes the various user views.

    <p>External schema</p> Signup and view all the answers

    Describes the structure and constraints for the whole database for a community of users

    <p>Conceptual schema</p> Signup and view all the answers

    Provides database query and transaction services to the clients.

    <p>DBMS Server</p> Signup and view all the answers

    Specifics things or objects in the mini-world that are represented in the database

    <p>Entity</p> Signup and view all the answers

    Cardinality Ratio may be

    <p>All the answers are true</p> Signup and view all the answers

    Types of Attributes may be

    <p>All the answers are true</p> Signup and view all the answers

    Changes every time the database is updated.

    <p>Database state</p> Signup and view all the answers

    Types of degrees of relationships

    <p>All the answers are true</p> Signup and view all the answers

    Specifies maximum participation

    <p>Cardinality Ratio</p> Signup and view all the answers

    Valid State refers to the database state when it is initially loaded into the system.

    <p>False</p> Signup and view all the answers

    The duplication of data may lead to data inconsistency.

    <p>True</p> Signup and view all the answers

    If the names of students in a university are not duplicated, then the name could be a key.

    <p>True</p> Signup and view all the answers

    An entity type may have more than one key.

    <p>True</p> Signup and view all the answers

    Entities are those tangible things in the mini-world that are important to be represented in the database.

    <p>False</p> Signup and view all the answers

    Conceptual data models provide concepts that describe details of how data is stored in the computer.

    <p>False</p> Signup and view all the answers

    Database Schema is the actual data stored in a database at a moment in time.

    <p>False</p> Signup and view all the answers

    A Unary Relationship is the relationship between two different Entities.

    <p>False</p> Signup and view all the answers

    Key may be simple or composite

    <p>True</p> Signup and view all the answers

    The entity sets, which have a primary key, are a weak entity sets.

    <p>False</p> Signup and view all the answers

    What programs are encompassed in a database system?

    <p>The DBMS software, data, and sometimes applications are all encompassed in a database system.</p> Signup and view all the answers

    A database is an organized, related, and structured set of data about a particular ______

    <p>mini-world</p> Signup and view all the answers

    What are three ways a DBMS facilitates the database?

    <p>A DBMS facilitates a database by manipulating the database, maintaining the database, and providing data recovery services.</p> Signup and view all the answers

    Give three examples of different types of data models that have evolved over time?

    <p>Three examples of different types of data models are object-oriented network models, object-oriented data models, and object-oriented models.</p> Signup and view all the answers

    What is the purpose of a Database Schema?

    <p>The purpose of a database schema is to define the structure of a database, ensuring consistency and order in how data is organized.</p> Signup and view all the answers

    What is the role of a database state in relation to the database schema?

    <p>The database state represents the actual data stored at a given time, while the database schema defines the structure that guides the organization of this data.</p> Signup and view all the answers

    What are some of the advantages of using a three-tier architecture for a database system?

    <p>A three-tier architecture enhances security by separating the database server, application server, and user interface, limiting direct access to the database and improving data protection.</p> Signup and view all the answers

    What are the common problems caused by data redundancy?

    <p>Data redundancy can lead to data inconsistency, wasted storage space, wasted efforts, more difficult database updates, and slower retrieval of data.</p> Signup and view all the answers

    What is a super key?

    <p>A super key in a relational database is a set of attributes that collectively identify a tuple uniquely.</p> Signup and view all the answers

    What is the most important distinction between a primary key and a candidate key?

    <p>While both are candidate keys, a primary key is the chosen key that is used as the unique identifier for each tuple, while secondary keys are alternative candidate keys not selected as the primary key.</p> Signup and view all the answers

    What are the two main types of constraints applied in specialization/generalization relationships?

    <p>The two main types of constraints in specialization/generalization are the disjointness constraint and the completeness constraint.</p> Signup and view all the answers

    What are the key differences between disjointness and overlapping constraints?

    <p>Disjointness enforces exclusivity, ensuring subclasses are distinct and entities can only belong to one subclass. Overlapping allows shared membership, where entities can simultaneously belong to multiple subclasses.</p> Signup and view all the answers

    What are the key differences between total completeness and partial completeness constraints?

    <p>Total completeness requires every entity in the superclass to be a member of at least one subclass. Partial completeness allows entities in the superclass to exist without belonging to any subclass.</p> Signup and view all the answers

    How is attribute inheritance applied in superclass/subclass relationships?

    <p>In superclass/subclass relationships, subclasses inherit all attributes from their superclass. This means subclasses automatically inherit the characteristics of their superclasses.</p> Signup and view all the answers

    What is the practical implication of practical implication in specialization/generalization?

    <p>The practical implication is that subclasses inherit the attributes and relationships from their superclasses, but they can also add their own specific attributes or relationships to distinguish themselves.</p> Signup and view all the answers

    What are the two key aspects of the EER model?

    <p>The EER (Extended Entity-Relationship) model is an extension of the ER model, adding the concepts of specialization/generalization and constraints, such as disjointness and completeness, to refine how relationships and classifications are defined.</p> Signup and view all the answers

    Study Notes

    Q1 - Choose the Correct Answer

    • A database is an organized, related, and structured collection of data about a specific topic.
    • A database management system (DBMS) is a computer program that allows users to create and maintain databases.
    • DBMS software along with the associated data and applications is often called a database system.
    • DBMS features include manipulating database data, maintaining the database, providing data recovery services, and constructing initial content.
    • Database administrators (DBAs) manage database creation, user access, and system efficiency.
    • Data models describe database structure, types, and constraints.
    • A database schema is a concept describing database structure and constraints.
    • A database state is the data currently stored in the database.

    Q2 - Select True/False

    • A valid state of a database refers to the initial state when it is first loaded. (False)
    • Data duplication can lead to inconsistencies. (True)
    • Unique student names can be a key. (True)
    • An entity type can have more than one key. (True)
    • Entities represent important concepts within a database. (False)
    • Conceptual data models explain data storage mechanisms. (False)
    • A unary relationship describes a relationship between two different entities. (False)
    • A primary key is a simple or a composite key identifying an entity. (True)
    • Entities with a primary key can form a weak entity set. (False)

    Q3 - Database Schema Design

    • The company is organized into departments with names, numbers, and managers.
    • Departments have locations, and departments control projects.
    • Projects have names, unique numbers, and fixed locations.
    • Employees have unique social security numbers, addresses, salaries, birthdates, and sex.
    • Employees work for one department and many projects, tracking hours per week.
    • Employees have direct supervisors, and potentially multiple dependents with details such as name, sex, birthdate, and relationship to the employee.

    Q4 - Database Concepts

    • A database is a structured collection of data about a mini-world.
    • A DBMS is the software used to access and manage this data.
    • The DBMS software along with the data itself can be referred to as a database system.
    • Database users can be categorized as those who use database content, and those who design and develop the DBMS software.

    Q5 - DBMS Software

    • Databases need tools for defining types, structures, constraints, loading data, and handling updates.
    • DBMS software must support managing data through query tasks, report generation, and changes (deletion, update).
    • Data needs secure access for concurrent tasks to ensure data integrity and consistency.

    Q6 - Data Redundancy

    • Data duplication leads to data inconsistency when different copies hold conflicting data.
    • Redundancy wastes storage space and increases update difficulty and time.

    Q7 - Database Administrators (DBAs)

    • DBAs create and manage database users and authorize their access rights.
    • They manage database software and hardware resources.
    • Controlling database access, using, and monitoring efficiency.

    Q8 - Database Designers

    • Database designers define database contents, structure, constraints, and the operations and transactions to use the database.
    • They communicate with users to understand their needs.

    Q9 - Data Model History

    • Data models evolved from network models, hierarchical models, relational models, object-oriented models, and object-relational models.

    Q10 - Data Model Concepts

    • A data model describes the structure of a database.
    • A database schema is the description of the database structure and the associated constraints.
    • A database state is the value of the data in the database at a given moment.
    • Valid state denotes that the current state satisfies the schema's structure and constraints.
    • Three levels of schema: external, conceptual, and internal schemas; Data independence: describes logical and physical data independence.
    • Data independence is about the ability of the database schema to change without affecting applications.
    • Centralized DBMS combines all data management services.
    • DBMS servers handle queries and transactions for applications.
    • Three-tier architecture separates presentation, application, and database layers.

    Q11 - Entity Relationships

    • Entities refer to real-world objects or concepts in a database.
    • Keys identify unique entities.
    • Attributes describe the characteristics of an entity type.
    • Degree of relationships: Describes relationships between entities.

    Q12 - Specialization/Generalization

    • A subclass inherits attributes and relationships from a superclass.
    • Specialization defines a new set of subclasses based on the superclass's attributes.
    • Generalization combines entity types with common characteristics into a common superclass.
    • Constraints (Disjoint or Overlapping) refer to the attributes for entities, and determines how entities can belong to the subclasses.
    • Attributes like Name, SSN, are inherited by entities in subclasses like secretary, technicians and engineers.
    • Relationships associated with the superclass can also be inherited by subclasses.
    • Total completeness requires each entity in the superclass to be a member of a subclass.
    • Partial completeness allows some entities in a superclass to not be members of any subclass.
    • Disjoint subclass implies no overlapping members between subclasses.
    • Overlapping subclasses allow members to be in more than one subclass.

    Q13 - Constraints

    • Total Completeness: Every entity in the superclass must be a member of at least one subclass.
    • Partial Completeness: Every entity in the superclass doesn't necessarily need to be in any subclass.
    • Disjointness: Subclasses don't share members.
    • Overlapping subclasses: Subclasses may share members.

    Q14 - Retrieval

    • Data retrieval is done via SQL queries.
    • Indexing is often used for efficient data retrieval.

    Q15 - Primary Keys

    • A primary key uniquely identifies each row within a table.
    • Primary keys prevent duplicate data.
    • Primary keys enable the establishment of relationships between entities.
    • Primary keys allow the DBMS to create indexes for effective data retrieval.

    Q16 - Primary Key Rules

    • Primary keys should not contain NULL values.
    • Primary keys should be stable.
    • Designers should control the values of primary keys.
    • Simpler keys (single attributes) are preferred over composite keys.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Database Past Paper PDF

    Description

    Test your knowledge on Database Management Systems (DBMS) with this quiz. You'll cover concepts such as database structure, administration, and data states. Perfect for students learning about databases and their management.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser