Database Management Systems

What is a database management system (DBMS)?

• A software used to create databases
• A programming language
• A hardware device used to store data
• A network protocol

What is data redundancy?

• Storing data in separate linked tables
• Storing data multiple times in different files
• Storing data in a single file
• Storing data in a cloud server

How does a DBMS address the issue of data redundancy?

• By storing data in separate linked tables
• By storing data in a single file
• By encrypting the data
• By compressing the data

What is data inconsistency?

• When data is stored in separate linked tables
• When data is stored multiple times in different files
• When data is not accurate or complete
• When data is stored in a single file

How does a DBMS address the issue of data inconsistency?

• By storing data in separate linked tables
• By storing data in a single file
• By validating the data entry
• By compressing the data

What is data dependency?

• When data is stored in separate linked tables
• When data is stored multiple times in different files
• When data is not accurate or complete
• When data is stored in a single file

How does a DBMS address the issue of data dependency?

• By storing data in separate linked tables
• By storing data in a single file
• By encrypting the data
• By compressing the data

What is a data dictionary?

• A set of data that contains metadata about other data
• A database table that stores primary keys
• A programming language used to query databases
• A hardware device used to store data

What is data modeling?

• The analysis and definition of data structures required in a database
• The process of creating a database
• The process of encrypting data
• The process of compressing data

What is a logical schema?

• A data model for a specific database that is independent of the DBMS used
• A physical representation of a database
• A programming language used to query databases
• A hardware device used to store data