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.
| Rounds | Not published; test plus technical and HR commonly reported |
|---|---|
| Typical focus | SQL/PL-SQL, Java or Python, ERP concepts |
| Careers | Company'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
- SQL and, for Oracle-based roles, PL/SQL, cursors and ranking queries.
- Core Java or Python with file and exception handling.
- Hash tables, operating system processes and HTTP basics.
- ERP vocabulary if the role mentions SAP or Oracle.
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 Why Birlasoft?
easyBirlasoft 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 What is ERP, and what are typical ERP modules?
easyEnterprise 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 What is the difference between SQL and PL/SQL, and what are cursors and stored procedures?
mediumSQL 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 ROWNUM versus ROW_NUMBER in Oracle: how do you get the top three salaries?
mediumROWNUM 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.
sqlSELECT * 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 What are serialization and the transient keyword in Java?
mediumSerialization 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 How do hash tables handle collisions: chaining versus open addressing?
mediumA 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 What are the process states in an operating system, and what is a zombie process?
mediumA 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 What do you look for in a code review?
easyCheck 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 How do you read a file safely in Python and handle errors?
easyUse 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 What changed between HTTP/1.1 and HTTP/2?
mediumHTTP/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 Views versus materialized views.
mediumA 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 How do you feel about being assigned to a legacy support project instead of new development?
easyBe 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
- BNY coding round questions with solutions
- BNY interview questions with answers (technology roles)
- Bosch Coding Round Questions with Solutions
- Bosch Interview Questions and Answers for India Engineering Roles
- BrowserStack Coding Round Questions With Solutions
- BrowserStack Interview Questions and Answers
- Cadence Coding Round Questions with Solutions
- Cadence Interview Questions and Answers for India R&D Software Roles
- Capgemini Coding Round Questions with Solutions
- Capgemini Interview Questions for Freshers
- Cisco Coding Round Questions with Solutions in Python and Java
- Cisco Interview Questions and Answers: Networking and SDE Roles