WorksheetsSAAD 10
Total questions: 104
Worksheet time: 52mins
Name
Class
Date
1.
Within detailed design, which outcome best fits the scope of designing both classes and databases?
a)
A purely logical model that ignores platform constraints
b)
A model ready for programming that also anticipates persistent storage decisions
c)
A requirements list limited to user interface preferences
d)
A test plan that replaces structural and dynamic models
e)
A deployment diagram with no class-level detail
2.
Which task is least aligned with the stated focus on design classes and databases?
a)
Choosing how persistent objects will be stored across program runs
b)
Translating associations into implementable links and constraints
c)
Defining access operations for attributes with restricted mutability
d)
Selecting a color theme for window widgets based on personal taste
e)
Mapping class attributes with complex types into relational structures
3.
Which ordering matches the high-level flow presented for the detailed design lecture content?
a)
Layer design, purpose, exercises, process
b)
Purpose, process, layer design, comprehensive exercises
c)
Process, exercises, purpose, layer design
d)
Purpose, layer design, process, comprehensive exercises
e)
Exercises, purpose, process, layer design
4.
A student wants to follow the lecture roadmap. Which topic should they expect to encounter explicitly?
a)
Purpose of detailed design
b)
Formal proof of algorithmic complexity
c)
Hardware micro-architecture optimization
d)
Compiler construction techniques
e)
Cryptographic protocol design
5.
Which statement best captures the analysis perspective described before detailed design begins?
a)
Analysis optimizes runtime performance under resource limits
b)
Analysis models information needs without considering technological constraints
c)
Analysis chooses programming-language-specific data structures by default
d)
Analysis is driven primarily by database indexing strategies
e)
Analysis is conducted only after implementation decisions are fixed
6.
Why does detailed design emphasize a technical perspective rather than the analysis perspective?
a)
Because detailed design must account for computing resource capabilities and limitations
b)
Because detailed design must avoid any dependence on programming technology
c)
Because detailed design eliminates the need for performance considerations
d)
Because detailed design focuses only on user interface look-and-feel
e)
Because detailed design forbids iterative refinement
7.
Which pair of model categories is described as key input to detailed design?
a)
Deployment scripts and operational runbooks
b)
Structural models and dynamic models
c)
Source code and unit tests
d)
Marketing personas and competitive analyses
e)
Network traces and log files
8.
Which output most accurately reflects what detailed design must produce?
a)
An implementation-ready model including all key implementation decisions
b)
Only a refined use case diagram without further documentation
c)
Only a database schema with no class-level implications
d)
A set of informal sketches that cannot be expressed in UML
e)
A performance benchmark report in place of a design model
9.
In the described detailed design loop, which activity is performed immediately before evaluation?
a)
Design classes
b)
Design associations
c)
Design attributes
d)
Design methods
e)
Apply to layer
10.
Which sequence best matches the iteration order of the detailed class design loop?
a)
Design methods, design attributes, design associations, design classes, evaluation
b)
Design classes, design associations, design attributes, design methods, evaluation
c)
Design associations, design classes, evaluation, design attributes, design methods
d)
Evaluation, design classes, design methods, design attributes, design associations
e)
Design attributes, evaluation, design classes, design associations, design methods
11.
When the loop is applied across layers, which layer is most directly responsible for persistence on external memory?
a)
Presentation layer
b)
Application layer
c)
Business layer
d)
Data access layer
e)
Data storage layer
12.
During detailed design, which change is most consistent with reallocating responsibilities across layers?
a)
Move low-level technical tasks out of analysis-layer responsibilities
b)
Freeze all responsibilities exactly as in analysis regardless of performance
c)
Eliminate message and event exchanges between layers
d)
Replace layered architecture with a single monolithic layer
e)
Force every intermediate result to be recomputed rather than stored
13.
Which motivation best matches transferring intermediate-result storage to new layers during detailed design?
a)
To avoid any consideration of technical conditions
b)
To better suit layered-architecture performance and interaction requirements
c)
To ensure entity objects are called directly from the user interface
d)
To eliminate the need for dynamic models
e)
To restrict the design to structural models only
14.
Why might detailed design introduce an explicit list class instead of treating a collection as implicit?
a)
Because analysis forbids collections
b)
Because the concrete implementation of data structures must be decided
c)
Because lists cannot exist in programming language libraries
d)
Because collections are always persisted as separate database tables
e)
Because inheritance cannot be used with collections
15.
A design uses a library List to hold CourseOffering objects. Which design decision is most consistent with the lecture guidance?
a)
Assume the collection exists without specifying its implementation
b)
Select an available data structure (e.g., list, set) and model it explicitly if needed
c)
Replace the collection with a UI window to simplify the model
d)
Store the collection only as derived data with no update strategy
e)
Avoid using any library data structure to keep the model language-agnostic
16.
When an analysis concept is not directly supported by a programming language, what is the recommended detailed-design response?
a)
Ignore the concept and defer it to testing
b)
Implement it using classes that realize the concept
c)
Model it only as an interface without concrete classes
d)
Replace it with a database trigger in all cases
e)
Represent it only in a deployment diagram
17.
In an object-oriented language, which approach is presented as a typical way to implement a state machine?
a)
Encode states only in database tables with no object logic
b)
Use the state design pattern with state-specific objects or classes
c)
Rely on GUI event handlers to represent state transitions
d)
Store state as comments in source code
e)
Use a file system directory structure as the state model
18.
What situation most strongly motivates introducing a descriptive (meta) class such as TypeXX?
a)
Responsibilities and attributes belong to object groups rather than individual objects
b)
Every object has completely unique values for all superclass attributes
c)
The system contains no inheritance relationships
d)
All attributes must be recalculated on every access
e)
The class has no associations to any other class
19.
How is class XX typically connected to its descriptive class TypeXX in the optimization pattern described?
a)
A one-to-many link from TypeXX to XX, usually one-way toward XX
b)
A many-to-one link from XX to TypeXX, usually one-way toward TypeXX
c)
A many-to-many link with a mandatory link class
d)
No link; values are copied manually between objects
e)
A recursive link within XX only
20.
Creating a new class to store derived attributes primarily targets which performance issue?
a)
Reducing recalculation at the cost of maintaining consistency on updates
b)
Eliminating the need to store any base attributes
c)
Avoiding the need for access operations on private attributes
d)
Guaranteeing that derived values never change
e)
Replacing relational databases with file systems
21.
If a base attribute change can affect many derived properties, which update strategy best matches the automatic procedure described?
a)
A manual nightly job that ignores intermediate changes
b)
A trigger that notifies derived-property holders to update themselves
c)
A design that never stores derived data
d)
A GUI refresh that updates only visible fields
e)
A constructor-only initialization with no later updates
22.
When similar operations appear across several classes, what is a recommended step before placing them into a parent class?
a)
Rename or parameterize operations so the shared service is truly coherent
b)
Force unrelated classes into the hierarchy to reduce the class count
c)
Remove parameters to make signatures identical even if meaning changes
d)
Replace inheritance with database foreign keys
e)
Make all attributes public so inheritance is unnecessary
23.
What is the primary risk of overusing inheritance purely as a technical optimization?
a)
It prevents adding new child classes in the future
b)
It can force semantically dissimilar classes into one hierarchy and cause side effects
c)
It makes all operations automatically private
d)
It eliminates the need for association management operations
e)
It guarantees better performance in every case
24.
To implement an association in an object-oriented language, what is the default transformation described?
a)
Convert the link into one or more attributes (possibly a collection) in the participating classes
b)
Keep the link only as a UML line with no code representation
c)
Replace the link with a database trigger in all cases
d)
Model the link only as a user interface control
e)
Encode the link only in file names on disk
25.
After converting a link into attributes, what additional design element is required to make the link usable and maintainable?
a)
Additional operations to manage and access the link attributes
b)
Removal of all methods from the class
c)
A requirement to keep attributes public
d)
A prohibition on using collections such as vectors
e)
A mandate to store the link only in the database
26.
For a one-way association, where should the attribute that implements the link be placed?
a)
Only on the origin side of the navigation flow
b)
Only on the target side of the navigation flow
c)
On neither side; it must be computed by searching the database each time
d)
Always on both sides regardless of direction
e)
Only inside a separate link class in all cases
27.
When a two-way association is implemented with attributes on both sides, what must be ensured?
a)
The attributes are never updated after construction
b)
Synchronization so each side reflects updates made on the other
c)
The association is converted into inheritance
d)
The user interface directly manages both ends
e)
The association is stored only as derived data
28.
A design uses composition between Whole and Part. Which behavior must the implementation enforce?
a)
Deleting a Part must delete its Whole
b)
Deleting a Whole must also delete its Parts
c)
Whole and Part must always be stored in separate databases
d)
Parts can exist only as read-only attributes
e)
Whole objects must never be persistent
29.
Multiplicity constraints on associations are primarily enforced through what mechanism in detailed design?
a)
Database indexing only
b)
Operations that manage the attributes representing the link
c)
User interface layout rules
d)
Static code comments
e)
Operating system permissions
30.
A binary association has attributes but no operations. If it is many-to-many, what is the recommended implementation?
a)
Place the attributes into either participating class at random
b)
Create an additional class dedicated to the association attributes
c)
Store the attributes as global variables
d)
Move the attributes into the presentation layer controller
e)
Eliminate the association attributes to keep the model simplezy
31.
When must an additional link class be created according to the association design guidance?
a)
Whenever the association is one-to-one
b)
Whenever the association has no attributes
c)
For a multi-ary association or a binary association with both attributes and operations
d)
Only when the classes are in different layers
e)
Only when the database is relational
32.
An analysis attribute has a complex type that is not a basic language type. How should it be represented in detailed design?
a)
As a separate data-structure class (often marked as a struct)
b)
As a use case diagram element
c)
As a deployment node
d)
As a database trigger
e)
As a controller state transition
33.
Why do data-structure classes used for attribute typing typically need few or no additional operations?
a)
Because their attributes are public and primarily act as a value container
b)
Because they are never instantiated at runtime
c)
Because they replace entity objects entirely
d)
Because they must be persisted as a single database column
e)
Because they always implement behavioral rules
34.
A property is marked readOnly. Which access operations should be provided?
a)
Only a get operation
b)
Only a set operation
c)
Both get and set operations
d)
Neither get nor set operations
e)
A trigger that replaces access operations
35.
A property is marked frozen. Which implementation approach best matches the guidance?
a)
Provide a set operation that can be called at any time
b)
Initialize the value via a constructor parameter and avoid later changes
c)
Compute the value lazily on each access with no stored state
d)
Store the value only in the presentation layer document
e)
Enforce changes through a database view
36.
A derived value depends on base attributes that are updated one-at-a-time throughout execution. Which update strategy is most appropriate?
a)
Explicit code that updates the derived value inside base-attribute update methods
b)
Periodic recalculation only after a batch of updates
c)
Never store the derived value and never compute it
d)
Update derived values only when the UI refreshes
e)
Rely on file system timestamps to infer changes
37.
Base values are changed in a coordinated batch, and only then should derived values be refreshed. Which strategy best matches this scenario?
a)
Explicit update code triggered on each individual change
b)
Periodic recalculation after all base values have changed
c)
A one-time initialization in the constructor
d)
A strict prohibition on derived attributes
e)
A two-way association synchronization operation
38.
In the illustrated Customer example, which pairing best matches the intended use of additional structures?
a)
CusType as an enum and Address as a struct-like value container
b)
CusType as a controller and Address as a boundary interface
c)
CusType as a database table and Address as a trigger
d)
CusType as a use case and Address as an activity diagram
e)
CusType as an OID and Address as an association class
39.
Given private attributes in the Customer class, which method set is most consistent with the access guidance?
a)
Expose all attributes as public fields and remove accessors
b)
Provide get operations for identifiers and get/set operations for changeable properties like name
c)
Provide only set operations to prevent reads
d)
Provide only get operations for all attributes regardless of mutability
e)
Provide database views instead of class methods
40.
Which diagram type is described as most useful when a method has many stages and many situational choices, with few participating classes?
a)
Activity diagram
b)
Interaction diagram
c)
Deployment diagram
d)
Component diagram
e)
Class diagram
41.
Which diagram type is described as most appropriate when a method involves many participating classes but few situational choices?
a)
Activity diagram
b)
Interaction diagram
c)
State machine diagram
d)
Package diagram
e)
Node diagram
42.
Which set of layers is explicitly included in the detailed layer design discussion?
a)
Presentation, application, business, data access, data storage
b)
Kernel, device driver, boot loader, hypervisor, firmware
c)
Network, transport, session, presentation, application
d)
UI, compiler, linker, runtime, scheduler
e)
Client, server only
43.
In the layered decomposition presented, which layer typically mediates between business entities and the storage mechanism?
a)
Presentation layer
b)
Application layer
c)
Business layer
d)
Data access layer
e)
Data storage layer
44.
Which description best matches the scope of the presentation layer in a client/server architecture?
a)
The external-memory persistence mechanism
b)
The interface between the human and the computer
c)
The entity classes reflecting the application domain
d)
The set of database triggers implementing derived attributes
e)
The distributed object catalog for OID lookup
45.
Why is the presentation layer characterized as the most changeable part of the system?
a)
Because entity objects are frequently redefined by user preferences
b)
Because interface techniques evolve quickly and users demand interaction innovation
c)
Because it owns all business rules and must be rewritten each release
d)
Because database schemas are unstable and drive constant UI changes
e)
Because it must store persistent data objects directly
46.
Window-based user interfaces are described using three concepts. Which mapping is consistent with that framing?
a)
Windows and content as display, user-triggered actions as behavior, streams through controls as functionality
b)
Windows and content as functionality, user-triggered actions as display, streams as behavior
c)
Windows and content as behavior, actions as functionality, streams as display
d)
All three are treated as the same concept for simplicity
e)
Only behavior and functionality are relevant in window-based UI
47.
In the described UI concepts, information exchanged through textbox and listbox controls belongs primarily to which aspect?
a)
Display structure
b)
Behavioral aspect
c)
Functional aspect of information exchange
d)
Data storage aspect
e)
Inheritance aspect
48.
What design risk is highlighted when GUI tool convenience is abused?
a)
A tendency to increase coupling across layers and break the intended layer boundaries
b)
A guarantee that classes become more cohesive within a layer
c)
Automatic enforcement of weak coupling between all classes
d)
Elimination of the need for application-layer documents
e)
Removal of all synchronization requirements between windows
49.
Which practice most directly mitigates the risk of the UI calling entity objects directly for data retrieval?
a)
Allow the view to query entities directly for performance
b)
Apply MVC and have the application layer provide documents to the UI
c)
Store all entities inside the controller to avoid cross-layer calls
d)
Replace documents with global variables shared by windows
e)
Remove the business layer to simplify access paths
50.
In the described MVC approach, why does the user interface access a document rather than entity objects directly?
a)
Because documents are built by the application layer to mediate and package entity information for the UI
b)
Because entity objects cannot be displayed in any window-based interface
c)
Because the business layer must never be queried
d)
Because documents replace the need for entity classes
e)
Because only the presentation layer is allowed to store persistent data
51.
Which statement best describes the relationship between views, documents, and entity objects in the design?
a)
Each document corresponds to exactly one entity object, always
b)
A view typically corresponds one-to-one with a document, and a document may aggregate multiple entities
c)
A view controls multiple controllers, and documents are optional
d)
Documents belong to the business layer and models belong to the application layer
e)
Controllers are replaced by documents for state transitions
52.
Which responsibility is assigned to the controller in the presentation layer design?
a)
Managing database joins for reporting queries
b)
Managing UI dynamics and state transitions in response to user events
c)
Owning persistent entity objects and their storage
d)
Serving as the document that packages entity information
e)
Replacing the business layer with UI logic
53.
Which relationship is explicitly stated between View and Controller?
a)
Many-to-many
b)
One-to-one
c)
One view to many controllers, always
d)
No relationship; controllers are optional
e)
Controllers are shared across all views by default
54.
Which characterization best fits the application layer described in the lecture?
a)
It is primarily composed of control classes that guide application processes
b)
It is composed only of entity classes reflecting the domain
c)
It is limited to window rendering and widget placement
d)
It is the external-memory storage mechanism
e)
It contains only database triggers and stored procedures
55.
Which task is most appropriate to assign to the application layer rather than the business layer?
a)
Defining the domain attributes and core entity operations
b)
Guiding end-to-end application processes and coordinating rules enforcement
c)
Choosing SQL data types for table columns
d)
Storing persistent objects on disk
e)
Implementing GUI window resizing behavior
56.
A rule states that an attribute must always be an integer from 1 to 5. Which rule category does this belong to?
a)
Derivation rule
b)
Integrity rule
c)
Behavioral rule
d)
Storage rule
e)
Presentation rule
57.
A rule states that when a microwave door opens, the light must turn on. Which rule category best matches this?
a)
Integrity rule
b)
Derivation rule
c)
Behavioral rule
d)
Normalization rule
e)
Catalog rule
58.
Beyond business rules, which set of technical requirements is highlighted for detailed design of the application layer?
a)
Encryption, compression, and load balancing
b)
Synchronization of windows, optimization of data load, and tight control of user interaction
c)
Device driver selection, kernel tuning, and memory paging
d)
Compiler flags, linker scripts, and binary patching
e)
User training, documentation, and marketing
59.
What is the primary role of a document in the application-layer framework described for window interaction?
a)
It is the database table that stores entity objects
b)
It represents the memory image exchanged between the system and a window
c)
It is a replacement for the controller in MVC
d)
It is the file system container for persistent objects
e)
It is the superclass that provides shared operations
60.
The framework defines one document per window. Which implication best follows from this design choice?
a)
Different windows can share data only by linking their documents explicitly
b)
Windows can directly share entity objects without coordination
c)
Documents must be stored permanently as tables
d)
Controllers become unnecessary for UI dynamics
e)
The business layer must be merged into the presentation layer
61.
Two windows present data from the same geographic source, one as text and one as a map. What mechanism ensures they remain consistent?
a)
A direct UI call to entity objects from both windows
b)
Explicit links between the corresponding documents at the application layer
c)
A shared file system folder used by both windows
d)
A single controller shared across all views without documents
e)
A database normalization constraint only
62.
In the described approach, what is the primary purpose of linking documents for multiple windows?
a)
To eliminate the need for any entity objects
b)
To indicate shared information and prevent conflicting presentations
c)
To force all windows to use the same controller instance
d)
To move document responsibilities into the business layer
e)
To ensure all data is loaded lazily from the file system
63.
Why is loading information from entity objects considered costly in the distributed setting described?
a)
Entity objects are always stored as local files
b)
Entity objects are scattered, so each access can be expensive
c)
Entity objects cannot be identified by OID
d)
Entity objects are part of the presentation layer
e)
Entity objects cannot participate in associations
64.
Which approach best matches the optimization goal of minimizing repeated access to the same entity?
a)
Always reload entities from their source for freshness
b)
Remember previously loaded information so later requests reuse it
c)
Store entity data only in GUI widgets
d)
Replace entities with derived attributes
e)
Move entity objects into the data storage layer as controllers
65.
In the described optimization, what does a catalog primarily provide?
a)
A UI widget registry for windows
b)
A way to reference entity objects by their OID
c)
A replacement for relational tables
d)
A list of database triggers for derived values
e)
A mapping from use cases to test cases
66.
Why is the catalog organized into sub-catalogs sorted by class name?
a)
To ensure windows are synchronized automatically
b)
To allow objects to be found efficiently by OID within a class-specific grouping
c)
To eliminate the need for any object identifiers
d)
To force a one-to-one mapping between classes and tables
e)
To keep entity objects independent of distribution concerns
67.
What is the role of creating an EntityComponent instance when a new entity is loaded?
a)
To store UI layout constraints for the entity
b)
To record loaded information so subsequent requests can avoid direct entity access
c)
To convert the entity into a database table
d)
To enforce multiplicity constraints on associations
e)
To replace the entity with a parent class
68.
In the catalog structure, which element most naturally stores the mapping from className to a class-specific object catalog?
a)
ClassCatalog
b)
ObjectCatalog
c)
InstanceComponent
d)
PresentationView
e)
DataStorageTable
69.
What does a Load(oid) operation in an object catalog conceptually return in the described framework?
a)
A window instance that owns the oid
b)
An object representation retrieved by its identifier
c)
A database view definition
d)
A multiplicity constraint value
e)
A controller state transition table
70.
A user clicks a menu item in a window. According to the design, what should this action produce?
a)
A request to execute a specific operation within the window document
b)
A direct update to a business entity attribute
c)
A database schema migration
d)
A reallocation of responsibilities across layers
e)
An automatic conversion of associations into link classes
71.
Why is the document positioned as the recipient of window commands in the described architecture?
a)
Because windows are intended to remain toolkit-like and independent of application-specific command logic
b)
Because documents are the only persistent objects in the system
c)
Because controllers must never process events
d)
Because entity objects cannot be invoked by any layer
e)
Because databases cannot represent operations
72.
Which scenario best illustrates why a window command cannot be transmitted immediately to a document?
a)
The command must be blocked while permissions are checked
b)
The command is always safe because UI toolkits enforce business rules
c)
The document must never execute any operations
d)
Commands are stored only in the database, not in memory
e)
The window must manage undo/redo by itself to stay independent
73.
To support undo and redo for a sequence of user commands, which requirement must the application satisfy?
a)
Forget each command immediately after execution
b)
Remember and manage the sequence of consecutive commands
c)
Ensure commands are never queued
d)
Convert each command into a database foreign key
e)
Move command logic into GUI toolkit code
74.
Why must entity classes in the business layer typically include get and set operations for attributes during detailed design?
a)
Because attributes are declared private by default
b)
Because attributes must always be public in UML
c)
Because databases require getters to create tables
d)
Because controllers cannot access documents
e)
Because entity objects are rarely persistent
75.
Which additional responsibility is explicitly assigned to business-layer entity classes beyond discovered analysis attributes and operations?
a)
Owning window synchronization links directly
b)
Passing update requests down to the data storage layer
c)
Replacing the application layer documents
d)
Managing GUI toolkit independence
e)
Implementing file system query languages
76.
Which statement best defines a persistent data object in the lecture context?
a)
An object that must survive beyond the end of program execution
b)
An object that exists only while a window is open
c)
An object that is always readOnly
d)
An object that cannot participate in associations
e)
An object that is only a derived attribute container
77.
Which class types are described as rarely being stored permanently compared to entity objects?
a)
Boundary objects and control objects
b)
Entity objects
c)
Descriptive meta-classes only
d)
Struct-like value classes only
e)
Enumeration types only
78.
Why are file systems described as unsuitable for complex data queries in larger critical systems?
a)
They cannot read or write objects at all
b)
They do not support complex query management in the way databases do
c)
They force every link to be many-to-many
d)
They eliminate the need for joins entirely
e)
They automatically provide relational normalization
79.
Which statement best reflects why relational DBMS is described as the most commonly used storage method?
a)
It directly stores objects without any design effort
b)
It manages relational data and offers many DBMS options across requirements and platforms
c)
It is used only for small, non-critical systems
d)
It forbids distribution and high volume
e)
It replaces the need for a business layer
80.
Which set correctly lists the four main NoSQL DBMS groups described?
a)
Key-value, column, document, graph
b)
Row, tuple, pointer, index
c)
Tree, stack, queue, bag
d)
Window, document, controller, model
e)
Class, attribute, association, inheritance
81.
A system ingests social-media text and images at very high update rates and stores multiple formats at terabyte scale. Which storage choice is described as suitable?
a)
A file system as the primary query engine
b)
A non-relational (NoSQL) DBMS
c)
Only an object-oriented DBMS because design is eliminated
d)
Only a relational DBMS because joins are always cheap
e)
No persistent storage because data is large
82.
In mapping permanent classes to a relational model, which correspondence is described as the default?
a)
Class to table, simple attribute to column, object instance to row
b)
Class to view, attribute to trigger, object to index
c)
Class to file folder, attribute to file name, object to file
d)
Class to controller, attribute to event, object to window
e)
Class to node, attribute to deployment artifact, object to process
83.
In the described mapping, what role does an object's OID play in its table representation?
a)
It acts as a foreign key to every other table by default
b)
It acts as the primary key of the corresponding row
c)
It replaces all other attribute columns
d)
It is stored only in the application-layer document
e)
It is unnecessary because objects map to joins, not rows
84.
A class attribute has a complex type that does not map to a single SQL type. Which transformation is consistent with the guidance?
a)
Drop the attribute from storage because SQL does not support it
b)
Use multiple columns for fields or a separate table linked by a foreign key
c)
Store the attribute only as a GUI widget value
d)
Convert the attribute into an inheritance hierarchy
e)
Always store the attribute as a single varchar column regardless of structure
85.
Which relational construct is described as a typical representation for an association or relationship between classes?
a)
A foreign key or an association (link) table
b)
A controller object
c)
A window document
d)
A class stereotype only
e)
An activity diagram
86.
In the correspondence summary, how is inheritance represented in the relational model according to the lecture?
a)
It is preserved automatically with no special processing
b)
It uses a shared primary key across multiple tables
c)
It is replaced by GUI controllers
d)
It becomes a many-to-many association table only
e)
It can be stored only in file systems
87.
In the UML storage-structure diagram convention, what naming pattern is used for table classes?
a)
Class names are prefixed with T_
b)
Class names are suffixed with _TableOnly
c)
Class names are replaced by numeric IDs
d)
Class names keep the same prefix as OID values
e)
Class names are removed and replaced by views
88.
What is the described purpose of transforming the UML table-stereotyped diagram into DDL via a helper tool?
a)
To generate database table definitions that can be created in the DBMS
b)
To generate UI windows for each table automatically
c)
To eliminate the need for primary keys
d)
To convert derived attributes into triggers only
e)
To ensure every class maps one-to-one to a table without exceptions
89.
Why should mapping from classes to tables not be understood mechanically as one-to-one in all cases?
a)
Because one-to-one mapping can create too many tables and require too many joins
b)
Because tables cannot store attributes with simple types
c)
Because relational databases do not support foreign keys
d)
Because objects cannot be persisted at all
e)
Because joins always improve access speed
90.
What design response is suggested to reduce join overhead when many tables would otherwise be required?
a)
Split frequently retrieved data across as many tables as possible
b)
Group frequently co-retrieved data into larger tables
c)
Remove primary keys to simplify joins
d)
Replace tables with files to avoid joins
e)
Move all data into the presentation layer
91.
Two classes have a many-to-many relationship with additional attributes like year and exam result. What is the recommended object-model addition?
a)
A descriptive meta-class shared by both classes
b)
A relationship class that carries the association attributes
c)
A parent class that both classes inherit from
d)
A controller class that stores the attributes temporarily
e)
A struct-like value class that replaces both entities
92.
In the relational model, what additional artifact is required when a many-to-many relationship has its own attributes?
a)
Only foreign keys in one of the two existing tables
b)
A separate intersection/association table that stores those attributes
c)
A database view that replaces both entity tables
d)
A trigger that eliminates the need to store the relationship
e)
A file system index that encodes the relationship
93.
What problem is identified when a relational schema is produced without special processing for inheritance?
a)
Inheritance and generalization are no longer retained in the relational model
b)
Foreign keys become impossible to define
c)
Objects cannot be mapped to rows
d)
Complex attributes become easier to store than simple attributes
e)
Joins disappear entirely
94.
Why might a design intentionally downgrade strict normalization for some applications?
a)
To support reporting use cases with more convenient access patterns, even if data repeats
b)
Because normalization prevents any statistical reporting
c)
Because denormalization guarantees semantic correctness
d)
Because relational databases require repeated data by definition
e)
Because inheritance cannot be represented otherwise
95.
For a one-to-one relationship between two permanent classes, which option is described as typically best?
a)
Always create two separate tables regardless of optionality
b)
Prefer creating a single table rather than two when the relationship is truly one-to-one
c)
Always represent it as a many-to-many intersection table
d)
Store the relationship only in application-layer documents
e)
Replace one table with a file system directory
96.
If two tables are created for a one-to-one link, what key constraint relationship is described between them?
a)
Each table's primary key is also a foreign key referencing the other table
b)
Each table uses a different unrelated primary key with no foreign keys
c)
Only the many end holds a foreign key to the one end
d)
Both tables must use composite primary keys from all attributes
e)
The relationship is stored only via triggers
97.
In a one-to-many relationship between classes A (one) and B (many), where should the foreign key typically be placed?
a)
In table A as a reference to table B
b)
In table B as a reference to table A's primary key
c)
In a third table only, never in B
d)
In both tables and also in a separate intersection table
e)
Only in the presentation layer document
98.
For a many-to-many relationship between tables A and B, what is a correct characterization of the intersection table C?
a)
C contains foreign keys referencing A and B, and its primary key may be a composite of those keys
b)
C replaces A and B entirely so no foreign keys are needed
c)
C stores only derived attributes and no keys
d)
C must have a primary key unrelated to A and B
e)
C is unnecessary if the relationship has no attributes
99.
How are compositions treated when mapped to the relational model according to the lecture guidance?
a)
They are treated as normal links, and base-1 compositions should be implemented as a single table
b)
They must always be implemented as two tables with no foreign keys
c)
They are replaced by inheritance in the relational model
d)
They cannot be represented in any relational form
e)
They must be stored only as application-layer documents
100.
A class has a recursive association to itself. What is the described relational implementation?
a)
Create a new table for each recursion depth
b)
Add a column that stores primary key values of the same table as a foreign key
c)
Replace recursion with a view only
d)
Store recursive links only in a file system
e)
Use an intersection table with no foreign keys
101.
When representing inheritance in a relational model by creating a table for each class, what is a key access implication?
a)
Accessing an object typically requires a join between parent and child tables using a common OID
b)
Accessing an object never requires joins because OID is omitted
c)
Accessing an object is done only through the presentation layer
d)
Accessing an object requires triggers to reconstruct parent attributes
e)
Accessing an object requires denormalizing all child tables into the parent table at runtime
102.
Why are the table-per-class strategies described as friendly to adding child classes later?
a)
New child tables can be added without disrupting existing class tables
b)
They ensure no joins are ever needed
c)
They eliminate the need for common identifiers
d)
They require consolidating all attributes into one table
e)
They forbid views and therefore simplify the schema
103.
Which inheritance mapping strategy minimizes the number of tables but increases unused columns for some rows?
a)
Create one table per child class and repeat parent attributes
b)
Create only one table for the parent and consolidate child attributes into it
c)
Create a table for each class and require joins for access
d)
Represent inheritance only with an intersection table
e)
Store each object as a separate file
104.
Which inheritance mapping strategy is most suitable when the parent class has only a small number of attributes, but parent changes may require multiple table updates?
a)
One table for the parent with all child attributes consolidated
b)
One table for each child class, repeating parent attributes in each child table
c)
A view for each parent/child pair with no base tables
d)
A single intersection table for all classes
e)
A file system hierarchy keyed by OID
100 %
