American Broadcasting Company Interview Questions, Process, and Tips for Experienced

Project management focuses on managing individual projects, while program management involves coordinating multiple related projects to achieve strategic objectives.

• Project management is focused on delivering a specific output within a defined timeframe and budget.

• Program management involves overseeing a group of related projects to achieve broader organizational goals.

• Project managers typically have authority over a s...read more

Technical specifications refer to the detailed requirements and characteristics of a product or project.

• Technical specifications outline the materials, dimensions, and performance standards required for a project.

• They are often included in project contracts and used to ensure that all parties involved understand the requirements.

• Examples of technical specifications include the strength of concrete for a building founda...read more

Project methodologies are structured approaches to manage and execute projects.

• Waterfall

• Agile

• Scrum

• Kanban

• Lean

• PRINCE2

• Six Sigma

Scrum offers several benefits for teams and organizations.

• Improved productivity and efficiency

• Increased transparency and collaboration

• Faster time-to-market

• Adaptability to changing requirements

• Enhanced customer satisfaction

• Better risk management

• Empowered and self-organizing teams

SQL joins are used to combine data from two or more tables. Indexes are used to improve query performance.

• Types of SQL joins: Inner join, Left join, Right join, Full outer join, Cross join

• Indexes: Clustered index, Non-clustered index, Unique index, Filtered index

Possible joins are Inner Join, Left Join, Right Join, Full Outer Join, Cross Join

• Inner Join: returns only the matching rows from both tables

• Left Join: returns all rows from the left table and matching rows from the right table

• Right Join: returns all rows from the right table and matching rows from the left table

• Full Outer Join: returns all rows from both tables

• Cross Join: returns the Cartesian product of both tables