Question : Which of the following is a key benefit of using data models?
Solution :
Correct Answer : Improves communication between users and developers
Description -
Question : Which data model allows flexible structure where same type of data may have different attributes?
Solution :
Correct Answer : Semistructured Model
Description -
Question : Which of the following statements about the Entity-Relationship (ER) Model is correct?
Solution :
Correct Answer : It models data using entities and relationships
Description -
Question : Which data model represents data in the form of tables (rows and columns)?
Solution :
Correct Answer : Relational Model
Description -
Question : Which of the following best describes the primary purpose of a data model?
Solution :
Correct Answer : To define data structure, relationships, and constraints
Description -
Question : Which concept acts as a bridge between real-world objects and database design?
Solution :
Correct Answer : Data Model
Description -
Question : Which of the following is considered a component of a database schema?
Solution :
Correct Answer : Tables, keys, and constraints
Description -
Question : Which of the following statements is TRUE regarding schema and instance?
Solution :
Correct Answer : Schema remains relatively stable, instance changes frequently
Description -
Question : What is meant by a database instance?
Solution :
Correct Answer : Data stored at a particular moment in time
Description -
Question : Which of the following correctly defines a database schema?
Solution :
Correct Answer : Logical structure or design of the database
Description -
Question : Data independence is mainly achieved due to which DBMS architecture?
Solution :
Correct Answer : Three-level architecture
Description -
Question : Which of the following is TRUE about logical data independence?
Solution :
Correct Answer : It allows changes in tables without affecting user views
Description -
Question : Which type of data independence allows changes in the physical storage without affecting logical structure?
Solution :
Correct Answer : Physical Data Independence
Description -
Question : Which of the following correctly defines data independence?
Solution :
Correct Answer : Ability to modify schema at one level without affecting others
Description -
Question : What does data independence in DBMS primarily refer to?
Solution :
Correct Answer : Data defined separately from application programs
Description -
Question : Which type of DML describes what data is required without specifying how to retrieve it?
Solution :
Correct Answer : Non-procedural DML
Description -
Question : Which statement about Transaction Control Language (TCL) is correct?
Solution :
Correct Answer : It manages transactions and ensures consistency
Description -
Question : Which DBMS language is used to control access and permissions in a database system?
Solution :
Correct Answer : DCL
Description -
Question : Which of the following commands belongs to Data Manipulation Language (DML)?
Solution :
Correct Answer : INSERT
Description -
Question : Which DBMS language is primarily responsible for defining the structure and schema of a database?
Solution :
Correct Answer : DDL
Description -
Question : In a banking system, if money is debited from one account but not credited to another due to failure, which ACID property is violated?
Solution :
Correct Answer : Atomicity
Description -
Question : Which of the following is responsible for ensuring that committed data is not lost even after system failure?
Solution :
Correct Answer : Durability
Description -
Question : Which ACID property ensures that uncommitted changes of one transaction are not visible to other transactions?
Solution :
Correct Answer : Isolation
Description -
Question : If a database moves from one valid state to another after a transaction, which ACID property is maintained?
Solution :
Correct Answer : Consistency
Description -
Question : Which of the following best explains the Atomicity property in DBMS?
Solution :
Correct Answer : A transaction is executed completely or not at all
Description -