Understanding Database Management Systems

What are the three levels of the ANSI-SPARC architecture?

• Physical Level, Logical Level, Data Level

• External Level, Conceptual Level, Internal Level

• Presentation Level, Application Level, Database Level

• User Level, System Level, Storage Level

What are two key benefits of utilizing a Database Management System (DBMS)?

• Increased data inconsistency

• Complex data management

• Enhanced data security and backup options

• Higher costs and maintenance requirements

What is data independence in the context of DBMS?

• Data independence means the database is completely isolated from the application.

• Data independence allows for unlimited data storage without any schema changes.

• Data independence refers to the ability to access data without any security restrictions.

• Data independence is the ability to change the database schema at one level without affecting other levels.

What are the primary responsibilities of a Database Administrator (DBA)?

• The primary responsibilities of a Database Administrator (DBA) include database management, performance tuning, backup and recovery, security management, and policy implementation.

• Data entry and customer support

• Network administration and hardware maintenance

• Software development and coding

Define a relational data structure.

• A relational data structure is a collection of unrelated data points.

• A relational data structure is a single table without any relationships.

• A relational data structure is a collection of data organized into tables (relations) that can be linked by relationships.

• A relational data structure is a type of data structure that only stores numeric values.

What is the purpose of keys in a relational database?

• To encrypt sensitive data in the database.

• The purpose of keys in a relational database is to uniquely identify records and establish relationships between tables.

• To store large binary files efficiently.

• To improve the speed of data retrieval operations.

Explain the difference between relations and attributes.

• Attributes are tables; relations are columns in those tables.

• Relations are the same as attributes.

• Relations refer to the data type of a column.

• Relations are tables; attributes are columns in those tables.

What is a schema in a database?

• A schema is a backup copy of a database.

• A schema is the organizational blueprint of a database that defines its structure and relationships.

• A schema is a programming language used for database queries.

• A schema is a type of database management system.

What is the significance of referential integrity?

• Referential integrity is only important for non-relational databases.

• Referential integrity is significant because it maintains data accuracy and consistency in relational databases.

• Referential integrity allows for faster data retrieval without any constraints.

• Referential integrity is a method for data encryption in databases.

Define entity integrity in the context of databases.

• Entity integrity requires foreign keys to be unique and not null.

• Entity integrity ensures that each row in a database table is uniquely identifiable through primary keys, which must be unique and not null.

• Entity integrity allows duplicate rows in a table.

• Entity integrity is concerned with the relationships between tables.