Filter interviews by
Clear (1)
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
To create a table using another table, use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement to create a new table based on the structure and data of an existing table.
Specify the new table name after CREATE TABLE and the existing table name after AS SELECT.
You can also add conditions or filters to the SELECT statement to customize the data being copied.
Example: CREATE TABLE new_table AS SEL
The question is asking to identify different types of joins in SQL.
Inner Join: Returns rows when there is a 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 Outer Join: Returns rows when there is a match in either table.
Cross Join: Returns the Cartesian product of
An index is a database object that improves the speed of data retrieval operations on a table.
Indexes can be created on one or more columns of a table.
Syntax to create an index: CREATE INDEX index_name ON table_name(column_name);
Indexes can be unique or non-unique.
Indexes can be used to enforce uniqueness constraints.
Indexes can improve query performance by reducing the number of rows that need to be scanned.
Use SQL query with MAX function to fetch highest salary from the database.
Use SELECT statement with MAX function to retrieve highest salary
Specify the column name for salary in the SELECT statement
Include the table name in the query if needed
Use a DELETE statement with a subquery to remove duplicates in a table.
Identify the columns that define duplicates
Use a subquery to select the rows to be deleted
Use the DELETE statement to remove the duplicates
Top trending discussions
posted on 6 Sep 2017
I was interviewed in Mar 2017.
I have worked on various projects during my time in university, including a web development project and a mobile app project.
Developed a web application using HTML, CSS, and JavaScript for a school project
Created a mobile app using React Native for a personal project
Completed courses in data structures and algorithms, as well as software engineering principles
I want to join MA because of its reputation for cutting-edge technology and collaborative work environment.
MA is known for its innovative projects and use of advanced technology.
I am impressed by the collaborative work culture at MA.
I believe joining MA will provide me with opportunities for professional growth and development.
I hope to gain practical experience in software development, expand my skills, and learn from experienced professionals.
Gain practical experience in software development
Expand my skills in coding and problem-solving
Learn from experienced professionals in the field
I was interviewed in Oct 2016.
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
Inheritance allows for code reuse and promotes modularity.
The class that is being inherited from is called the superclass or base class.
The class that inherits from the superclass is called the subclass or derived class.
The subclass can access the public and protected members of the superclass.
Inhe...
Regular expressions in PHP are powerful tools for pattern matching and manipulating strings.
Regular expressions are defined using the preg_match() function in PHP.
They are used to search, replace, and validate strings based on specific patterns.
Regex patterns consist of a combination of characters and special symbols.
Modifiers can be added to the pattern to control the matching behavior.
Common regex functions in PHP in...
Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as the same type.
Polymorphism allows a single interface to be used for different types of objects.
It enables code reusability and flexibility in object-oriented programming.
For example, a parent class 'Animal' can have multiple child classes like 'Dog', 'Cat', and 'Bird'. They can all be treated as 'Anim...
I was interviewed in Dec 2016.
Sort the individual digits of a 10 digit number.
Convert the number to a string to access individual digits
Use a sorting algorithm to sort the digits
Convert the sorted digits back to a number
The code for finding the Lowest Common Ancestor (LCA) in a Binary Search Tree (BST).
Start from the root node and compare it with the given two nodes.
If both nodes are smaller than the current node, move to the left subtree.
If both nodes are greater than the current node, move to the right subtree.
If one node is smaller and the other is greater, then the current node is the LCA.
Continue this process until the LCA is fou
A DBMS for managing college faculty, professors, courses, and students.
The DBMS should have tables for faculty, professors, courses, and students.
Each table should have appropriate attributes to store relevant information.
Relationships can be established between tables using foreign keys.
Queries can be used to retrieve information about faculty, professors, courses, and students.
The DBMS can be used to track enrollment
I was actively involved in coding competitions, hackathons, and programming clubs during college.
Participated in coding competitions such as ACM ICPC and Codeforces
Attended hackathons to work on real-world projects and improve problem-solving skills
Joined programming clubs to collaborate with peers and learn new technologies
Yes, I believe in seeking help when stuck in a problem as it leads to faster resolution and learning.
I believe in collaborating with team members to brainstorm solutions
I am not afraid to ask for help from more experienced developers
I utilize online resources like Stack Overflow or documentation when needed
Teamwork is collaborating with others towards a common goal, utilizing each member's strengths and skills.
Collaborating with others towards a common goal
Utilizing each member's strengths and skills
Communicating effectively and openly
Respecting and valuing diverse perspectives
Sharing responsibilities and supporting each other
Celebrating successes as a team
When faced with an unsolvable problem, I break it down, research, seek help, experiment, and iterate until a solution is found.
Break down the problem into smaller, manageable parts
Research and gather information related to the problem
Seek help from colleagues, online communities, or experts
Experiment with different approaches or solutions
Iterate and refine the solution based on feedback and results
In 5 years, I see myself as a senior software developer leading a team of developers on innovative projects.
Leading a team of developers on innovative projects
Senior software developer role
Continuing to learn and grow in the field
I applied via Referral
based on 1 interview
Interview experience
Software Engineer
166
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
145
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
134
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
110
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
91
salaries
| ₹0 L/yr - ₹0 L/yr |
Blue Yonder
Manhattan Associates
SAP
Oracle