SDLC
What does SDLC stand for?
User requirements are derived from discussions with stakeholders, which are then refined into system requirements to define the system's _ and __ requirements
Functional, non-functional
An agile mindset means being and __.
flexible, adaptable
The _______ statement is used to retrieve data from one or more tables
Select
This programming principle reminds you to keep your code simple and avoid being overly clever or complicated.
KISS
What does verification part of the life cycle include?
Does the form collect information?
Does it send and store the information?
Does the form prevent bad user input?
Does the form collect information?
Does it send and store the information?
Does the form prevent bad user input?
What are the qualities of a good software Architecture
Faster development, Reduce overall idle time, and Maintainable software.
What are the five trademarks of agile organizations?
Strategy, Structure, Process, People, Technology
Which SQL statement is used to remove records from a table A. REMOVE B. ERASE C. DELETE D. DROP
C. Delete
This programming principle advises against copying and pasting code, reminding developers to avoid duplication of logic or data.
DRY (Don't repeat yourself)
What are symptoms of poor requirement process?
Missing requirements, changes are not controlled, high level of reworks, inconsistancy
True or False, Layered architecture is extremely performance efficient and can encapsulate everything
FALSE
Agile is a __, Waterfall is a process.
Mindset
Which of the following is an example of a Primary Key? A. student_name B. student_id C. course_title D. grade
B. student_id
This principle suggests that objects should be built using smaller, behavior-specific objects rather than inheriting from a parent class to add new behaviors.
Composition Over Inheritance
Requirements vs Specifications?
Requirement – A non-technical definition of features that users expect from the system
Specification – A technical definition of what is required for building system. We aren't trying to design it, so KEEP IT SIMPLE!
What does solid in SOLID principles stand for?
Single Responsibility, Open/Closed, Liskov Substitution, Interface Segregation, and Dependency Inversion
What is an agile project management framework that helps teams structure and manage their work through a set of values, principles, and practices?
Scrum
What does a Foreign Key do in a database? A. Stores backup of data B. Links two tables by referencing the primary key of another table C. Indexes data D. Delete duplicate data
B. Links two tables by referencing the primary key of another table
This principle warns developers not to add features or write code for functionality they might need later, emphasizing that you shouldn’t solve problems that don’t exist yet.
What is YAGNI (You Aren’t Going to Need It)
Functional vs. non-functional
Functional : A developer must implement these requirements so that users can achieve their goals with the product.
Non-Functional : Place constraints on what goals should be met in the product.
What do deployment diagrams try to display?
Specifies the physical hardware on which the software system will execute and how the software is deployed on the underlying hardware
As a _, I want to be able to assign tasks to team members, set deadlines, and track progress so that I can effectively facilitate my team’s work and ensure that projects are completed on time.
Project Manager
A DBMS is software that allows users to _____, ______, _______, and __ data in a database efficiently and securely.
create, read, update, delete
This principle states that a program should be divided into distinct sections, each handling a specific responsibility, with minimal overlap or direct access between them.
Separation of Concerns (SOC)