DBMS MCQs Quiz

Which of the following best describes a DBMS?

• A set of programming languages

• A set of related data

• A software to manage databases

• A type of operating system

Which model uses entities, attributes, and relationships to represent data?

• Relational Model

• Hierarchical Model

• Network Model

• ER Model

In the relational model, a row is known as:

• Attribute

• Tuple

• Schema

• Degree

Which data model uses a tree-like structure?

• Relational Model

• Network Model

• Hierarchical Model

• Object Model

The key feature of the network model is:

• Hierarchical ordering

• Many-to-many relationships

• Encapsulation

• Multi-dimensional data

Which of the following is not a type of database user?

• Naive user

• Application programmer

• Sophisticated user

• Superuser

DDL is used for:

• Manipulating data

• Controlling access

• Defining database schema

• Querying the database

The degree of a relation refers to:

• Number of tuples

• Number of attributes

• Cardinality

• Relationship strength

Which of the following constraints ensures uniqueness in a relation?

• Primary Key

• Foreign Key

• Not Null

• Check

A weak entity does not have:

• Attributes

• Relationships

• Primary Key

• Participation