DIT2223 Database Management System

What is the primary purpose of a Database Management System (DBMS)?

• Store and retrieve data

• Print reports

• Play multimedia files

• Create graphics

Which of the following is an example of a Database-System Application?

• Word Processor

• Web Browser

• Inventory Management System

• Photo Editing Software

What is the main advantage of using a relational database?

• Faster data entry

• Improved data security

• Reduced data redundancy

• Easier data visualization

In the context of a database, what is a "view"?

• A graphical representation of data

• A virtual table based on the result of a SELECT query

• A data input form

• A backup copy of the database

Which database language is commonly used for querying relational databases?

• HTML

• CSS

• SQL

• Java

What is the purpose of the database design phase?

• Enter data into the database

• Create a backup of the database

• Organize and structure data for efficient storage and retrieval

• Delete unnecessary records from the database

What is the role of transaction management in a database system?

• Manage user authentication

• Ensure data consistency and integrity

• Design database tables

• Optimize query performance

Data mining is primarily concerned with:

• Storing and retrieving data

• Analyzing and discovering patterns in large datasets

• Creating graphical representations of data

• Securing data from unauthorized access

What is the function of a Database Administrator (DBA)?

• Develop software applications

• Design database tables

• Manage and maintain the database system

• Write SQL queries

Which of the following is a key component of database architecture?

• Keyboard

• Monitor

• Storage device

• Database server