Ch 06: Entity-Relationship (ER) Model

Foundations of conceptual database modeling, identifying business enterprise objects, and visualizing complex system interactions via ER diagrams.

4 Questions4 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 1 – 4 of 4 Questions

Page 1 of 1

❓ MCQ📘 CS403📑 Lec 6🏷️ 06.2. Data DictionaryEasy🔁⭐💡📄🎓VU🏛️VU

What is the alternate name commonly used for a Data Dictionary in relational database management systems?

💻 sql Snippet

SELECT * FROM sys.tables;

A.Index
B.Metadata
C.Data
D.System Catalog

❓ MCQ📘 CS403📑 Lec 6🏷️ 06.6. Types of Database DesignMedium🔁⭐💡📄🎓VU🏛️VU

True or False: The RAID storage model combines the elements of the waterfall model with the philosophy of prototyping.

A.True
B.False

🧠 Long Problem📘 CS403📑 Lec 6🏷️ 06.3. Database Design PhaseHard🔁⭐💡📄🎓VU🏛️VU

In the database development lifecycle, why do we choose and specify a particular DBMS *after* completing the conceptual data model rather than before it?

❓ MCQ📘 CS403📑 Lec 6🏷️ 6.1. Transaction ManagementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following is defined as an atomic sequence of database operations?

💻 sql Snippet

BEGIN TRANSACTION;
UPDATE Account SET balance = balance - 100 WHERE acc_id = 1;
UPDATE Account SET balance = balance + 100 WHERE acc_id = 2;
COMMIT;

A.Transaction
B.Concurrency
C.Relations
D.Schema

Ch 06: Entity-Relationship (ER) Model

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units