Filter interviews by
There are three types of commands in a database: DDL, DML, and DCL.
DDL (Data Definition Language) commands are used to define the database structure, such as creating tables, altering tables, and dropping tables.
DML (Data Manipulation Language) commands are used to manipulate data in the database, such as inserting, updating, and deleting data.
DCL (Data Control Language) commands are used to control access to the datab...
The syntax of a procedure in SQL is similar to that of a function, but it does not return a value.
CREATE PROCEDURE procedure_name
AS
BEGIN
-- SQL statements
END;
Triggers are database objects that automatically execute in response to certain events or changes in the database.
Triggers are used to enforce business rules, audit changes, and maintain data integrity.
They can be defined to execute before or after an INSERT, UPDATE, or DELETE operation.
Triggers can be used to perform complex actions such as sending emails or updating other tables.
They can be disabled or enabled as nee...
Joins are used to combine data from two or more tables based on a related column.
Types of joins include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and matching rows from the left table.
Full outer join returns all row...
SQL is a programming language used for managing and manipulating relational 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
Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE
Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.
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
Procedure is a set of SQL statements stored in the database and executed when called
Procedures can accept input parameters
Delete removes specific rows from a table, while truncate removes all rows from a table.
Delete is a DML command, while truncate is a DDL command.
Delete is slower as it logs individual row deletions, while truncate is faster as it deallocates the data pages.
Delete can be rolled back, while truncate cannot be rolled back.
Delete can have a WHERE clause to specify conditions, while truncate removes all rows without any con...
Identity property is used in SQL to automatically generate unique values for a column.
Identity property is used to create an auto-incrementing column in a table.
It is commonly used as a primary key in a table.
The identity property can be applied to numeric data types such as INT, BIGINT, etc.
The identity value starts from a seed value and increments by a specified increment value.
Example: CREATE TABLE Employees (ID INT
Synonyms are database objects that allow users to create aliases for other database objects.
Synonyms can be used to simplify complex queries by providing a shorter name for a table or view.
They can also be used to provide a layer of abstraction between the user and the underlying database objects.
Synonyms can be created for tables, views, stored procedures, and other database objects.
They can be used to reference objec...
An index is a database object that improves the speed of data retrieval operations on a table.
Indexes are used to quickly locate data without having to search every row in a table.
They are created on one or more columns of a table.
Indexes can be clustered or non-clustered.
Clustered indexes determine the physical order of data in a table.
Non-clustered indexes are separate structures that contain a copy of the indexed co...
Temporary tables are stored in tempdb while table variables are stored in memory.
Temporary tables are created using CREATE TABLE statement while table variables are declared using DECLARE statement.
Temporary tables can be accessed across sessions while table variables are limited to the scope of the batch, stored procedure or function.
Temporary tables can have indexes and constraints while table variables cannot.
Tempor...
Synonyms are alternate names for database objects. They are used to simplify queries and provide security.
Synonyms are used to provide an alternate name for a database object such as a table, view, stored procedure, or function.
They can simplify queries by providing a shorter or more meaningful name for an object.
Synonyms can also be used to provide security by allowing users to access an object without knowing its act...
To reverse a list in Python, you can use the built-in reverse() method or slicing technique.
Use the reverse() method to reverse the list in place: list.reverse()
Use slicing to create a new reversed list: reversed_list = list[::-1]
The reverse method() is used to reverse the order of elements in an array.
Use the reverse() method on an array to reverse the order of its elements.
Example: $arr = [1, 2, 3]; reverse($arr); // Output: [3, 2, 1]
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
posted on 6 Nov 2024
posted on 15 Sep 2024
I applied via campus placement at Graphic Era University, Dehradun and was interviewed in Aug 2024. There were 2 interview rounds.
1st round was aptitude round average level of question
2nd round was coding round and the level of question were easy to hard
I applied via Referral and was interviewed before Nov 2023. There were 2 interview rounds.
All Basic Questions Related To Dsa
In the next 5 years, I see myself growing into a senior software developer role, leading projects and mentoring junior developers.
Continuing to learn new technologies and programming languages to stay current in the industry
Taking on more responsibilities in project management and leading development teams
Mentoring junior developers and sharing my knowledge and experience with them
Working towards becoming a subject mat...
I applied via Referral and was interviewed in Feb 2023. There was 1 interview round.
I am a front end developer with 5 years of experience in creating user-friendly and visually appealing websites.
5 years of experience in front end development
Proficient in HTML, CSS, and JavaScript
Strong understanding of responsive design principles
Experience with front end frameworks like React and Angular
Ability to collaborate with designers and backend developers to implement website features
Portfolio showcasing pre
I want to join Webdew because of their reputation for innovative web development and their focus on creating user-friendly experiences.
Webdew has a strong track record of delivering cutting-edge web development projects.
I am impressed by their portfolio of user-friendly websites and applications.
I believe joining Webdew will provide me with opportunities to learn and grow as a front-end developer.
Their company culture ...
As a front end developer, my day-to-day responsibilities at my last job included designing and developing user interfaces, collaborating with the design team, and ensuring cross-browser compatibility.
Designing and developing user interfaces
Collaborating with the design team
Ensuring cross-browser compatibility
I applied via Approached by Company and was interviewed in Feb 2022. There was 1 interview round.
Hooks in WordPress are functions that allow developers to modify the behavior of WordPress core, themes, and plugins.
There are two types of hooks: action hooks and filter hooks.
Action hooks allow developers to execute code at specific points in the WordPress core, themes, and plugins.
Filter hooks allow developers to modify data before it is displayed to the user.
Examples of hooks include 'wp_head', 'wp_footer', and 'th
I will immediately take the website offline and assess the damage. Then I will work on fixing the vulnerabilities and restoring the website.
Take the website offline
Assess the damage
Identify the vulnerabilities
Fix the vulnerabilities
Restore the website
Implement security measures to prevent future attacks
based on 2 reviews
Rating in categories
Software Developer
43
salaries
| ₹2.5 L/yr - ₹5.4 L/yr |
Junior Software Developer
15
salaries
| ₹1.9 L/yr - ₹4 L/yr |
Software Tester
14
salaries
| ₹2.6 L/yr - ₹4.6 L/yr |
Senior Software Developer
7
salaries
| ₹6.3 L/yr - ₹9.6 L/yr |
Softwaretest Engineer
6
salaries
| ₹3 L/yr - ₹8 L/yr |
Marpu Foundation
Huawei Technologies
HCL Infosystems
Exotic Learning