CMT 302 - Advanced Database Systems Chapter 1

<p>Higher impact of a failure (A)</p> Signup and view all the answers

<p>Data redundancy (A)</p> Signup and view all the answers

<p>Separation and isolation of data (C)</p> Signup and view all the answers

<p>Hardware maintenance (A)</p> Signup and view all the answers

<p>Redundant storage requirements (B)</p> Signup and view all the answers

<p>File structures are defined within program code (A)</p> Signup and view all the answers

<p>A unified access method for different data sources (B)</p> Signup and view all the answers

<p>Data is stored separately and accessed independently (D)</p> Signup and view all the answers

<p>Data dictionary (A)</p> Signup and view all the answers

<p>Booking transactions with a travel agent (C)</p> Signup and view all the answers

<p>To enable users to define, create, maintain, and control access to the database (A)</p> Signup and view all the answers

<p>An abstraction that provides users with specific subsets of data (D)</p> Signup and view all the answers

<p>Schema (C)</p> Signup and view all the answers

<p>Data manipulation language (D)</p> Signup and view all the answers

<p>It allows specification of data types, structures, and constraints. (D)</p> Signup and view all the answers

<p>They reduce complexity and customize the data appearance. (A)</p> Signup and view all the answers

<p>To provide the description of data for program-data independence (B)</p> Signup and view all the answers

<p>They interact with a database by issuing SQL statements to the DBMS. (B)</p> Signup and view all the answers

File structures are defined within application programs preventing different programs from easily sharing data.

A system where different programs manage their own data independently.

Storing the same data in multiple programs leading to wasted space and potential inconsistencies.

An approach where data is stored separately and independently from application programs.

Software that allows for centralized data management and access.

Different programs have their own data, and programs don't know about data in other programs.

The possibility of different versions of the same data being stored in different places.

Programs are written for specific tasks; a new requirement or task needs a new program.

Instructions and rules that guide database design and usage.

The person responsible for managing and maintaining the database system.

DBMSs offer benefits like controlling data redundancy, ensuring consistency, improving data sharing, and enhancing security.

A database system that combines the features of relational databases with object-oriented concepts.

DBMSs can be complex, expensive, and might require additional hardware. They can also be vulnerable to performance issues.

A shared collection of logically related data, designed to meet an organization's information needs.

Provides a description of the data within a database, enabling programs to access data independently.

A software system that allows users to define, create, maintain, and control access to the database.

Allows you to specify the data types, structures, and constraints within a database.

Provides the tools to query (retrieve) data from the database.

A personalized view of the database for each user, showing only relevant data.

Reduce complexity, provide security, customize appearance, and offer a consistent view.

Includes Hardware (computers), Software (DBMS, operating system, application programs), and Data.