SDLC
What does SDLC stand for?
Software Development Life Cycle
What does DBMS stand for?
Database Management System
What is the difference between Git and GitHub?
Git: Version control system
GitHub: Hosting for Git repositories
What are the four core values of the Agile Manifesto?
1. Individuals & interactions
2. Working software
3. Customer collaboration
4. Responding to change
What does STLC stand for?
Software Testing Life Cycle
Name two activities of the SDLC
Requirements gathering, testing
What is the difference between a primary key and a foreign key?
Primary: Unique identifier
Foreign: References primary key in another table
What command is used to stage all changes in Git?
git add .
What is the role of a Scrum Master in Agile development?
Manages Scrum process, removes blockers
What is the difference between verification and validation?
Verification: Are we building it right?
Validation: Are we building the right thing?
What is the difference between functional and non-functional requirements?
Functional: What the system does
Non-functional: How it performs
Write a SQL query to select all data from a table named "students"
SELECT * FROM students;
Explain the difference between a local repository and a remote repository
Local: Stored on a user’s machine
Remote: Hosted on a server
Define "Sprint" in Agile
A time-boxed development cycle
Define unit testing and integration testing
Unit: Tests individual components
Integration: Tests combined components
Describe the MVC architecture pattern
Model: Data logic
View: UI
Controller: Handles input
Explain the difference between an INNER JOIN and a LEFT JOIN
INNER: Matches common values
LEFT: Includes all left table rows
What does the git merge command do?
Combines branches
How does Kanban differ from Scrum?
Kanban: Continuous flow
Scrum: Iterative sprints
Can software ever be bug-free? Why or why not?
No, because of complexity and changing requirements
What is WRSPM in requirements engineering?
Wants, Requirements, Specifications, Programs, Machine
What are the four basic CRUD operations, and what do they stand for?
Create, Read, Update, Delete
What is the purpose of the git pull command, and how is it different from git fetch?
Pull: Fetches and merges
Fetch: Only retrieves updates
Explain the principle of "YAGNI" in Agile software development
You Aren’t Gonna Need It. Avoid unnecessary features
Explain the differences between manual testing and system testing
Manual: Performed by humans
System: Tests full system functionality