Indus Net Technologies
20+ Seckure IT Works 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. tell me the basic pillars of opps
The basic pillars of OOP are encapsulation, inheritance, and polymorphism.
Encapsulation: bundling of data and methods that operate on that data within a single unit
Inheritance: ability of a class to inherit properties and methods from a parent class
Polymorphism: ability of objects to take on multiple forms or behaviors depending on the context
Q9. 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.
Q10. 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
Q11. Why we use nosql database
NoSQL databases are used for scalability, flexibility, and handling unstructured data.
Scalability: NoSQL databases can easily scale horizontally to handle large amounts of data and high traffic.
Flexibility: NoSQL databases do not require a predefined schema, allowing for easy modifications and additions to data.
Handling unstructured data: NoSQL databases are well-suited for storing and querying unstructured data like documents, graphs, and key-value pairs.
Examples: MongoDB, C...read more
Q12. Project work- Libraries used
I have experience using various libraries such as React, Redux, and Express in my project work.
React
Redux
Express
Q13. Difference between private and protected
Private members are accessible only within the same class, while protected members are accessible within the same class and its subclasses.
Private members can only be accessed within the same class
Protected members can be accessed within the same class and its subclasses
Private members are not inherited by subclasses
Protected members are inherited by subclasses
Q14. Drupal 7 vs Drupal 8 comparison
Drupal 8 offers improved performance, better security, and more modern features compared to Drupal 7.
Drupal 8 has a more user-friendly admin interface
Drupal 8 uses Symfony components for improved performance
Drupal 8 has better multilingual support out of the box
Drupal 8 has improved content authoring capabilities with CKEditor integration
Drupal 8 has enhanced mobile responsiveness with built-in responsive themes
Q15. diffrence between jre jdk jvm
JRE is a runtime environment, JDK is a development kit, and JVM is a virtual machine.
JRE stands for Java Runtime Environment and is used to run Java applications.
JDK stands for Java Development Kit and is used to develop Java applications.
JVM stands for Java Virtual Machine and is responsible for executing Java bytecode.
JDK includes JRE and additional development tools such as compilers and debuggers.
JVM is platform-dependent and provides a layer of abstraction between Java c...read more
Q16. Removed duplicate in array
Remove duplicate strings in an array
Use a Set data structure to store unique strings
Iterate through the array and add each string to the Set
Convert the Set back to an array to get the final result
Q17. Drupal version upgradation process
Drupal version upgradation process involves backing up data, updating core files, modules, and themes, testing the site, and deploying changes.
Backup the website files and database before starting the upgrade process
Update Drupal core files to the latest version
Update all modules and themes to be compatible with the new Drupal version
Test the website thoroughly to ensure all functionalities are working correctly
Deploy the changes to the live website after successful testing
Q18. Drupal views concept using context filter & aggregation
Drupal views allow for filtering and aggregating content based on context filters.
Context filters allow you to filter content based on contextual information, such as the current user or page being viewed.
Aggregation allows you to group and summarize content based on certain criteria, such as counting the number of items in a category.
Combining context filters and aggregation can provide powerful ways to display and analyze content in Drupal views.
Q19. What chart to use to show year-wise trend?
Use a line chart to show year-wise trend.
Line chart is the best option to show year-wise trend.
It helps to visualize the trend over time.
X-axis represents the year and Y-axis represents the data points.
Multiple lines can be used to compare trends.
Example: Line chart showing the sales trend of a company from 2015 to 2020.
Q20. Find unique value
Find the unique value in an array of strings
Iterate through the array and use a hashmap to store the frequency of each element
Return the element with frequency 1 as the unique value
Q21. Steps to create custom theme in Drupal
Creating a custom theme in Drupal involves creating a new folder in the themes directory and adding necessary files.
Create a new folder in the themes directory with a unique name
Add a .info.yml file to define the theme
Create a .theme file for theme-specific functions
Add CSS and JS files for styling and functionality
Enable the custom theme in the Drupal admin interface
Q22. Create custom block in drupal
To create a custom block in Drupal, you can use the Block module or create a custom module with a block plugin.
Enable the Block module if not already enabled
Navigate to Structure > Block layout to add a new custom block
Or create a custom module with a block plugin to define the block's content and settings
Q23. Name the Scrum pillars
The Scrum pillars are transparency, inspection, and adaptation.
Transparency: All aspects of the process must be visible to those responsible for the outcome.
Inspection: Scrum artifacts and progress must be inspected frequently to detect variances.
Adaptation: If an inspection reveals that one or more aspects of the process deviate outside acceptable limits, adjustments must be made.
Q24. Explain about BRD
BRD stands for Business Requirements Document, a formal document that outlines the business requirements for a project.
BRD is a key document in the project management process, detailing what the business needs in order to achieve its goals.
It includes information on the scope of the project, objectives, stakeholders, functional requirements, non-functional requirements, and constraints.
BRD serves as a communication tool between the business stakeholders and the project team, ...read more
Top HR Questions asked in Seckure IT Works
Interview Process at Seckure IT Works
Top 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.
