Indus Net Technologies
10+ IIPTA Interview Questions and Answers
Q1. What is the difference between views and temp table?
Views are virtual tables generated from a query, while temp tables are physical tables stored in tempdb for temporary use.
Views are saved queries that act as virtual tables, while temp tables are physical tables stored in tempdb.
Views are not stored physically on disk, while temp tables are stored in tempdb.
Views are used for simplifying complex queries and providing security, while temp tables are used for storing temporary data during a session.
Views can be used for data ma...read more
Q2. How to delete duplicate records from sql.
Use a SQL query with a GROUP BY clause to delete duplicate records.
Use a SELECT statement with a GROUP BY clause to identify the duplicate records.
Use the DELETE statement with a subquery to delete the duplicate records.
Make sure to keep the record with the lowest ID or timestamp if needed.
Q3. Html page starts with which tag?
Html page starts with the <html> tag.
Html page starts with the <html> tag.
The <html> tag defines the root of an HTML document.
All other HTML elements must be nested inside the <html> tag.
Q4. What's charecteristics of oops?
Characteristics of OOP include encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Inheritance: Ability to create new classes based on existing classes.
Polymorphism: Ability to use a single interface for different data types or classes.
Abstraction: Hiding the implementation details and showing only the necessary features.
Q5. How many types of join?
There are four types of joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN: Returns rows when there is at least one match in both tables.
LEFT JOIN: Returns all rows from the left table, and the matched rows from the right table.
RIGHT JOIN: Returns all rows from the right table, and the matched rows from the left table.
FULL JOIN: Returns rows when there is a match in one of the tables.
Q6. Diffrence between dynamic and object?
Dynamic refers to runtime behavior while object refers to a specific instance of a class.
Dynamic behavior is determined at runtime, while objects are instances of classes
Dynamic programming languages allow for dynamic behavior, while objects are static entities
Examples: In Python, dynamic behavior can be seen with dynamic typing, while objects are created using classes and instantiated as objects
Q7. What is finilize and compose.
finalize and compose are methods used in software development to manage resources and create complex objects.
finalize is a method in Java used for cleanup operations before an object is garbage collected
compose is a design pattern where objects are combined to create a more complex object
finalize is discouraged to be used in modern Java due to unpredictability
Q8. What is indexs?
Indexes are data structures that improve the speed of data retrieval operations in databases.
Indexes are used to quickly locate data without having to search every row in a database table.
They are created on columns in a database table to speed up the data retrieval process.
Examples of indexes include primary keys, unique keys, and non-unique keys.
Q9. What is join in sql?
Join in SQL is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Q10. Project work- Libraries used
I have experience using various libraries such as React, Redux, and Express in my project work.
React
Redux
Express
Interview Process at IIPTA
Top Software Engineer 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.
