CSE 3901 Final Questions with Detailed Verified
Answers
Purpose of MVC Ans: Decouple display from content
User Interface Ans: Graphical events
Application Ans: Processing, Calculating
Data Ans: Persistence, Transactions, Triggers
Model Ans: Data, business logic
View Ans: Render content of model, presentation logic
Controller Ans: Translates user actions, application logic
Model in Web App Ans: Database, Classes that wrap database operations
View in Web App Ans: HTML files rendered in client's browser
Controller in Web App Ans: Receives HTTP requests via web server, orchestrates
activity
How to wire components together implicitly Ans: Naming & location conventions
Explicit routing based on Ans: Names & pattern matching
What is a table in a database mapped to? Ans: A class
What is a table column mapped to? Ans: Attributes of a class
What is a table row mapped to? Ans: Instances of a class
Database Ans: Collection of tables
, Plural Ans: Naming convention for table names
Properties of column Ans: Name, type
Primary key Ans: Unique identifier for each row
How to link tables Ans: Use foreign keys
Foreign keys Ans: Keys from one table included in another
Schema Ans: Definition of table, usually db-specific
Schema Properties in Ruby Ans: Allows independence from DB manager, versioned by
timestamp from migrations
SQLite vs MySQL Ans: SQLite has no configuration, MySQL has better performance
Migration Ans: Ruby code that represents a change in schema
Possible Changes with Migration Ans: Add, modify or delete tables
Migration Filename Ans: Timestamp, class name (descriptive of delta)
ActiveRecord::Migration Ans: What migration classes extend from
rake db:migrate Ans: Invoke migration, update schema
Migrations give a... Ans: Linear history of deltas
Schema is the result of... Ans: Applying migrations in order
rake db:create Ans: Create database only (no schema)
rake db:schema:load Ans: Load schema
© Get it right 2025 Getaway - Stuvia US All rights reserved
Answers
Purpose of MVC Ans: Decouple display from content
User Interface Ans: Graphical events
Application Ans: Processing, Calculating
Data Ans: Persistence, Transactions, Triggers
Model Ans: Data, business logic
View Ans: Render content of model, presentation logic
Controller Ans: Translates user actions, application logic
Model in Web App Ans: Database, Classes that wrap database operations
View in Web App Ans: HTML files rendered in client's browser
Controller in Web App Ans: Receives HTTP requests via web server, orchestrates
activity
How to wire components together implicitly Ans: Naming & location conventions
Explicit routing based on Ans: Names & pattern matching
What is a table in a database mapped to? Ans: A class
What is a table column mapped to? Ans: Attributes of a class
What is a table row mapped to? Ans: Instances of a class
Database Ans: Collection of tables
, Plural Ans: Naming convention for table names
Properties of column Ans: Name, type
Primary key Ans: Unique identifier for each row
How to link tables Ans: Use foreign keys
Foreign keys Ans: Keys from one table included in another
Schema Ans: Definition of table, usually db-specific
Schema Properties in Ruby Ans: Allows independence from DB manager, versioned by
timestamp from migrations
SQLite vs MySQL Ans: SQLite has no configuration, MySQL has better performance
Migration Ans: Ruby code that represents a change in schema
Possible Changes with Migration Ans: Add, modify or delete tables
Migration Filename Ans: Timestamp, class name (descriptive of delta)
ActiveRecord::Migration Ans: What migration classes extend from
rake db:migrate Ans: Invoke migration, update schema
Migrations give a... Ans: Linear history of deltas
Schema is the result of... Ans: Applying migrations in order
rake db:create Ans: Create database only (no schema)
rake db:schema:load Ans: Load schema
© Get it right 2025 Getaway - Stuvia US All rights reserved
