Database Administrator 1

What are the key principles of database design?

• Static Data Models

• Single User Access

• Normalization, Data Integrity, Relationships, Performance Optimization

• Data Redundancy

Explain the difference between a relational and a non-relational database.

• Non-relational databases require SQL for data manipulation.

• Relational databases are only used for large datasets.

• Relational databases do not support transactions.

• Relational databases use structured tables and SQL, while non-relational databases use flexible formats and do not require fixed schemas.

What is normalization and why is it important in database design?

• Normalization has no impact on data integrity.

• Normalization is important in database design because it minimizes data redundancy, enhances data integrity, and simplifies data management.

• Normalization is only necessary for large databases.

• Normalization increases data redundancy and complexity.

Describe the role of a Database Management System (DBMS).

• A DBMS is primarily used for web hosting services.

• A DBMS only stores data without any retrieval capabilities.

• A DBMS is a type of hardware used for data processing.

• A DBMS manages databases, facilitating data storage, retrieval, and manipulation while ensuring data integrity and security.

What are the different types of database users?

• Network Engineers

• Web Developers

• Database Administrators, Application Programmers, End Users, Data Analysts, System Analysts

• Database Designers

How does a primary key differ from a foreign key?

• A primary key uniquely identifies records, while a foreign key links records between tables.

• A primary key is always a string, while a foreign key can be any data type.

• A primary key is used for indexing, while a foreign key is not related to indexing.

• A primary key can be null, while a foreign key cannot.

What is the purpose of an Entity-Relationship Diagram (ERD)?

• To create a backup of the database.

• To optimize database performance.

• To visually represent the relationships between entities in a database.

• To store data in a database.

What are the advantages of using a DBMS over traditional file systems?

• Increased data duplication

• Limited access control features

• Advantages of using a DBMS over traditional file systems include improved data integrity, security, reduced redundancy, support for complex queries, and better backup and recovery options.

• Simplified data retrieval processes

Define data integrity and its significance in databases.

• Data integrity refers to the speed of data retrieval in databases.

• Data integrity is the process of backing up data regularly.

• Data integrity is the accuracy and consistency of data in a database, crucial for preventing corruption and ensuring reliable information.

• Data integrity ensures that data is stored in multiple formats.

What are the common types of database models?

• Time-series, Columnar, Object-relational

• Flat-file, Object-oriented, XML

• NoSQL, SQL, Multi-dimensional

• Hierarchical, Network, Relational, Document, Key-Value, Graph