Thermolab Healthcare Interview Questions and Answers

DELETE removes specific rows while TRUNCATE removes all rows. DROP deletes the entire table while TRUNCATE only removes data.

• DELETE is a DML command while TRUNCATE is a DDL command.

• DELETE can be rolled back while TRUNCATE cannot be rolled back.

• DELETE is slower than TRUNCATE.

• DROP deletes the entire table and its structure while TRUNCATE only removes data.

• TRUNCATE resets the identity of the table while DELETE does not.

• Examples: DELETE FROM table_name WHERE condition; TRUNCATE T...read more

To create a list inside a list, use nested HTML

and
• tags.

  • Create an outer

    tag

    • Within the outer

      tag, create an inner
      tag

      • Within the inner

        tag, create
        • tags for each item in the sublist

        • Repeat for each sublist

        • Example:

          • Item 1
            • Subitem 1
            • Subitem 2
          • Item 2
            • Subitem 1
            • Subitem 2

Find the second highest salary from a table using SQL queries.

• Use the SELECT statement to retrieve the salaries from the table.

• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the result set to the second highest salary.

• Use a subquery to exclude the highest salary from the result set.

Singleton, Factory, and Abstract Factory are design patterns used in software development.

• Singleton pattern ensures that only one instance of a class is created and provides a global point of access to it.

• Factory pattern provides a way to create objects without exposing the creation logic to the client and refers to the newly created object through a common interface.

• Abstract Factory pattern provides an interface for creating families of related or dependent objects without s...read more

The __init__() method is a constructor method in Python that is automatically called when an object is created.

• It initializes the attributes of an object

• It takes self as the first parameter

• It can take additional parameters to initialize the object's attributes

• It can be overridden to customize object initialization

Polymorphism is the ability of an object to take on many forms. In OOPs, it allows objects of different classes to be treated as if they are the same type.

• Polymorphism allows for code reusability and flexibility

• It can be achieved through method overloading or method overriding

• Example: A parent class Animal has a method called makeSound(). Child classes Dog and Cat can override this method to make their own unique sounds.

• Polymorphism can also be achieved through interfaces, wh...read more

OOPs concepts are fundamental to object-oriented programming. They include inheritance, encapsulation, abstraction, and polymorphism.

• Inheritance allows a class to inherit properties and methods from a parent class. For example, a Car class can inherit from a Vehicle class.

• Encapsulation is the practice of hiding data and methods within a class. For example, a BankAccount class can hide the account balance from outside access.

• Abstraction is the process of simplifying complex sy...read more