CIT1214_Topic 1_Tutorial 2_MCQ

What is the primary purpose of a database?

• To store data in files

• To provide efficient retrieval, insertion, and deletion of related data

• To create documents

• To manage user access

Which of the following is a characteristic of data?

• Data is the same as knowledge

• Data is always accurate

• Data requires context to reveal meaning

• Data is processed information

What does DBMS stand for?

• Data Management Base System

• Database Model System

• Database Management System

• Data Base Management Software

Which command is used in DDL to remove a database structure?

• DROP

• SELECT

• ALTER

• CREATE

What does the term 'data integrity' refer to?

• Data being easily accessible

• Data being accurate, consistent, and reliable

• Data being stored in multiple locations

• Data being stored in a file system

Which of the following is NOT a function of a DBMS?

• Data Definition

• Data Visualization

• Data Storage

• Data Manipulation

What is the main advantage of using a DBMS over a traditional file system?

• Better data sharing

• More complex data structures

• Higher data redundancy

• Less security

Which database model organizes data in a tree-like structure?

• Relational Model

• Object-Oriented Model

• Hierarchical Model

• Network Model

What does ACID stand for in database transactions?

• Atomicity, Consistency, Isolation, Durability

• Access, Control, Isolation, Data

• Atomicity, Control, Integrity, Durability

• Accuracy, Consistency, Isolation, Data

What is the role of the external level in a database architecture?

• To define the logical structure of the database

• To manage data integrity

• To describe how data is physically stored

• To provide a user-specific view of the data