Mnesia Mastery
10 Questions
0 Views

Mnesia Mastery

Created by
@LighterGlacier7078

Questions and Answers

What is Mnesia?

  • A distributed, soft real-time database management system written in Erlang (correct)
  • A general-purpose programming language
  • A relational SQL database server
  • An office-based data processing database management system
  • What is the primary purpose of Mnesia?

  • To provide general office-based data processing
  • To replace SQL-based systems
  • To support Erlang where DBMS-like persistence is required (correct)
  • To act as a standalone programming language
  • What are the inbuilt table types in Mnesia?

  • in_memory, on_disk, hybrid
  • ram_copies, disc_copies, disc_only_copies (correct)
  • ram_storage, disk_storage, memory_storage
  • primary, secondary, tertiary
  • What is the storage characteristic of 'ram_copies' in Mnesia?

    <p>Data resides in memory and table size is limited by available memory</p> Signup and view all the answers

    What is the storage characteristic of 'disc_only_copies' in Mnesia?

    <p>Data resides only on disk and is backed by Dets</p> Signup and view all the answers

    What is the main objective of the three-level architecture in DBMS?

    <p>To enable multiple users to access the same data with personalized views</p> Signup and view all the answers

    What is the primary role of the internal level in the three-schema architecture?

    <p>Defining the physical storage structure of the database</p> Signup and view all the answers

    What is the purpose of mapping in the three-level architecture of DBMS?

    <p>To define the correspondence between different levels of the architecture</p> Signup and view all the answers

    Where does the external/conceptual mapping lie in the three-schema architecture?

    <p>Between the external level and the conceptual level</p> Signup and view all the answers

    What is the purpose of the conceptual/internal mapping in the three-schema architecture?

    <p>To define the correspondence between the conceptual and internal levels</p> Signup and view all the answers

    Use Quizgecko on...
    Browser
    Browser