Autocoder

Birlasoft Interview Questions for Freshers

Last updated 2026-11-19

Birlasoft is an enterprise technology services company, and fresher interviews often include database depth alongside programming basics and an ERP flavour for some roles. These twelve worked practice questions cover SQL and PL/SQL, Java, Python, operating systems, networking and HR.

For general preparation read how to crack the technical interview; for coding practice see Birlasoft coding round questions.

RoundsNot published; test plus technical and HR commonly reported
Typical focusSQL/PL-SQL, Java or Python, ERP concepts
CareersCompany's own careers site

Birlasoft rounds as commonly reported

Birlasoft's fresher process is not described in a source we could cite, so this section is general: prep material for IT services drives typically describes an online test with aptitude and technical or coding questions, followed by technical and HR interviews. The technical interview commonly digs into your project and database skills, and for ERP-flavoured roles into the enterprise tool you list. Your invitation is the authority on the actual rounds.

Topics worth revising

Hiring status

This page does not track Birlasoft drives or dates. For anything time-sensitive, use Birlasoft's own careers site (the careers section of birlasoft.com) and treat any date quoted on social media or listing sites as unconfirmed until it appears there.

No hiring figures are quoted on this page because there is no sourced statement to cite.

Birlasoft Interview Questions for Freshers: questions with worked answers

  1. 1

    Why Birlasoft?

    easy

    Birlasoft is an enterprise technology services company, with work commonly associated with ERP, cloud and digital engineering, so a fresher can explain interest in how large businesses run on enterprise systems. Back it up with a concrete step, such as learning SQL and PL/SQL, completing an ERP concept course or building a project with a business workflow. Keep any company facts to those on its own website.

  2. 2

    What is ERP, and what are typical ERP modules?

    easy

    Enterprise Resource Planning software integrates a company's core processes on one shared database so that departments see consistent data. Typical modules are finance and accounting, procurement, inventory and supply chain, manufacturing, sales and distribution, and human resources. Examples include SAP and Oracle products. Benefits are a single source of truth and automated workflows; drawbacks are cost, long implementations and the need for change management. Giving an order-to-cash example shows you understand the flow across modules.

  3. 3

    What is the difference between SQL and PL/SQL, and what are cursors and stored procedures?

    medium

    SQL is a declarative language for querying and changing data, one statement at a time. PL/SQL is Oracle's procedural extension: it adds variables, conditions, loops, exception handling and named blocks, so you can group many statements into procedures, functions and triggers that run inside the database, reducing network round trips. A cursor lets a program process a query result row by row; an implicit cursor is created for each DML statement and an explicit one is declared by you. Prefer set-based SQL to row-by-row cursors where possible.

  4. 4

    ROWNUM versus ROW_NUMBER in Oracle: how do you get the top three salaries?

    medium

    ROWNUM is a pseudo-column assigned as rows are returned, before ORDER BY is applied in the same query, so filtering ROWNUM directly gives the wrong rows; you must sort in a subquery first. ROW_NUMBER() is a window function that numbers rows after ordering. Newer Oracle versions also support FETCH FIRST n ROWS ONLY. For ties use DENSE_RANK.

    sql
    SELECT * FROM (
      SELECT name, salary FROM employee ORDER BY salary DESC
    ) WHERE ROWNUM <= 3;
    
    SELECT name, salary FROM employee
    ORDER BY salary DESC
    FETCH FIRST 3 ROWS ONLY;
  5. 5

    What are serialization and the transient keyword in Java?

    medium

    Serialization converts an object's state to a byte stream so it can be stored or sent, and deserialization rebuilds it. A class must implement java.io.Serializable, and should declare a serialVersionUID so compatible versions can be recognised. Fields marked transient are skipped, for example a password or a cache, and come back as default values (null, 0). Static fields are not serialised either. Prefer formats like JSON for data exchange, because Java serialization has compatibility and security pitfalls.

  6. 6

    How do hash tables handle collisions: chaining versus open addressing?

    medium

    A collision occurs when two keys map to the same bucket. Chaining stores colliding entries in a list (or tree) per bucket, which is simple and degrades gracefully; its cost is extra memory for nodes. Open addressing stores all entries in the array itself and probes for another slot (linear probing, quadratic probing or double hashing); it is cache friendly but suffers clustering and needs a lower load factor, and deletion needs tombstones. Both keep operations O(1) on average if the load factor is controlled and the hash function spreads keys well.

  7. 7

    What are the process states in an operating system, and what is a zombie process?

    medium

    A process is typically new, ready, running, waiting (blocked) and terminated. The scheduler moves it between ready and running; I/O makes it wait. A zombie is a process that has finished executing but still has an entry in the process table because its parent has not yet read its exit status with wait(); it uses almost no resources but occupies a process ID. An orphan is a process whose parent has exited and is adopted by init. Fix zombies by having the parent call wait or handle SIGCHLD.

  8. 8

    What do you look for in a code review?

    easy

    Check correctness first (edge cases, error handling, off-by-one), then tests that cover the change, readability (names, small functions), security (input validation, secrets, SQL injection), performance in obvious hot paths, and consistency with project conventions. Give feedback that is specific and kind, ask questions instead of issuing commands, and separate must-fix issues from suggestions. As a fresher, say you would also welcome reviews, since they are a fast way to learn.

  9. 9

    How do you read a file safely in Python and handle errors?

    easy

    Use a with statement so the file closes automatically even on errors: with open(path, encoding="utf-8") as f: for line in f: ... Reading line by line keeps memory low for big files. Catch specific exceptions such as FileNotFoundError and PermissionError rather than a bare except, and let unexpected ones propagate or log them with traceback. Use pathlib.Path for paths and specify the encoding explicitly, because default encodings vary between systems.

  10. 10

    What changed between HTTP/1.1 and HTTP/2?

    medium

    HTTP/1.1 sends requests over a connection one at a time, so browsers open several connections and suffer head-of-line blocking at the HTTP level. HTTP/2 uses a binary format and multiplexes many streams over one connection, compresses headers (HPACK), and allows prioritisation; server push existed but is rarely used now. HTTP/2 still runs over TCP, so a lost packet can stall all streams, a limitation HTTP/3 addresses by using QUIC over UDP. Most browsers use HTTP/2 only over TLS.

  11. 11

    Views versus materialized views.

    medium

    A view is a stored query that is run every time it is used; it holds no data, so it is always current and costs nothing in storage, and is useful for security and simplification. A materialized view stores the query result physically and must be refreshed (on demand, on commit or on schedule), so reads are fast but the data can be stale. Use materialized views for expensive aggregations in reporting, and plain views for abstraction.

  12. 12

    How do you feel about being assigned to a legacy support project instead of new development?

    easy

    Be positive and realistic: support work teaches how production systems behave, how to read unfamiliar code and how to debug under pressure, which are valuable early skills. Say you would learn the domain, document what you discover and look for automation opportunities, and that you would discuss growth paths with your manager. Do not suggest you would be unhappy or plan to leave.

Frequently asked questions

Does Birlasoft ask SAP or Oracle questions?

For ERP-related roles, prep material commonly says yes. For general development roles, focus on programming and SQL.

Is PL/SQL needed?

Only for Oracle-oriented roles, but SQL fundamentals are useful everywhere.

Does Birlasoft have a coding test?

Prep material for IT services drives commonly reports one; confirm with your invitation.

Where do I find current openings?

On Birlasoft's own careers site; this page does not track drives.

Related guides

More in Company Interview Questions

See all in this section