Notations for Modeling Data MCQ (Multiple Choice Questions) PDF - 162

MCQ 806: UML diagrams that shows the system components along with their interconnections, is known as

1. Class diagram
2. Use case diagram
3. Implementation diagram
4. Activity diagram

MCQ 807: Application resides at the client machine and invokes database system functionality at the server machine through query statement, is the type known as

1. One-tier architecture
2. Two-tier architecture
3. Three-tier architecture
4. NO-tier architecture

MCQ 808: The term that describes the different views of the database is known as

1. Subschemas
2. Multischemas
3. Virtual Schema
4. Model schema

MCQ 809: Window queries compute an aggregate function over ranges of

1. Tuples
2. Functions
3. Attributes
4. Structures

MCQ 810: When constraints involve several data items from different files, the compounded problem is

1. Data Integrity
2. Data Inconsistency
3. Data atomicity
4. Data Isolation