Apexon Team Lead Interview Questions and Answers for Experienced

SOX Compliance is a set of regulations that public companies must follow to ensure accurate financial reporting.

• SOX stands for Sarbanes-Oxley Act

• It was enacted in 2002 after accounting scandals at Enron and WorldCom

• It requires companies to establish and maintain internal controls over financial reporting

• It also mandates regular audits and certifications of financial statements

• Non-compliance can result in fines, legal a

PCI DSS stands for Payment Card Industry Data Security Standard.

• It is a set of security standards designed to ensure that all companies that accept, process, store or transmit credit card information maintain a secure environment.

• It was created by major credit card companies such as Visa, Mastercard, American Express, Discover, and JCB International.

• It includes requirements for network security, data protection, access...read more

ISO 27K is a set of standards for information security management systems.

• ISO 27K provides guidelines for managing and protecting sensitive information.

• It includes controls for risk management, access control, and incident management.

• ISO 27K certification is often required for companies handling sensitive data.

• Examples of ISO 27K standards include ISO 27001 and ISO 27002.

Risk assessment for an application involves identifying potential threats and vulnerabilities and evaluating their impact.

• Identify potential threats and vulnerabilities

• Evaluate the impact of each threat or vulnerability

• Determine the likelihood of each threat or vulnerability occurring

• Prioritize risks based on their impact and likelihood

• Develop a plan to mitigate or manage each risk

We can achieve this by sending the data in chunks using pagination.

• Implement pagination to limit the amount of data sent per request.

• Use a cursor-based pagination approach to efficiently retrieve large amounts of data.

• Consider compressing the data to reduce the size of each chunk.

• Use HTTP range requests to retrieve specific chunks of data.

To achieve load balance and fault tolerance while deploying an application, we can use techniques like load balancing, clustering, and redundancy.

• Implement load balancing to distribute incoming traffic across multiple servers.

• Use clustering to group multiple servers together to work as a single unit.

• Ensure redundancy by having multiple instances of critical components to handle failures.

• Implement fault-tolerant mechani...read more

Shared variables are accessible by all tasks in a process, while job shared variables are only accessible by tasks in a specific job.

• Shared variables are used to share data between tasks in a process.

• Job shared variables are used to share data between tasks in a specific job.

• Shared variables can cause race conditions and should be used with caution.

• Job shared variables are useful for passing data between tasks in a job

DB activities that can be part of a transaction group

• Insertion of data into a table

• Updating data in a table

• Deletion of data from a table

• Creating or dropping a table

• Altering the structure of a table

• Executing stored procedures

• Executing functions

• Executing triggers