Accenture Interview Questions (10+ Questions)

Harden Docker containers by eliminating root user execution. Create non-root users with specific UIDs, apply proper file permissions, and use the USER instruction to enforce least privilege. Reduce Linux capabilities, mitigate container escape risks, and comply with security frameworks (CIS Docker Benchmark, OWASP). Essential for production deployments, Kubernetes security policies, and enterprise compliance requirements.

Enable cross-platform container deployments by building images for multiple architectures (amd64, arm64) with Docker Buildx. Create builder instances, configure buildkit, build simultaneously for multiple platforms, push unified manifest lists to registries, and verify automatic architecture selection. Essential for supporting diverse hardware (x86, ARM servers, Apple Silicon), cloud deployments, edge computing, and ensuring single image tags work across infrastructure.

Create Kubernetes Namespace: Set Up an Isolated Environment for Application Workloads. Establish an isolated Kubernetes environment by creating a dedicated namespace for experimentation and application workloads. This improves cluster organization, enables cleaner multi-tenant setups, and lays the foundation for applying scoped RBAC, resource quotas, and policies per environment.

Kubernetes OOMKilled Troubleshooting & Resource Scaling: oom-demo Pod apps namespace. Diagnose application instability manifesting as CrashLoopBackOff by inspecting container termination states for memory exhaustion (OOMKilled). Challenge involves analyzing resource constraints and vertically scaling the memory limits configuration to accommodate the workload's runtime requirements. Essential for debugging application crashes, tuning resource requests/limits, and ensuring reliable service uptime in constrained environments.

Create an IAM user with console access, add them to an admin group with AdministratorAccess policy, and apply proper tagging using AWS CLI.

Objective

To answer the SQL interview question effectively, you need to craft a query that calculates and displays the average expenditure per customer from a table named Orders. This table records customer purchases. The results should display each customer_id alongside their avg_order_value, rounded to two decimal places. Finally, ensure the output is sorted in ascending order based on customer_id.

Additional Information

Table Schema:

• Orders:
  • order_id (INTEGER): Unique identifier for each order.
  • customer_id (INTEGER): Identifier for the customer who made the order.
  • total_amount (DECIMAL): Total amount spent on the order.
  • order_date (DATE): The date when the order was placed.

Constraints:

• Each customer_id may have multiple associated orders.
• There is at least one order present in the table.

Output Requirements:

• Columns: customer_id, avg_order_value
• avg_order_value must be rounded to two decimal places.
• Results must be ordered by customer_id in ascending order.

Detailed Query Explanation

The query you need to write should meet the specific output requirements and constraints mentioned. Here's the detailed SQL query designed to solve the problem:

SELECT 
    customer_id, 
    ROUND(AVG(total_amount), 2) AS avg_order_value 
FROM 
    Orders 
GROUP BY 
    customer_id 
ORDER BY 
    customer_id;

Keyword Optimization

When formulating the answer:

• "SQL query to determine the average expenditure per customer"
• "display customer_id alongside their avg_order_value"
• "rounded to two decimal places"
• "sorted in ascending order based on customer_id"
• "table schema includes order_id, customer_id, total_amount, and order_date"

These phrases and keywords are naturally embedded in the explanation and query to ensure the content is both informative and optimized for SEO.

Objective

Write an SQL query that calculates the monthly sales for each product, the sales from the previous month, and the percentage growth in sales from the previous month to the current month. The result should include the month, product name, current month's sales, previous month's sales, ...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Crafting an SQL Query to Summarize Sales Representatives' Performance

Objective

To accurately evaluate and summarize the performance of sales representatives, construct an SQL query that generates a detailed report featuring the following key metrics:

1. Representative's Name
2. Region
   3....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

SELECT
ROUND(
SUM(
CASE
WHEN call_category = 'n/a'
OR call_category IS NULL THEN 1
ELSE 0
END
)::DECIMAL / COUNT(*) * 100,
1
) AS uncategorised_pct
FROM
callers;

Oracle Database handles enterprise-critical data for thousands of organizations worldwide. QA testing of Database REST APIs requires comprehensive validation of SQL queries, schema operations, data updates, and performance statistics to ensure reliable data management systems....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →