Filter interviews by
I applied via Campus Placement and was interviewed before Mar 2021. There was 1 interview round.
Indexing is a way to improve database performance by creating a separate data structure that allows faster data retrieval.
Clustered index: sorts and stores the data rows in the table based on their key values
Non-clustered index: creates a separate structure that includes the indexed columns and a pointer to the data row
Full-text index: enables full-text search on character-based data types
Filtered index: indexes a subs...
Query optimization techniques aim to improve the performance of database queries.
Use indexes to speed up query execution
Avoid using SELECT * and instead specify only required columns
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Use EXPLAIN to analyze query execution plan
Functions return a value while stored procedures do not.
Functions are used to perform a specific task and return a value.
Stored procedures are used to execute a set of SQL statements and do not return a value.
Functions can be used in SQL statements while stored procedures cannot.
Functions can be called from within stored procedures.
Functions are deterministic while stored procedures may not be.
Functions can be used in
Temp table and magic table are used in SQL for temporary storage and tracking changes respectively.
Temp table is used to store intermediate results during a query execution.
Magic table is used to track changes made to a table during an INSERT, UPDATE or DELETE operation.
Temp table is created using CREATE TABLE statement with # or ## prefix.
Magic table is accessed using the special INSERTED and DELETED tables.
Temp table...
Yes, we can delete records from views. Views are virtual tables that display data from one or more tables.
Views are used to simplify complex queries by providing a virtual table with a specific subset of data.
Deleting records from a view will delete the corresponding records from the underlying table(s).
Views can also be used to restrict access to sensitive data by only allowing certain columns to be displayed.
Example:...
Constraints are limitations or rules that must be followed in software development.
Data constraints: limit the type or amount of data that can be entered
Domain constraints: limit the values that can be entered
Business rules: limit the actions that can be taken
Hardware constraints: limit the hardware that can be used
Time constraints: limit the time available for development or execution
Top trending discussions
I applied via Company Website and was interviewed before Dec 2022. There were 5 interview rounds.
Debugging is the process of identifying and fixing errors or bugs in software code.
Identifying and isolating issues in the code
Using tools like breakpoints and print statements to track down bugs
Fixing errors to ensure the code runs correctly
Testing the code to verify that the bugs have been resolved
Debugging can be achieved by identifying and fixing errors in the code.
Use debugging tools like breakpoints to pause the code execution and inspect variables
Review the code logic and look for syntax errors or logical mistakes
Utilize logging to track the flow of the program and identify issues
Test the code with different inputs to reproduce and isolate the bugs
Collaborate with team members to get fresh perspectives on t
posted on 24 Jun 2024
Object Oriented Programming Concepts involve encapsulation, inheritance, and polymorphism.
Encapsulation: Bundling data and methods that operate on the data into a single unit (class). Example: class Car with properties like make, model, and methods like start(), stop().
Inheritance: Allows a class to inherit properties and methods from another class. Example: class SUV extends Car, inheriting properties and methods from...
I applied via campus placement at Sri Venkateswara College of Engineering and Technology, Chittoor and was interviewed in Feb 2024. There were 2 interview rounds.
Good computer science spectrum of questions
Binary search question, dp question and a sliding window question
posted on 24 Oct 2023
I applied via Referral and was interviewed in Apr 2023. There were 5 interview rounds.
Basic questions of javascript and php
Assignment for complete the all qus of freecodecamp
I applied via Campus Placement and was interviewed in Sep 2022. There were 4 interview rounds.
Given a pattern and we need to complete the pattern within 40mins, also allows completing this problem in any language ( c,c++, python, java).
I have a close-knit family and a supportive group of friends. I also have intermediate skills in various programming languages.
My family is very important to me and we have a strong bond.
I have a few close friends who have always been there for me.
In terms of programming, I have intermediate skills in languages like Java, Python, and JavaScript.
posted on 5 May 2024
I applied via Walk-in and was interviewed before May 2023. There were 2 interview rounds.
Get good handson for basics program of java on array, string
Overloading is having multiple methods in the same class with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
Overloading involves multiple methods with the same name but different parameters.
Overriding involves a method in a subclass with the same name and parameters as a method in the superclass.
Overloading is resolved...
posted on 1 Jul 2021
posted on 17 Oct 2021
I applied via Naukri.com and was interviewed before Oct 2020. There were 4 interview rounds.
PHP Developer
9
salaries
| ₹1.2 L/yr - ₹4.4 L/yr |
Laravel Developer
7
salaries
| ₹1.4 L/yr - ₹3.1 L/yr |
Software Developer
6
salaries
| ₹3.3 L/yr - ₹6.6 L/yr |
Business Analyst
5
salaries
| ₹2 L/yr - ₹5.4 L/yr |
UI/UX Designer
5
salaries
| ₹2 L/yr - ₹3.2 L/yr |
TCS
Infosys
Wipro
HCLTech