Birlasoft Senior Consultant Interview Questions and Answers

Q1. Basic plsql questions
Add your answer
Q2. Basis oracle apps
Add your answer

Q1. Java related starting from basic to advanced
Add your answer

Q1. Questions from java basic to moderate and then advanced level java question
Add your answer

Q1. Some technical, then last project related then since situation and scenario based.
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

Technical Interview round that lasted for around 45 minutes. Intermediate level of PL/SQL questions were asked.

Q1. What is the difference between the cursors declared in procedures and those declared in package specifications?
Ans. 
Cursors declared in procedures are local to the procedure, while those declared in package specifications can be accessed by multiple procedures within the package.
• Cursors declared in procedures are only visible within that specific procedure.

• Cursors declared in package specifications can be shared and accessed by multiple procedures within the package.

• Package-level cursors can be useful for reusing the same query logi...read more
Answered by AI
Add your answer
Q2. What is a PL/SQL cursor?
Ans. 
A PL/SQL cursor is a pointer used to fetch and manipulate data in a database table.
• PL/SQL cursor is used to retrieve data row by row from a result set.

• It allows for processing individual rows returned by a query.

• Cursors are typically used in loops to iterate through query results.

• Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;
Answered by AI
Add your answer
Q3. What is a trigger in the context of a database management system?
Ans. 
A trigger in a database management system is a set of instructions that automatically execute in response to certain events on a table or view.
• Triggers are used to enforce business rules, perform data validation, and maintain data integrity.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating related tables when a r...read more
Answered by AI
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

Technical interview round that lasted for about 45 minutes. Questions were based on PL/SQL in Oracle and dbms related.

Q1. What is the difference between triggers and stored procedures in a Database Management System (DBMS)?
Ans. 
Triggers are automatically executed in response to certain events, while stored procedures are pre-written scripts that can be manually executed.
• Triggers are event-driven and automatically executed when a specified event occurs in the database.

• Stored procedures are pre-written scripts that can be manually executed by users or applications.

• Triggers can be used to enforce data integrity rules or audit changes in the data...read more
Answered by AI
Add your answer
Q2. What is the difference between ROWID and ROWNUM in SQL?
Ans. 
ROWID is a unique identifier for a row in a table, while ROWNUM is a pseudo-column that assigns a unique number to each row retrieved from a query.
• ROWID is a physical address of a row in a table, while ROWNUM is a virtual column generated by a query result set.

• ROWID remains constant for a row even if the row is updated, while ROWNUM changes based on the order of rows retrieved from a query.

• ROWID is unique within a tabl...read more
Answered by AI
Add your answer
Q3. Can you explain SQL join related queries?
Ans. 
SQL join queries are used to combine rows from two or more tables based on a related column between them.
• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

HR based round. The interviewer asked a few questions to know more about me. We also discussed the salary.