ATCO Interview Questions and Answers

Q1. Median of 2 sorted array
Add your answer
Q2. Linux commands for chmod
Add your answer
Q3. Features of python
Add your answer
Q4. Deepcopy and shallowcopy
Add your answer

Q1. What is ETL, and can you explain it in a structured manner?
Ans. 
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database or data warehouse.
• Extract: Involves extracting data from different sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, validated, and transformed into a consistent format suitable for analysis.

• Load: The transformed data is loade...read more
Answered by AI
Add your answer
Q2. What is the correct structure of a DBMS diagram?
Ans. 
The correct structure of a DBMS diagram includes entities, attributes, relationships, and keys.
• Entities represent the main objects in the database (e.g. Customer, Product).

• Attributes are characteristics of entities (e.g. CustomerID, ProductName).

• Relationships show how entities are related to each other (e.g. one-to-many, many-to-many).

• Keys uniquely identify each record in a table (e.g. Primary Key, Foreign Key).
Answered by AI
Add your answer

Q1. Strengths,weakness,why do we hire you, what are your hobbies
Add your answer

Q1. What is QAP &ITP
Ans. 
QAP stands for Quality Assurance Plan and ITP stands for Inspection and Test Plan.
• QAP outlines the quality control procedures and processes to be followed during a project.

• ITP details the specific inspections and tests that will be conducted to ensure quality standards are met.

• Both documents are essential for ensuring quality and compliance in projects.
Answered by AI
Add your answer
Q2. How total station work
Ans. 
Total stations are electronic/optical instruments used in surveying and construction to measure angles and distances.
• Total stations combine a theodolite for measuring angles with a distance meter to calculate distances.

• They use a laser beam to measure distances to objects.

• Total stations are commonly used in construction, civil engineering, and land surveying.

• They provide accurate measurements for mapping, setting out b...read more
Answered by AI
Add your answer
Q3. Why soil compactionis done
Ans. 
Soil compaction is done to increase soil density, improve load-bearing capacity, reduce water infiltration, and enhance root growth.
• Increase soil density to improve stability and reduce settling

• Improve load-bearing capacity for construction projects

• Reduce water infiltration to prevent erosion and improve drainage

• Enhance root growth by providing a stable environment for plants

• Common methods include using heavy machinery
Answered by AI
Add your answer
Q4. Why HDPE liner used
Ans. 
HDPE liner is used for its durability, chemical resistance, and flexibility in various applications.
• HDPE liner is chosen for its high durability, able to withstand harsh environmental conditions.

• It is chemically resistant, making it ideal for use in containment systems for hazardous materials.

• HDPE liner is flexible, allowing it to conform to the shape of the surface it is being applied to.

• Common applications include la...read more
Answered by AI
Add your answer
Q5. How FDD test carried out
Ans. 
FDD tests are carried out by following a structured approach to identify defects in software development.
• FDD tests involve creating test cases based on functional requirements

• Tests are executed to verify if the software functions as expected

• Defects found during testing are logged and prioritized for resolution

• Regression testing is performed to ensure that fixes do not introduce new issues
Answered by AI
Add your answer

General knowledge in ms word and Excel testing

Q1. Comfortable with rotational shifts
Add your answer
Q2. Introduce yourself
Add your answer

Q1. Some resume based questions( on projects and related technologies you've mentioned)
Add your answer
Q2. What is primary key and diff between primary key and unique?
Add your answer
Q3. How many types of joins are there? and asked to write a sql query based on joins.
Add your answer
Q4. What are get and put api calls?
Add your answer
Q5. Mention your current role.
Add your answer
Q6. How many null values a unique key can have?
Add your answer
Q7. What is cascade in sql and why we use it?
Add your answer
Q8. How to display last row in database?
Add your answer
Q9. SQL Query- Two tables employee and salary are given . Take out all the employees who are getting salary between 10K and 30K.
Add your answer

Q1. Intro and some questions from intro itself.
Add your answer
Q2. HTML, It's structure,class, id, tags, attributes, whitespace, entities in html, limitations of html(everything about html)
Add your answer
Q3. Can we create a web page within a web page?
Add your answer
Q4. What do you know about Epsilon?
Add your answer

Q1. Skill Based Questions
Add your answer
Q2. Why you are interested in Joining Kroll.
Ans. 
I am interested in joining Kroll because of their reputation for excellence in the industry and the opportunity to work on challenging projects.
• Kroll has a strong reputation for excellence in the industry

• I am excited about the opportunity to work on challenging projects at Kroll

• I believe Kroll's values align with my own professional goals
Answered by AI
Add your answer

Q1. Lean Six Sigma Questions
Add your answer
Q2. Scenario Based Questions
Add your answer

Q1. Are you planning pregnancy?
Ans. 
It is not appropriate to ask about pregnancy in a job interview as it is a personal matter.
• Politely redirect the conversation back to your qualifications and experience

• Explain that personal matters such as family planning are not relevant to the job

• Express that you are focused on your career and committed to your work
Answered by AI
Add your answer
Q2. Are you comfortable working late nights?
Add your answer