Find Interview Questions for Advarisk

Right Answer:
```sql
CREATE PROCEDURE CreateGuidAndInsert
@NewGuid UNIQUEIDENTIFIER OUTPUT
AS
BEGIN
-- Generate a new GUID
SET @NewGuid = NEWID();

-- Insert the GUID into the table (replace 'YourTable' with your actual table name)
INSERT INTO YourTable (GuidColumn) VALUES (@NewGuid);
END
```

Right Answer:
To answer SQL queries on joins, you can use the following examples:

1. **Inner Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
INNER JOIN tableB b ON a.common_column = b.common_column;
```

2. **Left Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
LEFT JOIN tableB b ON a.common_column = b.common_column;
```

3. **Right Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
RIGHT JOIN tableB b ON a.common_column = b.common_column;
```

4. **Full Outer Join**:
```sql
SELECT a.column1, b.column2
FROM tableA a
FULL OUTER JOIN tableB b ON a.common_column = b.common_column;
``

Right Answer:
Time and material contracts are agreements where a client pays for the actual time spent by the contractor's employees and the materials used in the project, rather than a fixed price.

Right Answer:
In my previous job, I worked as a Project Manager where I was responsible for planning, executing, and closing projects. I coordinated with cross-functional teams, managed budgets, and ensured that projects were delivered on time and met quality standards.

Right Answer:
1. Project Planning
2. Resource Allocation
3. Team Formation
4. Task Assignment
5. Execution
6. Monitoring and Controlling
7. Quality Assurance
8. Communication
9. Stakeholder Engagement
10. Project Closure

Right Answer:
A project charter is a formal document that outlines the objectives, scope, stakeholders, and overall framework of a project. It serves as an official authorization for the project to begin and provides a high-level overview of what the project aims to achieve.

Right Answer:
Organizational influences are the factors within an organization that affect how projects are managed and executed. These include the organization's culture, structure, policies, processes, resources, and stakeholder expectations.

Right Answer:
QA (Quality Assurance) is the process of ensuring that the quality of a product meets specified requirements through planned and systematic activities. QC (Quality Control) is the process of inspecting and testing the product to identify defects and ensure it meets quality standards.