Database Systems Quiz

What is data?

• Facts and statistics stored or free-flowing over a network

• Processed information

• Raw and unprocessed information

• Data is not defined in the text

What is a database?

• A collection of related data organized in a way that data can be easily accessed, managed, and updated

• A software-based tool for creating, defining, and manipulating databases

• A hardware component used to store data

• A network for storing and processing data

What is a DBMS?

• A software that allows creation, definition, and manipulation of databases

• A hardware component used to store data

• A programming language for accessing databases

• A network for storing and processing data

What are the characteristics of a DBMS?

• Data stored into tables, reduced redundancy, data consistency, support for multiple users and concurrent access, query language, security, and transaction support

• Data stored into tables, increased redundancy, data inconsistency, support for single user access, no query language, no security, and no transaction support

• Data stored into files, reduced redundancy, data inconsistency, support for multiple users and concurrent access, query language, security, and transaction support

• Data stored into tables, reduced redundancy, data inconsistency, support for single user access, query language, security, and transaction support

What are the advantages of a DBMS?

• Segregation of application program, minimal data duplicity, easy retrieval of data, reduced development time and maintenance need, and seamless integration into application programming languages

• Integration of application program, increased data duplicity, difficult retrieval of data, increased development time and maintenance need, and no integration into application programming languages

• Segregation of application program, increased data duplicity, easy retrieval of data, reduced development time and maintenance need, and seamless integration into application programming languages

• Integration of application program, minimal data duplicity, difficult retrieval of data, increased development time and maintenance need, and no integration into application programming languages

What are the components of a DBMS?

• Hardware, software, data, procedures, database access language, and users

• Hardware, software, data, procedures, programming language, and users

• Hardware, software, files, procedures, database access language, and users

• Hardware, software, data, procedures, query language, and users

What is the purpose of the hardware component in a DBMS?

• To store data and provide physical components for data storage and retrieval

• To provide an interface for users to interact with the DBMS

• To define the logical design and structure of the database

• To manage the security and access control of the database

What is the main component of a DBMS?

• Software

• Hardware

• Data

• Procedures

What is the purpose of the data component in a DBMS?

• To store the actual data and metadata about the data

• To provide an interface for users to interact with the DBMS

• To define the logical design and structure of the database

• To manage the security and access control of the database

What are procedures in a DBMS?

• General instructions to use a database management system

• Commands to access, insert, update, and delete data stored in a database

• A simple language designed to write commands for accessing and manipulating data

• Users who manage the complete database management system