Unified Modeling Language Diagrams MCQs with Answers PDF Download – Test 42

MCQ 206: In component diagrams, the building block which is represented with two rectangles laid on left side is classified as:

1. type of components
2. interfaces
3. dependency relationships
4. all of above

MCQ 207: In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as:

1. OPEN CURSOR command
2. FETCH command
3. UPDATE command
4. CLOSE CURSOR command

MCQ 208: As compared to Cartesian product, the tuples which appears in the result by applying JOIN are the ones:

1. that fulfills the condition
2. that does not fulfill the condition
3. that are nested
4. that are subtracted

MCQ 209: Consider two tuples R and S, the maximum size of R and S relations is divided to expected size of join is classified as:

1. equi join selectivity
2. natural selectivity
3. join selectivity
4. theta selectivity

MCQ 210: In constructing ER diagrams, the double ovals are used to denote:

1. multi-value table
2. multi-value entity
3. multi-value attributes
4. multi-value key