Kreate Technologies
10+ Ebar Healthcare Interview Questions and Answers
Q1. What is the difference between echo and print in PHP?
Echo and print are both used to output data in PHP, but echo is slightly faster and can take multiple parameters while print can only take one.
Echo is a language construct, while print is a function.
Echo does not return a value, while print returns 1.
Echo can take multiple parameters separated by commas, while print can only take one parameter.
Echo is slightly faster than print.
Q2. How do you embed PHP code in an HTML file?
PHP code can be embedded in an HTML file using PHP opening and closing tags.
Use <?php ?> tags to enclose PHP code within an HTML file
Ensure that the file has a .php extension for the server to process PHP code
Example: <html><body><?php echo 'Hello World'; ?></body></html>
Q3. Method overloading vs overriding
Method overloading is having multiple methods in the same class with the same name but different parameters. Method overriding is redefining a method in a subclass with the same name and parameters as in the superclass.
Method overloading involves multiple methods with the same name but different parameters.
Method overriding involves redefining a method in a subclass with the same name and parameters as in the superclass.
Method overloading is determined at compile time based o...read more
Q4. Primary key vs unique key
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness but allows null values.
Primary key enforces uniqueness and not null constraint on a column
Primary key can consist of multiple columns
Unique key enforces uniqueness but allows null values
Unique key can be applied to multiple columns as well
Q5. Procedure vs function
Procedures are a set of instructions that perform a specific task, while functions return a value after performing a task.
Procedures do not return a value, while functions do.
Functions can be called within expressions, while procedures cannot.
Functions are more versatile and reusable compared to procedures.
Q6. Trigger in sql server
A trigger in SQL Server is a special type of stored procedure that automatically executes when certain events occur in a database.
Triggers can be used to enforce business rules, audit changes, or replicate data.
There are two main types of triggers in SQL Server: DML triggers and DDL triggers.
DML triggers fire in response to data manipulation language (DML) events like INSERT, UPDATE, and DELETE.
DDL triggers fire in response to data definition language (DDL) events like CREATE...read more
Q7. Abstract class vs interface
Abstract class is a class that can have both abstract and non-abstract methods, while interface is a contract that defines methods that must be implemented by a class.
Abstract class can have constructor, fields, and methods, while interface cannot have any implementation.
A class can implement multiple interfaces but can only inherit from one abstract class.
Abstract classes are used when some common functionality needs to be shared among subclasses, while interfaces are used t...read more
Q8. Explain OOPS Programming.
OOPS programming is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
OOPS stands for Object-Oriented Programming System
It focuses on creating objects that interact with each other to solve complex problems
Encapsulation, inheritance, polymorphism, and abstraction are key principles of OOPS
Example: Inheritance allows a class to inherit properties and behavior from another class
Q9. Oops Concept in c#
Oops concept in C# refers to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation hides the internal state of an object and only exposes necessary information.
Polymorphism allows objects of different classes to be treated as objects of a common superclass.
Abstraction focuses on the essential characteristics of an object while ignoring...read more
Q10. Filter and its type
A filter is a tool used to select specific data from a larger set based on certain criteria.
Filters can be used in various programming languages and databases to narrow down results.
Types of filters include text filters, numeric filters, date filters, and custom filters.
Examples of filters include WHERE clause in SQL, filter() function in Python, and filter() method in JavaScript.
Q11. View in sql server
A view in SQL Server is a virtual table that contains the result set of a SELECT statement.
Views are used to simplify complex queries by storing them as a virtual table.
Views can be used to restrict access to specific columns or rows of a table.
Views can be created using the CREATE VIEW statement.
Example: CREATE VIEW vwEmployee AS SELECT FirstName, LastName FROM Employees;
Q12. Interface in c#
Interface in C# is a reference type that defines a contract for classes to implement certain methods and properties.
Interfaces cannot have implementation, only method signatures and properties.
Classes can implement multiple interfaces in C#.
Interfaces are used to achieve abstraction and multiple inheritance in C#.
Example: public interface IShape { void Draw(); }
Example: public class Circle : IShape { public void Draw() { Console.WriteLine("Drawing a circle"); }}
Q13. Partial view in.det
Partial view in ASP.NET MVC allows reusing common UI elements across multiple views.
Partial views are like reusable components that can be included in multiple views
They help in reducing code duplication and improving maintainability
Partial views are rendered using Html.Partial or Html.RenderPartial methods
Q14. Union vs union all
Union combines and removes duplicates, while union all combines all rows including duplicates.
Union removes duplicates, while union all includes duplicates.
Union is slower as it has to remove duplicates, while union all is faster.
Use union when you want to remove duplicates, use union all when duplicates are acceptable.
Q15. Foreign key In sql
Foreign key in SQL is a field in a table that links to a primary key in another table, enforcing referential integrity.
Foreign key constraints ensure data consistency between related tables
Foreign key values must exist in the referenced table's primary key column
Foreign key can be used to establish relationships between tables
Q16. Constructor in c#
Constructor in C# is a special type of method that is automatically called when an instance of a class is created.
Constructors have the same name as the class and do not have a return type.
They can be used to initialize the data members of the class.
Constructors can be overloaded to have multiple versions with different parameters.
Example: public class Person { public Person(string name) { this.Name = name; } }
Interview Process at Ebar Healthcare
Top Software Developer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
