10+ eClerx Interview Questions and Answers

Buffer cache stores frequently accessed data in memory. Old archive logs can be deleted using RMAN commands.

• Buffer cache is a portion of memory used to store frequently accessed data to reduce disk I/O

• Oracle automatically manages the buffer cache size based on system resources and workload

• To delete old archive logs in RMAN, use the DELETE ARCHIVELOG command with options like 'ALL' or 'COMPLETED BEFORE'

• Example: DELETE ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE DISK;

• Exampl...read more

SGA is a shared memory area that stores data and control information for Oracle instance. Shared pool is a part of SGA that stores SQL statements and data dictionary cache.

• SGA is a fixed size memory area allocated at instance startup

• SGA contains database buffer cache, redo log buffer, shared pool, etc.

• Shared pool stores frequently used SQL statements and data dictionary cache

• Shared pool can be resized dynamically using ALTER SYSTEM command

LNS stands for Log Network Server, responsible for transmitting redo data from the primary database to standby databases. MRP is Managed Recovery Process, used to apply redo data to standby databases.

• LNS is responsible for transmitting redo data from primary to standby databases

• MRP is used to apply redo data to standby databases for data recovery

• LNS and MRP are essential components of Oracle Data Guard for ensuring data protection and availability

Onion architecture is a software architectural pattern that promotes separation of concerns by organizing code into layers.

• Consists of multiple layers: Presentation, Application, Domain, and Infrastructure

• Each layer has specific responsibilities and dependencies flow inward

• Domain layer contains business logic, Application layer contains use cases, Infrastructure layer contains external concerns

• Promotes testability, maintainability, and flexibility in software design

Exception handling is the process of responding to and managing errors in a program.

• It involves anticipating possible errors and writing code to handle them gracefully

• Common techniques include try-catch blocks, throwing exceptions, and using finally blocks

• Exception handling helps improve the reliability and robustness of a program

Duplicate data can be deleted by using SQL queries with the DISTINCT keyword or by writing a script to identify and remove duplicates.

• Use SQL queries with the DISTINCT keyword to select unique records and insert them into a new table.

• Write a script to iterate through the data, identify duplicates based on specific criteria, and delete them.

• Utilize built-in functions or libraries in programming languages like Python or Java to remove duplicate entries.

MVC filter is a feature in ASP.NET MVC framework that allows you to execute logic before or after an action method is called.

• MVC filters can be used for authorization, logging, exception handling, etc.

• There are different types of filters in MVC like Authorization filters, Action filters, Result filters, and Exception filters.

• Example: [Authorize] attribute is a type of Authorization filter that restricts access to a controller or action method based on user authentication.

Path Infotech is a global IT services company providing software solutions and services to clients worldwide.

• Path Infotech offers a wide range of IT services including software development, testing, and support.

• The company has a global presence with offices in multiple countries.

• Path Infotech has a strong focus on delivering innovative and cost-effective solutions to its clients.

• Some of the industries served by Path Infotech include healthcare, finance, and retail.

• The company...read more

Servitium is a Latin term meaning 'service' or 'slavery' and is often used in the context of feudal relationships.

• Servitium refers to the obligations and duties owed by a vassal to a lord in exchange for land or protection.

• It can also refer to the services or duties owed by a serf to a lord in a feudal system.

• Servitium was a key aspect of the feudal system in medieval Europe, where land was granted in exchange for loyalty and service.

An abstract class can have both abstract and non-abstract methods, while an interface can only have abstract methods.

• An abstract class can have constructors, while an interface cannot.

• A class can implement multiple interfaces, but can only inherit from one abstract class.

• An abstract class can have instance variables, while an interface cannot.

• An abstract class can provide default implementations for some methods, while an interface cannot.

• An abstract class is used when a comm...read more

Key differences between SQL, function and stored procedure

• SQL is used to query and manipulate data in a database

• Functions are reusable code blocks that return a single value

• Stored procedures are reusable code blocks that can execute multiple SQL statements

• Functions can be called from SQL statements, while stored procedures are called using a specific syntax

• Stored procedures can also have input and output parameters

Function to reverse an array of strings

• Create a function that takes an array of strings as input

• Use a loop to iterate through the array and reverse each string

• Return the reversed array of strings