Weber Shandwick Interview Questions and Answers

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

NDT methods include ultrasonic testing, radiographic testing, magnetic particle testing, liquid penetrant testing, and visual testing.

• Ultrasonic testing uses high-frequency sound waves to detect flaws or measure material thickness.

• Radiographic testing involves the use of X-rays or gamma rays to inspect the internal structure of a component.

• Magnetic particle testing is used to detect surface and near-surface flaws in fe...read more

Soil testing procedures involve collecting samples, analyzing them for nutrients and pH levels, and interpreting the results.

• Collect soil samples from different areas of the field

• Air dry the samples before sending them to a lab for analysis

• Test for nutrients like nitrogen, phosphorus, and potassium

• Measure pH levels to determine soil acidity or alkalinity

• Interpret the results to make recommendations for fertilizers or s

My current Cost to Company (CTC) is $80,000 per annum, including a 10% variable component.

• My current CTC is $80,000 per annum

• Includes a 10% variable component

• Variable component is based on performance and sales targets

Lower middle class people can be supported for rework optical by providing affordable options, flexible payment plans, and access to subsidies or financial assistance.

• Offering affordable pricing for rework optical services

• Providing flexible payment plans to accommodate lower middle class budgets

• Offering subsidies or financial assistance programs for those who qualify

• Partnering with government or non-profit organization...read more

A job is a paid position of regular employment that one undertakes to earn a living.

• A job involves performing specific tasks or duties in exchange for compensation

• It provides financial stability and allows individuals to support themselves and their families

• Jobs can be full-time, part-time, temporary, or permanent

• Some examples of jobs in the electronics engineering field include designing circuits, troubleshooting elec