ICT502 LECTURE 1

What is a database?

• A type of software

• A collection of related data

• A collection of unrelated data

• A programming language

Which of the following is a disadvantage of DBMS?

• Complexity

• Control of data redundancy

• Improved data integrity

• Increased productivity

What does DBMS stand for?

• Database Management System

• Data Base Management Software

• Database Model System

• Data Base Management Service

What is the purpose of a Data Definition Language (DDL)?

• To manipulate data

• To define the database structure

• To create user interfaces

• To manage database security

Which level of the ANSI-SPARC architecture describes how data is stored in the database?

• Internal level

• External level

• User level

• Conceptual level

What is the main advantage of using a database approach over a file-based system?

• Data is stored in files

• Data is more organized

• Data is less secure

• Data is harder to access

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

• To design application programs

• To manage data resources

• To create user accounts

• To write SQL queries

Which of the following is NOT a component of the DBMS environment?

• User interface

• Network software

• Operating system

• DBMS

What does data independence mean in the context of a DBMS?

• Data must be manually updated

• Applications are unaffected by changes in data structure

• Data is stored in a single location

• Data is always secure

What is the purpose of a view in a DBMS?

• To increase data redundancy

• To allow users to see a subset of the database

• To provide a backup of data

• To improve data security