Sterlite Industries Interview Questions, Process, and Tips

SQL is a programming language used for managing and manipulating databases.

• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• Example: SELECT * FROM customers WHERE city = 'New York'

Oops concepts are fundamental principles of object-oriented programming. Real life example: Car is an object with properties and behaviors.

• Encapsulation: Car object with private properties like engine size and public methods like start()

• Inheritance: Sedan and SUV classes inheriting from Car class

• Polymorphism: Overloading the drive() method in Sedan and SUV classes

• Abstraction: Using Car object without knowing its intern

DDL stands for Data Definition Language in SQL, used to define and modify the structure of database objects.

• DDL statements include CREATE, ALTER, DROP, TRUNCATE, and RENAME.

• CREATE is used to create new database objects like tables, views, indexes, etc.

• ALTER is used to modify existing database objects.

• DROP is used to delete database objects.

• TRUNCATE is used to remove all records from a table.

• RENAME is used to rename dat

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.

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

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

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

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