Central English Boarding School Interview Questions and Answers

I have experience with various types of databases, including MS SQL. Proficient in MS SQL.

• Experienced with MS SQL database management

• Familiar with database querying using MS SQL

• Proficient in writing and optimizing MS SQL queries

To manage shrinkage and attrition, I follow a process involving regular monitoring, analysis, and implementation of strategies.

• Regularly monitor key performance indicators related to shrinkage and attrition such as turnover rates, absenteeism, and theft incidents

• Analyze root causes of shrinkage and attrition through employee feedback, exit interviews, and data analysis

• Implement strategies to address identified issues such as improving employee engagement, training programs, a...read more

Lloyd's of London Market is a specialized insurance market known for insuring unique and high-risk items. General insurance covers non-life assets and liabilities. Financial statements show a company's financial performance.

• Lloyd's of London Market is a specialized insurance market based in London, known for insuring unique and high-risk items such as ships, aircraft, and fine art.

• General insurance, also known as non-life insurance, covers assets and liabilities that are not ...read more

Shrinkage and attrition are terms used in business to describe loss of resources and employees respectively. Shrinkage is calculated as a percentage of lost inventory, while attrition is calculated as a percentage of employees leaving the company.

• Shrinkage refers to the loss of inventory or assets due to theft, damage, errors, or other factors.

• Shrinkage can be calculated by dividing the value of lost inventory by the total value of inventory, and then multiplying by 100 to ge...read more

Generate a new SSH key pair and update the instance with the new public key.

• Generate a new SSH key pair using ssh-keygen command.

• Update the instance with the new public key by adding it to the authorized_keys file.

• Ensure the new private key is securely stored and not shared.

Shrinkage and attrition can be controlled through effective training, communication, incentives, and monitoring.

• Implementing proper training programs to educate employees on the importance of reducing shrinkage and attrition.

• Establishing clear communication channels to address any concerns or issues that may lead to shrinkage and attrition.

• Offering incentives such as bonuses or rewards for meeting shrinkage and attrition targets.

• Regularly monitoring inventory levels and emplo...read more

Row level security is a feature that restricts access to specific rows in a database based on the user's permissions.

• Row level security limits access to certain rows in a database based on user roles or attributes

• It helps prevent unauthorized users from viewing or modifying sensitive data

• For example, a sales manager may only be able to view sales data for their region

• Row level security is commonly used in databases to ensure data privacy and security

Joins are used in databases to combine rows from two or more tables based on a related column between them.

• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join: Returns all rows from the left table, and the matched rows from the right table.

• Right Join: Returns all rows from the right table, and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join: Returns the Cartesian product of...read more