Module 1 OF DBMS

What does DBMS stand for?

• Digital Business Management Software
• Data Backup Management System
• Database Management System
• Distributed Binary Management System

Which of the following is NOT an advantage of using a DBMS?

• Data redundancy

• Data Integrity

• Data Security

• Concurrent access

The need for a database arises due to:

• Complex UI designs

• Repeated software crashes

• Management of large amounts of data

• None of the above

In a database system, metadata refers to:

• Data that is only used for storage purposes.
• Data that is not related to other data.
• Data that describes other data.
• Data that is generated by users.

Which of the following is not a type of database?

• Relational

• Hierarchical

• Compiler-based

• Object-oriented

The component of a DBMS that interacts with the user is called:

• Database Management Tool
• User Command Line
• User Interface (UI)
• Data Processing Unit

What is the primary purpose of data modeling?

• Represent data structures logically

• Encrypt data

• Capture user inputs

• Store physical data

A data model provides:

• SQL queries

• A set of constraints and rules

• Memory allocation

• Compilation for data

Which of these is NOT a basic building block of data models?

• Entity

• Attribute

• Relationship

• Schema

Which of the following is a conceptual data model?

• ER Model

• Relational Model

• Network Model

• Physical Model