Database Fundamentals Assessment

What is a relational model in databases?

• A relational model is a method for storing data in files without relationships.

• A relational model is a way to structure data in tables with defined relationships between them.

• A relational model is a way to visualize data using graphs and charts.

• A relational model is a programming language for database management.

Explain the purpose of SQL in database management.

• SQL is primarily a programming language for web development.

• SQL helps in creating graphics and animations.

• The purpose of SQL in database management is to facilitate the manipulation and retrieval of data in relational databases.

• SQL is used for designing user interfaces.

What are the main types of SQL commands?

• The main types of SQL commands are DQL, DDL, DML, and DCL.

• DQL, DDL, DML, and DFL

• DQL, DDL, DML, and DCLT

• DQL, DDL, DML, and DCLX

Define normalization in the context of databases.

• Normalization is the process of organizing data in a database to minimize redundancy and dependency.

• Normalization refers to the physical storage of data in a database.

• Normalization is a method for encrypting sensitive data in databases.

• Normalization is the process of increasing data redundancy.

What are the different normal forms in database normalization?

• 1NF, 2NF, 3NF, 4NF, 5NF, 7NF

• 1NF, 2NF, 3NF, BCNF, 4NF, 5NF

• 1NF, 2NF, 3NF, 4NF, 5NF, 6NF

• 1NF, 2NF, 3NF, 6NF

What is the purpose of a primary key in a database?

• To store data in a non-relational format.

• To create relationships between different tables.

• To uniquely identify each record in a database table.

• To improve the performance of database queries.

Describe the process of database design.

• The process of database design includes requirements gathering, conceptual design, logical design, physical design, implementation, testing, and maintenance.

• Data visualization and reporting tools

• Data entry and user interface design

• Network configuration and security setup

What is an entity-relationship diagram?

• An entity-relationship diagram is a visual representation of entities and their relationships in a database.

• A chart that lists all the tables in a database without relationships.

• A diagram showing only the physical layout of a database.

• A flowchart depicting the process of data entry in a database.

How do foreign keys function in relational databases?

• Foreign keys are used to create indexes in a database.

• Foreign keys are used to store large binary files in tables.

• Foreign keys link tables and enforce referential integrity in relational databases.

• Foreign keys are only applicable in NoSQL databases.

What are the advantages of using a relational database model?

• Limited data access

• Advantages of using a relational database model include data integrity, ease of data retrieval, support for complex queries, normalization, and strong transactional support.

• Inability to handle large datasets

• High cost of implementation