i
Oracle
Filter interviews by
I applied via Referral and was interviewed before Feb 2023. There were 3 interview rounds.
The parsing of a SELECT statement in Oracle database involves several steps.
The statement is first checked for syntax errors.
The query is then parsed to identify the objects involved and their relationships.
The optimizer determines the most efficient execution plan.
The plan is executed and the result set is returned.
An insert/update statement in Oracle database is parsed by the SQL parser to check syntax and semantics.
The SQL parser first checks the syntax of the insert/update statement to ensure it follows the rules of the SQL language.
Next, the parser checks the semantics of the statement, which involves verifying the existence and accessibility of the tables and columns referenced in the statement.
During parsing, the parser als...
To access elements in XML/JSON data, use appropriate methods like XPath for XML and dot notation for JSON.
For XML data, use XPath expressions to navigate and extract specific elements or attributes.
For JSON data, use dot notation to access nested objects or arrays.
In PL/SQL, you can use XMLTable or JSON_TABLE functions to extract data from XML or JSON respectively.
Pragma objects in PL/SQL provide compiler directives for controlling program behavior.
Pragma AUTONOMOUS_TRANSACTION: Allows a subprogram to execute SQL statements independently of the calling program.
Pragma EXCEPTION_INIT: Associates an exception name with an Oracle error number.
Pragma INLINE: Suggests the compiler to inline the code of a subprogram at the call site.
Pragma RESTRICT_REFERENCES: Specifies the purity leve...
Top trending discussions
posted on 3 Jan 2025
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.
Platform Events are a feature in Salesforce that allow developers to deliver secure, scalable, and customizable event notifications.
Platform Events are based on the publish-subscribe model, where publishers send events and subscribers receive them.
They are used to communicate changes in Salesforce data or custom events within an organization.
Developers can define custom event objects and trigger events using Apex or de...
Asynchronous Apex allows you to run processes in the background, without user interaction. Batch Apex and Queueable Apex are two types of Asynchronous Apex.
Asynchronous Apex allows you to process large amounts of data asynchronously, without impacting the user interface.
Batch Apex is used to process large data sets that can be divided into smaller batches for processing.
Queueable Apex allows you to submit jobs for asyn...
Future method is used to run code asynchronously. Callout=true is needed to make HTTP callouts from future methods.
Future methods are used to run code asynchronously in Salesforce.
They are annotated with @future annotation.
Callout=true is needed to make HTTP callouts from future methods.
Without Callout=true, making HTTP callouts from future methods is not allowed.
Data security in Salesforce involves various types of security measures to protect sensitive information.
Salesforce provides various security features such as user authentication, data encryption, and access controls.
Types of data security in Salesforce include object-level security, field-level security, and record-level security.
Salesforce also offers tools like Salesforce Shield for enhanced data security and compli...
posted on 12 Nov 2024
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
posted on 27 Sep 2024
It went well. Easy questions were asked
We have to first explain how we are planning to solve the problem and can start coding
Algorithms in data structures are essential for efficient data manipulation and retrieval.
Algorithms in data structures help in organizing and managing data effectively.
Examples include sorting algorithms like quicksort and searching algorithms like binary search.
Understanding algorithms in data structures is crucial for optimizing performance in software development.
I applied via Company Website
Very difficult aptitude questions
Resources coding round
posted on 22 Mar 2024
Questions on react , majorly focus on basics
I applied via Naukri.com and was interviewed in Mar 2023. There were 3 interview rounds.
One to one interview along with coding round.
Basic questions for python based on list touple dictionary.
Numpy, Pandas, CSV and operation.
SQL queries basic like join query
Having query.
The core logic of my previous work involved developing a web application using Python and Django framework.
Developed a web application using Python and Django framework
Implemented various features and functionalities based on client requirements
Handled database operations and data manipulation using Django ORM
Worked on front-end development using HTML, CSS, and JavaScript
Collaborated with a team of developers to ensure
posted on 12 May 2024
I applied via LinkedIn and was interviewed in Nov 2023. There were 2 interview rounds.
based on 2 reviews
Rating in categories
Senior Software Engineer
2.3k
salaries
| ₹10 L/yr - ₹40 L/yr |
Senior Consultant
2.1k
salaries
| ₹9 L/yr - ₹24.4 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.4k
salaries
| ₹8.5 L/yr - ₹34 L/yr |
SAP
MongoDB
Salesforce
IBM