DB_2_ER

What is a primary function of a database system?

• Operating system management

• Data storage and retrieval

• Web browsing

• Network routing

Which of the following best defines a database?

• A spreadsheet for storing temporary data

• A collection of interrelated data

• A text document with structured records

• A file storing user credentials

What is one advantage of using a database over a traditional file system?

• Less disk space usage

• Easier user interface

• Reduced data redundancy

• No need for any software

Which component of a DBMS interacts with the end user?

• Database engine

• Query processor

• DDL compiler

• Application interface

What is a key difference between relational and non-relational databases?

• Relational databases use XML

• Non-relational databases use tables

• Relational databases use tables with fixed schemas

• Non-relational databases do not store any data

Which of the following is an example of a non-relational database?

• MySQL

• Oracle

• MongoDB

• PostgreSQL

What does ER in ER Model stand for?

• Entity Relationship

• External Record

• Extended Reference

• Entity Range

What is the role of attributes in an ER diagram?

• They define the relationship

• They provide the primary key

• They describe the characteristics of an entity

• They connect tables

Which of the following is used to uniquely identify a record in a relational model?

• Tuple

• Attribute

• Primary Key

• Entity

In a relational model, a row is also known as a:

• Field

• Attribute

• Tuple

• Domain