Oracle Associate Technical Consultant Interview Questions and Answers

To determine if a point is inside a polygon, use the ray casting algorithm.

• Create a line from the point to a point outside the polygon

• Count the number of times the line intersects with the polygon edges

• If the count is odd, the point is inside the polygon; otherwise, it is outside

The four storage classes in C are auto, register, static, and extern.

• Auto: default storage class for all local variables

• Register: used to define local variables that should be stored in a register instead of RAM

• Static: used to define local variables that retain their value between function calls

• Extern: used to declare a global variable that is defined in another file

i is stored in global data segment, j is stored in stack, k is stored in heap.

• i is a global variable and is stored in the global data segment

• j is a local variable and is stored in the stack

• k is a pointer variable and is stored in the stack, while the memory it points to is allocated on the heap using malloc()

Use a hash table to store the words and check for existence in constant time.

• Create a hash table with the words as keys and a boolean value as the value.

• For each new word, check if it exists in the hash table. If it does, it has appeared before. If not, add it to the hash table.

• Alternatively, use a set data structure to store only the unique words and check for existence in the set.

Return all root to leaf node paths in a binary tree with row, col and value.

• Traverse the binary tree recursively and keep track of the current path.

• When a leaf node is reached, add the path to the result array.

• Include row, col and value of each node in the path.

• Use an array of strings to store the paths.

To get max value from a stack in O(1), maintain a separate stack to keep track of maximum values.

• Create a separate stack to keep track of maximum values

• Push the maximum value onto the stack whenever a new maximum is encountered

• Pop the maximum value stack whenever the top element of the main stack is popped

• Return the top element of the maximum value stack to get the maximum value in O(1)

To get max element from a queue in O(1) time complexity

• Maintain a separate variable to keep track of the maximum element in the queue

• Update the maximum element variable whenever a new element is added or removed from the queue

• Return the maximum element variable when getMax() function is called

Find the Next Greatest Element to the right for each element in an array of strings.

• Iterate through the array from right to left

• Use a stack to keep track of elements

• Pop elements from stack until a greater element is found

• If no greater element is found, assign -1

• Return the result array

To remove unnecessary parenthesis from an expression, we need to apply a set of rules to identify and eliminate them.

• Identify and remove parenthesis around single variables or constants

• Identify and remove parenthesis around expressions with only one operator

• Identify and remove parenthesis around expressions with operators of equal precedence

• Identify and remove parenthesis around expressions with operators of different ...read more

Find the maximum product of three integers in an array.

• Sort the array in descending order.

• Check the product of the first three numbers and the product of the first and last two numbers.

• Return the maximum of the two products.

Find length of longest consecutive sub array forming an AP from given array of integers.

• Sort the array in ascending order

• Iterate through the array and find the longest consecutive sub array forming an AP

• Use a variable to keep track of the length of the current consecutive sub array forming an AP

• Use another variable to keep track of the length of the longest consecutive sub array forming an AP seen so far

Operating on images in parallel involves dividing the image into smaller parts and processing them simultaneously.

• Divide the image into smaller parts using techniques like tiling or splitting

• Use parallel processing techniques like multi-threading or GPU acceleration

• Combine the processed parts to form the final image

• Examples: image segmentation, object detection, image enhancement

Hardware engines support parallelism through multiple cores and threads.

• Hardware engines can have multiple cores and threads to execute tasks simultaneously.

• Parallelism can improve performance and efficiency in hardware-based tasks.

• Examples include GPUs, FPGAs, and ASICs that have parallel processing capabilities.

• Hardware parallelism can also be achieved through distributed computing and clustering.

• Programming language...read more

Modern OSes support parallelism through multi-core processors and threading.

• Modern OSes like Windows, macOS, and Linux support parallelism through multi-core processors and threading.

• Parallelism can be achieved through processes or threads.

• Parallelism can improve performance and efficiency of software.

• Examples of parallel programming frameworks include OpenMP and MPI.

Memory protection is a feature of an operating system that prevents unauthorized access to memory locations.

• Memory protection is achieved through the use of memory management units (MMUs) and virtual memory.

• MMUs map virtual addresses to physical addresses and enforce access permissions.

• Virtual memory allows the OS to allocate memory to processes in a way that isolates them from each other.

• Examples of memory protection ...read more

To speed up multiplication of small integers in an array, we can use bitwise operations and parallel processing.

• Use bitwise operations like shifting and ANDing to perform multiplication faster.

• Divide the array into smaller chunks and perform multiplication in parallel using multi-threading or SIMD instructions.

• Use lookup tables for frequently used values to avoid repeated calculations.

• Use compiler optimizations like lo...read more

Design a data structure for excel spreadsheet

• Use a 2D array to store cell values

• Implement formulas using a stack

• Include formatting options for cells

A friend function is a non-member function that has access to the private and protected members of a class.

• Declared inside the class but defined outside the class scope

• Can access private and protected members of the class

• Not a member of the class but has access to its private members

• Used to allow external functions to access and modify private data of a class

• Can be declared as a friend in another class

atoi function converts a string to an integer in C.

• The function takes a string as input and returns an integer.

• Leading white spaces are ignored.

• If the string contains non-numeric characters, the function stops conversion and returns the converted value.

• The function returns 0 if the input string is not a valid integer.

• Example: atoi('123') returns 123.

A program to print star pattern

• Use nested loops to print the pattern

• The outer loop controls the number of rows

• The inner loop controls the number of stars to be printed in each row

• Use print() or println() function to print the stars

Run time polymorphism is the ability of a program to determine the object type at runtime and call the appropriate method.

• It is achieved through virtual functions and dynamic binding.

• Allows for more flexible and extensible code.

• Example: a base class Animal with virtual function makeSound() and derived classes Dog and Cat that override makeSound().

• At runtime, if an Animal pointer points to a Dog object, calling makeSoun

Right outer join is a type of join operation that returns all the rows from the right table and the matching rows from the left table.

• Right outer join is denoted by the RIGHT JOIN keyword in SQL.

• It is used to combine rows from two tables based on a related column.

• In the result set, unmatched rows from the right table will have NULL values for the columns of the left table.

• A real-world scenario for using a right outer j...read more

Refrential integrity ensures that relationships between tables in a database remain consistent.

• It is a database concept that ensures that foreign key values in one table match the primary key values in another table.

• It prevents orphaned records in a database.

• It maintains data consistency and accuracy.

• For example, if a customer record is deleted, all related orders for that customer should also be deleted.

• It is enforced...read more

Primary key uniquely identifies a record in a table, while Unique key ensures uniqueness of a column.

• Primary key can't have null values, Unique key can have one null value

• A table can have only one Primary key, but multiple Unique keys

• Primary key is automatically indexed, Unique key is not necessarily indexed

Triggers are database objects that are automatically executed in response to certain events.

• Triggers can be used to enforce business rules, audit changes, or replicate data.

• There are two types of triggers: DML triggers and DDL triggers.

• DML triggers are fired in response to DML statements (INSERT, UPDATE, DELETE).

• DDL triggers are fired in response to DDL statements (CREATE, ALTER, DROP).

Swapping two character variables without using third

• Use XOR operator to swap two variables without using third variable

• Assign the XOR of both variables to the first variable

• Assign the XOR of the first variable and second variable to the second variable

I have been actively involved in various extra curricular activities such as volunteering, sports, and leadership roles.

• Volunteered at local animal shelter every weekend

• Captain of the soccer team in high school

• Organized charity events for underprivileged children