Filter interviews by
I applied via Recruitment Consultant and was interviewed before Oct 2019. There were 4 interview rounds.
EXIST checks for the existence of a value in a subquery, while IN checks for the existence of a value in a list.
EXIST is used with a subquery, while IN is used with a list of values.
EXIST returns true if the subquery returns any rows, while IN returns true if the value is found in the list.
EXIST is more efficient for large datasets, while IN is more efficient for small datasets.
Example: SELECT * FROM table1 WHERE colum...
INDEX and PARTITION are database optimization techniques that improve query performance.
INDEX is a data structure that improves the speed of data retrieval operations on a database table.
PARTITION is a technique that divides a large table into smaller, more manageable parts.
INDEX and PARTITION can be used together to further improve query performance.
Examples of INDEX include B-tree, hash, and bitmap indexes.
Examples o...
Removing duplicates using analytical functions in SQL
Use the ROW_NUMBER() function to assign a unique number to each row
Partition the data by the columns that define duplicates
Order the data by the same columns
Filter out rows with a row number greater than 1
Oracle DB Architecture is a multi-layered design consisting of physical, logical, and memory structures.
Physical layer includes data files, redo logs, and control files
Logical layer includes tablespaces, schema objects, and segments
Memory structures include SGA and PGA
Oracle uses a client-server architecture with a listener process
Oracle also supports RAC (Real Application Clusters) for high availability and scalabilit
ANSI JOINS are standard SQL joins while Oracle JOINS are specific to Oracle database.
ANSI JOINS are supported by most relational databases while Oracle JOINS are specific to Oracle.
ANSI JOINS use keywords like INNER JOIN, LEFT JOIN, RIGHT JOIN, etc. while Oracle JOINS use symbols like (+) for outer joins.
ANSI JOINS are more portable and easier to migrate to other databases while Oracle JOINS are more efficient in Oracl...
I applied via Referral and was interviewed before Jun 2020. There were 3 interview rounds.
Created a shell script automation to automate data backup process.
Wrote a shell script that uses the 'rsync' command to copy files from source to destination.
Implemented a cron job to schedule the script to run at specific intervals.
Included error handling and logging mechanisms to track any failures or issues.
Used variables and parameters to make the script flexible and reusable.
Added email notifications to inform the
Interview questions for Application Engineer role covering various topics.
Subset sum variant - finding a subset of numbers that add up to a given sum
Single loop missing number - finding a missing number in an array using a single loop
Difference between two dates - calculating the difference between two dates in Java
Core Java concepts - knowledge of basic Java concepts such as inheritance, polymorphism, etc.
SQL - knowle...
I applied via Company Website and was interviewed in May 2021. There were 4 interview rounds.
I was interviewed before Nov 2023.
Aptitude questions along with coding questions
I applied via Campus Placement and was interviewed before Mar 2023. There were 2 interview rounds.
Cake cutting question based on the maths
To multiply two strings, convert them to integers, multiply them, and convert the result back to a string.
Convert the strings to integers using parseInt()
Multiply the integers together
Convert the result back to a string using toString()
Design a URL shortener service
Generate a unique short code for each long URL
Store the mapping of short code to long URL in a database
Redirect users from short URL to long URL when accessed
Consider implementing custom short domains for branding
Track analytics for shortened URLs for performance monitoring
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Senior Consultant
1.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Staff Consultant
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Consultant
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Principal Consultant
702
salaries
| ₹0 L/yr - ₹0 L/yr |
Application Developer
492
salaries
| ₹0 L/yr - ₹0 L/yr |
Oracle
TCS
Infosys
Wipro