CISC 215 : Database Design And Application Development! Trivia Questions Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Connorn
C
Connorn
Community Contributor
Quizzes Created: 1 | Total Attempts: 759
| Attempts: 759
SettingsSettings
Please wait...
  • 1/28 Questions

    A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems.

    • True
    • False
Please wait...
About This Quiz

Are you looking for a CISC 215: database design and application development trivia questions quiz? If you are practicing for your CISC exam, the best way to see if you are well prepared is to test yourself regularly, and one way to do so is to take the quiz below. How about you give it a try and see how well you will do!

CISC 215 : Database Design And Application Development! Trivia Questions Quiz - Quiz

Quiz Preview

  • 2. 

    Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because current distributed database management systems (DDBMS) do face challenges in terms of management and control. DDBMS involves the distribution of data across multiple locations, which can make it difficult to ensure consistency, security, and efficient coordination. Managing and controlling a distributed database requires addressing issues like data fragmentation, replication, synchronization, and transaction management. These complexities can make it challenging to maintain the integrity and performance of the distributed database system.

    Rate this question:

  • 3. 

    A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A fully distributed database management system (DBMS) is designed to handle the challenges of managing data and processing in a distributed environment. This means that it must be able to perform all the functions of a centralized DBMS, such as data storage, retrieval, and manipulation. Additionally, it must also handle the additional functions that are imposed by the distribution of data and processing, such as data replication, synchronization, and communication between different nodes in the distributed system. Therefore, the statement that a fully distributed DBMS must perform all the functions of a centralized DBMS and handle necessary functions imposed by data and processing distribution is true.

    Rate this question:

  • 4. 

    The transaction processor (TP) is the software component found in each computer that requests data.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because the transaction processor (TP) is indeed the software component that is responsible for requesting data in each computer. This component is responsible for initiating and managing transactions, which involve requesting and processing data from various sources. Therefore, it can be concluded that the statement is correct.

    Rate this question:

  • 5. 

    Performance transparency ensures that the system finds the most cost-effective path to access remote data.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Performance transparency refers to the ability of a system to optimize and improve the efficiency of accessing remote data. By ensuring performance transparency, the system is able to identify and utilize the most cost-effective path to access remote data. This means that the system can analyze different options, such as network latency, bandwidth availability, and cost, to determine the most efficient way to retrieve data from a remote location. Therefore, the statement "Performance transparency ensures that the system finds the most cost-effective path to access remote data" is true.

    Rate this question:

  • 6. 

    One of the advantages of a distributed database management system (DDBMS) is growth facilitation.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A distributed database management system (DDBMS) facilitates growth by allowing the database to be spread across multiple nodes or locations. This means that as the data and workload increase, the system can scale by adding more nodes or locations to handle the additional data and workload. This distributed nature also provides fault tolerance and high availability, as if one node fails, the data can still be accessed from other nodes. Therefore, the statement that growth facilitation is an advantage of a DDBMS is true.

    Rate this question:

  • 7. 

    A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A distributed database management system (DBMS) needs to have validation, transformation, and mapping functions, along with other functions, in order to effectively manage and distribute data across multiple locations or nodes. These functions ensure that data is validated for accuracy, transformed into the required format, and mapped to the appropriate locations within the distributed system. Without these functions, a DBMS would not be able to effectively handle the complexities of distributed data management. Therefore, the statement is true.

    Rate this question:

  • 8. 

    Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Distributed processing refers to the practice of dividing the processing workload of a database between multiple physically independent sites that are connected through a network. This allows for improved performance, scalability, and fault tolerance. Therefore, the statement that distributed processing shares a database's logical processing among physically independent sites connected through a network is true.

    Rate this question:

  • 9. 

    Distributed data access was needed to support geographically dispersed business units.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Distributed data access refers to the ability to access data from multiple locations or business units that are geographically dispersed. In this scenario, the statement suggests that geographically dispersed business units required distributed data access, indicating that the statement is true.

    Rate this question:

  • 10. 

    The Internet is the repository for distributed data.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because the internet is a vast network that connects millions of computers worldwide. These computers store and share data, making the internet a repository for distributed data. Users can access and retrieve information from various sources and locations through the internet, making it a decentralized and distributed system of data storage.

    Rate this question:

  • 11. 

    In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    To manage distributed data effectively, it is necessary to distribute copies or parts of the database processing functions to all data storage sites. This ensures that data can be accessed and processed efficiently from different locations, reducing latency and improving overall performance. By distributing the processing functions, it also enhances data availability and fault tolerance, as there are multiple copies of the functions available across different sites. Therefore, the statement is true.

    Rate this question:

  • 12. 

    A distributed database is composed of several parts known as database

    • Sections

    • Fragments

    • Partitions

    • Parts

    Correct Answer
    A. Fragments
    Explanation
    A distributed database is a database that is spread across multiple locations or nodes. Each location or node contains a portion of the data, which is called a fragment. These fragments are distributed or divided among the different sections or partitions of the distributed database. Therefore, the correct term to describe the parts or portions of a distributed database is fragments.

    Rate this question:

  • 13. 

    One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because one of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the highest demand, not the least demand. This allows for faster access and retrieval of data for users who need it the most.

    Rate this question:

  • 14. 

    Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false because distributed processing and distributed databases are closely related and often used together in modern computing systems. Distributed processing refers to the use of multiple computers or processors to perform tasks simultaneously, which often requires a distributed database to store and manage the data being processed. In a distributed database, data is stored across multiple locations or nodes, and distributed processing is used to access and manipulate that data. Therefore, distributed processing usually requires a distributed database, and a distributed database often requires distributed processing.

    Rate this question:

  • 15. 

    A distributed database management system (DDBMS) must be communications-media-dependent.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A distributed database management system (DDBMS) does not necessarily have to be communications-media-dependent. DDBMS is designed to store and manage data across multiple computers or servers, allowing for data distribution and replication. While communication between the different nodes in the system is crucial for synchronization and data consistency, the choice of communication media is not a requirement. DDBMS can utilize various communication technologies such as Ethernet, Wi-Fi, or even satellite links, depending on the specific requirements and infrastructure of the system. Therefore, the statement is false.

    Rate this question:

  • 16. 

    ________ transparency allows a physically dispersed database to be managed as though it were centralized.

    • Distribution

    • Transaction

    • Failure

    • Performance

    Correct Answer
    A. Distribution
    Explanation
    Distribution transparency refers to the ability to manage a physically dispersed database as if it were centralized. This means that users and applications can access and manipulate the data without being aware of its distribution across multiple locations. With distribution transparency, the complexity of managing a distributed database is hidden from users, allowing them to interact with the database as if it were a single, centralized entity.

    Rate this question:

  • 17. 

    A disadvantage of a distributed database management system (DDBMS) is that:

    • There are lack of standards

    • It is slower in terms of data access

    • Adding new sites affects other sites' operations

    • It is processor dependent.

    Correct Answer
    A. There are lack of standards
    Explanation
    A disadvantage of a distributed database management system (DDBMS) is that there is a lack of standards. This means that there may not be consistent guidelines or protocols for how the system operates across different sites or locations. This can lead to compatibility issues, difficulty in integrating different systems, and a lack of uniformity in data management and access methods. It can also make it challenging to ensure data integrity and security across the distributed system.

    Rate this question:

  • 18. 

    Centralized database management is subject to a problem such as

    • A growing number of remote locations

    • Maintaining and operating small database systems

    • Dependence on multiple sites

    • Organizational flexibility of the database

    Correct Answer
    A. A growing number of remote locations
    Explanation
    Centralized database management can become problematic when there is a growing number of remote locations. As the number of remote locations increases, it becomes challenging to maintain and operate small database systems at each location. This can lead to issues such as data inconsistency, difficulty in data synchronization, and increased network traffic. Additionally, managing a centralized database across multiple sites can create dependencies and potential bottlenecks. Therefore, a growing number of remote locations can pose challenges to the centralized management of a database.

    Rate this question:

  • 19. 

    Rapid ad hoc data became unnecessary in the quick-response decision-making environment.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    In the given statement, it is mentioned that rapid ad hoc data became unnecessary in the quick-response decision-making environment. This implies that in a quick-response decision-making environment, there is still a need for rapid ad hoc data. Therefore, the correct answer is False, as it contradicts the statement.

    Rate this question:

  • 20. 

    A(n) ________ database stores each database fragment at a single site.

    • Partially replicated

    • Unreplicated

    • Fully replicated

    • Partitioned

    Correct Answer
    A. Unreplicated
    Explanation
    An unreplicated database stores each database fragment at a single site, meaning that there is no duplication or replication of the data across multiple sites. This can be useful in certain scenarios where data consistency is not a critical requirement, or where the cost of replicating the data outweighs the benefits. However, it also means that if the site where the data is stored goes down or becomes unavailable, the data will not be accessible until the site is restored.

    Rate this question:

  • 21. 

    ________ transparency is the highest level of transparency. The end-user or programmer does not need to know that a database is partitioned.

    • Performance

    • Fragmentation

    • Location

    • Local mapping

    Correct Answer
    A. Fragmentation
    Explanation
    Fragmentation is the correct answer because it refers to the highest level of transparency in which the end-user or programmer does not need to know that a database is partitioned. Fragmentation involves dividing a database into smaller, more manageable pieces called fragments, which can be stored in different locations or servers. This allows for better performance and scalability, as the system can distribute the workload across multiple fragments. Therefore, fragmentation provides the highest level of transparency by hiding the partitioning details from the end-user or programmer.

    Rate this question:

  • 22. 

    A _______ lets a single SQL statement access the data that are to be processed by a single remote database processor.

    • Remote request

    • Remote transaction

    • Distributed request

    • Distributed transaction

    Correct Answer
    A. Remote request
    Explanation
    A remote request allows a single SQL statement to access the data that are to be processed by a single remote database processor. This means that instead of executing the SQL statement locally, it is sent to a remote database processor for processing and retrieving the necessary data. This is useful in cases where the data needed for processing is located in a different database system or on a different server.

    Rate this question:

  • 23. 

    Under the _____ scenario, all record and file-locking activities are performed at the end-user location.

    • Single-site processing, single-site data

    • Multiple-site processing, single-site data

    • Single-site processing, multiple-site data

    • Multiple-site processing, multiple-site data

    Correct Answer
    A. Multiple-site processing, single-site data
    Explanation
    In the given scenario, the correct answer is multiple-site processing, single-site data. This means that processing activities are carried out at multiple locations, but all record and file-locking activities are performed at a single end-user location. This approach allows for distributed processing while maintaining data integrity and consistency by centralizing the locking mechanisms.

    Rate this question:

  • 24. 

    A transaction processor (TP) is the software component residing on each computer that stores and retrieves data located at the site.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The given statement is false. A transaction processor (TP) is not the software component residing on each computer that stores and retrieves data located at the site. Instead, a TP is a component of a distributed system that manages and coordinates transactions across multiple computers or nodes. It ensures that all the operations within a transaction are executed successfully or none of them are.

    Rate this question:

  • 25. 

    ________ is the delay imposed by the amount of time required for a data packet to make around trip from point A to point B.

    • Data distribution

    • Replica transparency

    • Network Latency

    • Network Partitioning

    Correct Answer
    A. Network Latency
    Explanation
    Network latency refers to the delay or time taken for a data packet to travel from one point to another in a network. It is the time it takes for a packet to make a round trip from point A to point B. This delay can be caused by various factors such as the distance between the two points, the congestion in the network, the processing time at intermediate nodes, or the speed of the transmission medium. Network latency can affect the performance and responsiveness of network applications and services.

    Rate this question:

  • 26. 

    Distributed processing does not require:

    • Database processing functions to be distributed to all data storage sites

    • An existing distributed database

    • A network of interconnected components

    • Multiple sites to share processing chores

    Correct Answer
    A. An existing distributed database
    Explanation
    Distributed processing does not require an existing distributed database because distributed processing refers to the use of multiple computers or processors to perform tasks or process data. It involves breaking down a task into smaller parts and distributing them across different machines or components. While a distributed database can be used in distributed processing, it is not a requirement. Distributed processing can be implemented without a distributed database by simply distributing the processing tasks across multiple sites or components connected through a network. Therefore, an existing distributed database is not necessary for distributed processing.

    Rate this question:

  • 27. 

    One of the advantages of a distributed database management system (DDBMS) is security.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A distributed database management system (DDBMS) does not necessarily provide an advantage in terms of security. While it is true that a DDBMS can offer improved availability and fault tolerance, security is not inherently guaranteed by its distributed nature. Security measures such as access controls, encryption, and authentication must still be implemented to ensure the protection of data in a DDBMS. Therefore, the statement that security is an advantage of a DDBMS is false.

    Rate this question:

  • 28. 

    In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    In the single-site processing, single-site data (SPSD) scenario, the processing is not necessarily done on the end user's side of the system. It could be done on a centralized server or on a cloud-based platform. Therefore, the statement is false.

    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 23, 2019
    Quiz Created by
    Connorn
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.