Database Systems Fundamentals Quiz

The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.

The central aspect of a database application is the data themselves.

Some of the most valuable corporations are valuable not because of their physical assets, but rather because of the information they own.

<p>To simplify users' interactions with the system by hiding the complexity of data structures.</p> Signup and view all the answers

<p>It describes how the data are actually stored in complex low-level data structures.</p> Signup and view all the answers

<p>It describes what data are stored in the database and the relationships among those data.</p> Signup and view all the answers

<p>Social-media, online retailers, online advertisements, document databases, navigation systems</p> Signup and view all the answers

<p>Early databases were maintained with printed reports and paper forms, then better languages and user interfaces were developed, and now web and mobile applications allow direct customer interaction with databases</p> Signup and view all the answers

<p>Reading social-media posts, accessing online bookstores, placing online orders, retrieving bank balances and transaction information, accessing web sites and seeing personalized advertisements, using smartphones</p> Signup and view all the answers

<p>Online transaction processing and data analytics</p> Signup and view all the answers

<p>The purpose of a database system is to provide users with an abstract view of the data and to allow users to access and modify the data.</p> Signup and view all the answers

<p>The four categories of data models are the relational model, the entity-relationship model, the semi-structured data model, and the object-based data model.</p> Signup and view all the answers

<p>The most widely used data model is the relational model.</p> Signup and view all the answers

<p>Data is represented in the relational model in the form of tables, where each table has multiple columns and each column has a unique name.</p> Signup and view all the answers

<p>The purpose of database systems is to store and manipulate organizational information in a structured and efficient manner.</p> Signup and view all the answers

<p>The disadvantages include data redundancy and inconsistency, difficulty in accessing data, and the need for new application programs to handle changing rules and requirements.</p> Signup and view all the answers

<p>Data redundancy leads to higher storage and access cost due to the duplication of information in multiple files.</p> Signup and view all the answers

<p>An example of data inconsistency is when a changed student address is reflected in one department's records but not in other parts of the system.</p> Signup and view all the answers

<p>The basic features of a database are managing collections of data that are highly valuable, relatively large, and accessed by multiple users and applications.</p> Signup and view all the answers

<p>Abstraction allows users and application programmers to use a complex device or system without knowing the details of how it is constructed. In the context of database systems, abstraction provides a simpler, abstract view of the information so that users and programmers do not need to be aware of the underlying details of how data are stored and organized.</p> Signup and view all the answers

<p>Some representative applications of database systems include sales, accounting, human resources, manufacturing, banking and finance, universities, airlines, and telecommunications.</p> Signup and view all the answers

<p>The purpose of a database system is to manage a large, complex collection of data by providing a high level of abstraction and allowing for efficient storage and organization of data.</p> Signup and view all the answers

<p>Data retrieval is not convenient or efficient, data isolation is difficult, integrity problems arise, atomicity problems occur, and concurrent-access anomalies can result in inconsistent data.</p> Signup and view all the answers

<p>Database systems are designed to address the challenges of conventional file-processing environments by providing more efficient and convenient data retrieval, ensuring data integrity, maintaining atomicity of transactions, and preventing concurrent-access anomalies.</p> Signup and view all the answers

<p>Atomicity refers to the property that a transaction must happen in its entirety or not at all. It ensures that if a failure occurs during the execution of a transaction, the database can be restored to a consistent state that existed prior to the failure.</p> Signup and view all the answers

<p>Security is important to prevent unauthorized access to sensitive data. Not every user should have access to all the data in a database. Enforcing security constraints ensures that only authorized users can access specific parts of the database.</p> Signup and view all the answers

<p>The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.</p> Signup and view all the answers

<p>Database systems have evolved from simple applications in the 1960s to highly sophisticated, worldwide enterprises. They have become crucial for managing data in organizations.</p> Signup and view all the answers

<p>Data security is important in a database system to ensure the safety of the information stored, despite system crashes or attempts at unauthorized access.</p> Signup and view all the answers

<p>The purpose of data abstraction in a database system is to simplify users' interactions with the system by hiding the complexity of the underlying data structures.</p> Signup and view all the answers

<p>The physical level of data abstraction describes how the data are actually stored in the database and the complex low-level data structures used.</p> Signup and view all the answers

<p>The logical level of data abstraction describes what data are stored in the database and the relationships that exist among those data.</p> Signup and view all the answers

<p>Some disadvantages include data redundancy, data inconsistency, difficulty in accessing data, and higher storage and access costs.</p> Signup and view all the answers

<p>Data redundancy in a file-processing system leads to higher storage and access costs due to duplicated information in multiple places.</p> Signup and view all the answers

<p>The purpose of a database system is to store and manage large amounts of data efficiently, provide data security and integrity, and support data manipulation and retrieval.</p> Signup and view all the answers

<p>An example of data inconsistency in a file-processing system is when the same data appears in multiple files, and changes made to the data in one file are not reflected in other files.</p> Signup and view all the answers

<p>Examples of applications that use database systems include sales, accounting, human resources, manufacturing, banking and finance, universities, airlines, and telecommunication.</p> Signup and view all the answers

<p>A database system manages the complexity of data by providing a high level of abstraction, which allows users and application programmers to work with a simplified, abstract view of the information without needing to know the underlying details of how the data are stored and organized.</p> Signup and view all the answers

<p>The basic features of a database system include managing collections of data that are highly valuable, relatively large, and accessed by multiple users and applications. Database systems also allow for weakly structured data and data with highly variable formats.</p> Signup and view all the answers

<p>The role of abstraction in managing complexity is to provide a simplified, abstract view of complex devices or systems, such as a database system. Abstraction allows users to interact with the system without needing to know the details of how it is constructed, making it easier to manage and work with complex collections of data.</p> Signup and view all the answers

<p>The relational model uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns, and each column has a unique name.</p> Signup and view all the answers

<p>The entity-relationship (E-R) data model uses a collection of basic objects, called entities, and relationships among these objects. An entity is a 'thing' or 'object' in the real world that is distinguishable from other objects.</p> Signup and view all the answers

<p>The semi-structured data model permits the specification of data where individual data items of the same type may have different sets of attributes. JSON and Extensible Markup Language (XML) are widely used semi-structured data representations.</p> Signup and view all the answers

<p>Object-oriented programming has led to the integration of objects into relational databases. Object-based data models include notions of encapsulation, methods, and object identity.</p> Signup and view all the answers

<p>Databases in web-based services allow for the storage and retrieval of user records, connections between users, posts made by users, rating/like information about posts, sales data and orders, user product views and search terms, click history for targeted advertisements, and the maintenance of collections of articles, patents, and research papers.</p> Signup and view all the answers

<p>Early databases were maintained as back-office systems with printed reports and paper forms for input. As database systems became more sophisticated, better languages and user interfaces were developed for querying and updating data. Today, users can interact directly with databases through web applications or mobile applications.</p> Signup and view all the answers

<p>Databases support online transaction processing by allowing a large number of users to use the database simultaneously, with each user retrieving small amounts of data and performing small updates. This mode of use is common in database applications such as social media, online retailers, and online advertisements.</p> Signup and view all the answers

<p>The purpose of data analytics in database systems is to process data to draw conclusions, infer rules or decision procedures, and make business decisions. This involves automatically discovering rules and patterns from data, creating predictive models, and using these models to make decisions such as whether to give a loan to a loan applicant or which advertisement to show to a particular user.</p> Signup and view all the answers

<p>Conventional file-processing environments do not allow for convenient and efficient data retrieval. Data may be scattered in various files and in different formats, making it difficult to write new application programs to retrieve the appropriate data.</p> Signup and view all the answers

<p>Integrity problems arise when the data values stored in the database do not satisfy certain consistency constraints. For example, if a university requires that the account balance of a department may never fall below zero, enforcing this constraint in the system can be difficult, especially when constraints involve several data items from different files.</p> Signup and view all the answers

<p>Atomicity refers to the property that a database operation must happen in its entirety or not at all. It is crucial for database consistency, especially in the event of system failures. For example, in a banking system, if a failure occurs during a funds transfer, it is essential to restore the database to the consistent state that existed prior to the failure.</p> Signup and view all the answers

<p>Concurrent-access anomalies occur when multiple users are allowed to update the data simultaneously. In such cases, the interaction of concurrent updates can result in inconsistent data. For example, if two bank clerks debit the balance of an account at the same time, the concurrent executions may leave the account balance in an incorrect state.</p> Signup and view all the answers