i
Oracle
Filter interviews by
I applied via Referral and was interviewed in May 2024. There was 1 interview round.
Sql coding challenge
Oracle interview questions for designations
Top trending discussions
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by eliminating duplicate data
Normalization ensures data integrity by enforcing relationships between tables
There are different normal forms such as 1NF, 2NF, 3NF, and BCNF
Indexing is a technique used to improve the performance of database queries by creating a data structure that allows for faster retrieval of data.
Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.
They work similar to an index in a book, allowing the database to quickly locate the rows that satisfy a query.
Examples of indexes include primary keys, unique
Stored procedures are used to store SQL queries for reuse. Cursors are used to iterate through a result set. Joins combine data from multiple tables. CTEs are temporary result sets.
Stored procedures are used to store SQL queries for reuse
Cursors are used to iterate through a result set
Joins combine data from multiple tables
Common Table Expressions (CTEs) are temporary result sets
posted on 30 Jul 2023
I applied via Referral and was interviewed before Jul 2022. There were 3 interview rounds.
Quant and verbal related questions
A VIEW in SQL is a virtual table created by a query. It does not store data itself but displays data from one or more tables.
Views are used to simplify complex queries by storing them as a virtual table.
They can be used to restrict access to specific columns or rows of a table.
Views can also be used to join multiple tables and present the data in a more readable format.
Changes made to the underlying tables are reflecte...
I applied via Naukri.com and was interviewed in Oct 2021. There were 5 interview rounds.
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
2.4k
salaries
| ₹10.2 L/yr - ₹40 L/yr |
Senior Consultant
2.1k
salaries
| ₹9 L/yr - ₹24.6 L/yr |
Principal Consultant
2k
salaries
| ₹10.9 L/yr - ₹36 L/yr |
Senior Member of Technical Staff
1.8k
salaries
| ₹12 L/yr - ₹45 L/yr |
Senior Application Engineer
1.5k
salaries
| ₹9.5 L/yr - ₹30 L/yr |
SAP
MongoDB
Salesforce
IBM