DBMS AIT QUIZ

In a relational database, what is a relation?

• A database table
• A primary key constraint
• A foreign key relationship
• A data record

Which statement accurately describes a key difference between a Database System and a File System?

• File Systems provide data independence, whereas Database Systems do not.
• Database Systems use a hierarchical structure, while File Systems use a relational structure.
• Database Systems support complex data queries and transactions, unlike File Systems.
• File Systems are more scalable and efficient for large-scale data storage compared to Database Systems.

What is the primary goal of the physical level of abstraction?

• To provide a community view of the database
• To describe the logical structure of data
• To describe how data is stored in the database
• To interact with end users

 In a File System, data redundancy is a common issue. How does a Database System address this problem?

• By implementing complex file compression techniques
• By enforcing normalization rules to eliminate data redundancy
• By allowing direct access to physical storage devices
• By supporting multiple file formats for data storage

Which feature distinguishes a Database Management System (DBMS) from a simple File System?

• DBMS supports centralized file storage across multiple locations.
• DBMS provides integrated backup and recovery mechanisms.
• DBMS allows concurrent access and multi-user transaction processing.
• DBMS uses flat files for storing data, unlike hierarchical files in File Systems.

What is a key disadvantage of using a File System instead of a Database System for data management?

• File Systems lack data security features.
• File Systems are more complex and require specialized training.
• File Systems do not support data independence and data normalization.
• File Systems offer limited support for complex data queries and transactions.

Which role involves designing the logical structure of the database and defining schemas?

• Database Administrator (DBA)
• Database Designer
• Application Programmer
• End User

What are some of the advantages of using a database system? (Choose two)

• Data sharing and redundancy control.
• Improved data integrity and security.
• Complicated data manipulation process.
• Difficulty in retrieving specific data.

What is a field in a database?

• A large collection of data.
• A database object that stores a specific piece of data (e.g., name, age).
• A row in a database table.
• The logical design of the database.

What is the main function of a constraint in a database?

• To suggest data for a new record.
• To enforce data integrity by setting rules for acceptable values
• o simplify the process of writing queries.
• To connect tables with similar data.