Filter interviews by
Chemical questions, structure, definition
Top trending discussions
I applied via Approached by Company and was interviewed before Jun 2021. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.
Calculation and Logics
Alter command on table affects views created on the table.
Views are virtual tables created from one or more tables.
Alter command on a table can change the structure of the table, which can affect the views created on it.
If the columns used in the view are altered or dropped, the view will become invalid.
If the data in the table is changed, the data in the view will also change accordingly.
Data transformations in SSIS include Lookup which retrieves data from a source based on a matching condition.
Lookup is used to retrieve data from a source based on a matching condition
It can be used to perform joins between two data sources
Lookup can be used to update or insert data into a destination based on a match
Other data transformations in SSIS include sorting, aggregating, and merging data
Drop deletes the table structure and data, truncate deletes only data, and delete deletes specific rows.
Drop: removes the table and all its data permanently
Truncate: removes all data from the table but keeps the structure
Delete: removes specific rows from the table based on a condition
Drop and truncate cannot be rolled back, but delete can be
Drop and truncate reset the identity of the table, but delete does not
Truncate resets identity value, delete does not.
Truncate resets the identity value to the original seed value
Delete does not change the identity value
Example: Truncate table resets identity value to 1
Example: Delete from table does not change identity value
Joins are used to combine data from two or more tables based on a related column. Types include inner, outer, left, right, and cross join.
Inner join returns only the matching rows from both tables.
Outer join returns all rows from both tables, with null values for non-matching rows.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and m...
Query to join employees who are all managers using id in the table.
Use self join to join the table on manager id and employee id
Filter the result to only include employees who are also managers
Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.id = e2.manager_id WHERE e2.manager_id IS NOT NULL
Ensure that the table has a manager_id column
I was interviewed before Feb 2024.
Preventive maintenance is the practice of regularly inspecting, cleaning, and servicing equipment to prevent breakdowns and prolong its lifespan.
Regularly inspecting equipment for signs of wear and tear
Cleaning and lubricating moving parts
Replacing worn out parts before they fail
Scheduling routine maintenance tasks based on manufacturer recommendations
Examples: changing the oil in a car every 5,000 miles, cleaning the
Preventive maintenance is the practice of regularly inspecting, cleaning, and servicing equipment to prevent breakdowns and prolong its lifespan.
Regularly inspecting equipment for signs of wear and tear
Cleaning and lubricating machinery to prevent corrosion and friction
Replacing worn out parts before they fail
Scheduling routine maintenance tasks based on manufacturer recommendations
Examples: changing oil in a car, clea
Depend upon role and designation assignment will be given
I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.
ADR stands for Alternative Dispute Resolution. It is a process of resolving disputes outside of the court system.
ADR includes methods such as mediation, arbitration, and negotiation.
It is often used as a quicker and less expensive alternative to traditional litigation.
ADR can be voluntary or mandatory, depending on the situation.
Examples of ADR include settling a divorce through mediation, resolving a business dispute ...
Valid case criteria
The case must have a clear and specific problem or issue
The case must have relevant and reliable data or information
The case must have a logical and coherent structure
The case must have realistic and feasible solutions
The case must have potential for learning and application
The case must have ethical and legal considerations
The case must have appropriate scope and complexity
Causality refers to the relationship between an event (the cause) and a second event (the effect), where the second event is a result of the first.
Causality is the principle that everything has a cause and effect.
It is the relationship between an action and its consequences.
For example, smoking causes lung cancer.
Causality is important in scientific research to establish cause-and-effect relationships.
It is also import...
posted on 10 Jul 2017
I was interviewed before Jul 2016.
I applied via Campus Placement and was interviewed before Apr 2021. There were 3 interview rounds.
All question base on the technical ....
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Officer
186
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Officer
136
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive
72
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
66
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Executive
59
salaries
| ₹0 L/yr - ₹0 L/yr |
Sun Pharmaceutical Industries
DRJ & CO
Biocon Limited
Piramal Group