Find Interview Questions for Principal Global Services

Right Answer:
DDL (Data Definition Language): Used to define and manage database structures (e.g., CREATE, ALTER, DROP).

DML (Data Manipulation Language): Used to manipulate data within the database (e.g., SELECT, INSERT, UPDATE, DELETE).

DCL (Data Control Language): Used to control access to data in the database (e.g., GRANT, REVOKE).

TCL (Transaction Control Language): Used to manage transactions in the database (e.g., COMMIT, ROLLBACK, SAVEPOINT).

Right Answer:
Multitasking refers to the ability of an operating system to execute multiple tasks or processes simultaneously by rapidly switching between them, giving the illusion that they are running at the same time. Multiprogramming, on the other hand, is a method where multiple programs are loaded into memory and the CPU switches between them to maximize resource utilization, allowing for better performance and efficiency.

Right Answer:
When you create a pointer for the abstract class and point it to the derived class object, calling the function `x()` will invoke the implementation in the derived class, assuming it overrides the abstract method.

Right Answer:
```python
def transpose_matrix(matrix):
return [[matrix[j][i] for j in range(len(matrix))] for i in range(len(matrix[0]))]

# Example usage:
matrix = [[1, 2, 3], [4, 5, 6], [7, 8, 9]]
transposed = transpose_matrix(matrix)
print(transposed)
```

Right Answer:
A semaphore is a signaling mechanism that can allow multiple threads to access a resource, while a mutex (mutual exclusion) is a locking mechanism that allows only one thread to access a resource at a time.

Right Answer:
**Basic GUI Design:**

1. **Home Page:**
- Search bar for movies
- List of currently showing movies with posters
- Links to user login and registration

2. **Movie Details Page:**
- Movie title, description, showtimes, and ratings
- "Book Now" button

3. **Booking Page:**
- Select theatre and showtime
- Seat selection (interactive seating chart)
- User login/registration prompt if not logged in
- Payment details form (including saved card option)

4. **User Profile Page:**
- View past bookings
- Rate movies
- Manage saved card details

**Database Tables:**

1. **Users Table:**
- user_id (PK)
- username
- password_hash
- email
- saved_card_details

2. **Movies Table:**
- movie_id (PK)
- title
- description

Right Answer:
To determine realistic schedules for a project, I follow these steps:

1. Define project scope and deliverables.
2. Break down tasks into smaller, manageable components (Work Breakdown Structure).
3. Estimate the time required for each task using historical data and expert input.
4. Identify dependencies between tasks to understand the sequence of work.
5. Consider resource availability and constraints.
6. Use project management tools to create a timeline and visualize the schedule.
7. Review and adjust the schedule based on team feedback and potential risks.
8. Monitor progress regularly and be flexible to make adjustments as needed.

Right Answer:
1. Define project objectives and goals.
2. Identify stakeholders and their needs.
3. Assess project feasibility and risks.
4. Establish a project scope and deliverables.
5. Create a project timeline and milestones.
6. Determine budget and resources required.
7. Formulate a communication plan.
8. Assemble the project team and assign roles.

Right Answer:
I handle change requests by following a structured process: first, I assess the impact of the change on the project scope, timeline, and budget. Then, I consult with stakeholders to gather their input and approval. After that, I document the change request and update project plans accordingly, ensuring clear communication with the team about the changes. Finally, I monitor the implementation of the change to ensure it aligns with project goals.

Right Answer:
To ensure successful executive sponsorship of a project, the following actions are required:

1. **Clear Vision and Goals**: Define and communicate the project's objectives and expected outcomes.
2. **Active Engagement**: Regularly participate in project meetings and discussions to provide guidance and support.
3. **Resource Allocation**: Ensure that necessary resources (budget, personnel, tools) are available for the project.
4. **Stakeholder Communication**: Facilitate communication between stakeholders and the project team to address concerns and expectations.
5. **Risk Management**: Identify potential risks and support the team in developing mitigation strategies.
6. **Advocacy**: Promote the project within the organization to gain buy-in and support from other leaders.
7. **Feedback and Support**: Provide constructive feedback and support to the project manager and team throughout the project lifecycle.

Right Answer:
I use tools like Microsoft Project, Trello, Asana, Jira, and Gantt charts to monitor and control projects. Additionally, I utilize dashboards and reporting tools for tracking progress and performance.

Right Answer:
The girl in the photograph is the man's niece.

Right Answer:
The minimum number of times the balls have to be weighed is 8.

Right Answer:
The profit will be shared in the ratio of 2:3:5 (X:Y:Z).

Right Answer:
Indu would have suffered a loss of Rs. 10.

Right Answer:
The work will be completed in 10 days by 12 men and 8 women.