DBMS Lab viva

In the context of data models, which term refers to the current contents of the database at a particular time?

• Schema

• Instance

• Domain

• Tuple

Which architecture is explicitly associated with achieving data independence in this section?

• Two-tier architecture

• Peer-to-peer architecture

• Three-tier schema architecture

• Microservices architecture

Which pair correctly distinguishes levels of abstraction in a database system?

• Physical level vs. user interface level

• Conceptual level vs. physical level

• Domain level vs. attribute level

• Transport layer vs. application layer

Which statement best describes data independence as presented?

• Ability to run SQL without a DBMS

• Ability to change schema at one level without affecting higher levels

• Ability to store data across multiple servers

• Ability to convert string to numeric types

Which client-server design is highlighted for database systems in the material?

• Decentralized peer mesh

• Single-tier monolith

• Client-Server architecture

• Event-driven streaming

Within the relational model, which item is a structural component of a relation?

• Constraint only

• Attribute and tuple

• View and join

• Trigger and stored procedure

Which constraint category ensures uniqueness and proper identification of tuples in a relation?

• Domain constraints

• Key constraints

• Integrity constraints

• Null value importance

Which operation set is correctly grouped under DML operations in this section?

• Create, alter

• Insert, delete, update

• Select, project

• Group, aggregate, order

In the relational model, which term refers to a single row representing a record within a relation?

• Domain

• Attribute

• Tuple

• Key constraint

Which concept defines the permissible set of values that an attribute can take in a relation?

• Tuple

• Domain

• Integrity constraint

• SQL function