SHI International Corp Interview Questions and Answers

Explanation of differences between PK & UK, Case & Decode, Procedure & Function, Cursor & Refcursor.

• PK (Primary Key) is a unique identifier for a record in a table, while UK (Unique Key) ensures uniqueness but allows null values.

• Case and Decode are conditional statements used to manipulate data based on certain conditions.

• Procedure and Function are both database objects used to perform a specific task, but Function ret...read more

Dual is a special one-row, one-column table in Oracle DB.

• Dual is used to perform calculations or execute functions without selecting from a table.

• It is often used to generate a sequence of numbers or to concatenate strings.

• For example, SELECT 1+1 FROM dual; will return 2.

• Dual is automatically created by Oracle and is always available in every Oracle database.

Collection in Oracle is a group of elements of the same data type. Types include VARRAY, Nested Table, and Associative Array.

• VARRAY is a fixed-size array that can hold a varying number of elements up to the specified limit.

• Nested Table is a dynamic array with no fixed size that can be stored in a database column.

• Associative Array is a collection of key-value pairs where the key is unique and used to access the correspo...read more

A DB block is a unit of data storage in Oracle Forms that contains multiple rows of data from a database table.

• DB blocks are used to improve performance by reducing the number of times a form needs to access the database.

• Each DB block contains a fixed number of rows, which can be configured in the form's block properties.

• When a form needs to display data from a table, it reads one or more DB blocks into memory.

• If a for...read more

Call_Form is a built-in Oracle Forms procedure used to call another form from the current form.

• Call_Form is used to open a new form while keeping the current form open.

• It can be used to pass parameters between forms.

• The called form can be modal or non-modal.

• The called form can be in the same application or a different one.

• Syntax: Call_Form('form_name', [mode], [hide], [no_replace], [query_only], [params])

Types of Trigger in Oracle forms and their sequence of firing.

• Types of triggers include Key Triggers, Mouse Triggers, and Timer Triggers.

• Key Triggers fire when a key is pressed or released.

• Mouse Triggers fire when the mouse is clicked or moved.

• Timer Triggers fire at a specified interval.

• The sequence of trigger firing is Pre-Form, Pre-Block, Pre-Record, Post-Record, Post-Block, and Post-Form.

Canvas, LOV, and List button are UI components used in Oracle Forms.

• Canvas is a visual container used to display data or graphics.

• LOV (List of Values) is a drop-down list used to select a value from a predefined list.

• List button is a button used to display a list of values in a pop-up window.

• These components are commonly used in Oracle Forms to create user-friendly interfaces.

A placeholder column is a column that is used to reserve space for a future column in an Oracle report.

• Placeholder columns are used to ensure that the layout of a report remains consistent even if data is missing.

• They are typically used when a report is designed to display a fixed number of columns, but the data source may not always contain data for all of those columns.

• Placeholder columns can be added to a report by ...read more

I am a software engineer with experience in developing and maintaining software applications.

• I have a Bachelor's degree in Computer Science.

• I have worked on various projects using different programming languages such as Java, C++, and Python.

• I am skilled in software development methodologies like Agile and have experience with version control systems like Git.

• I have strong problem-solving and analytical skills, which h...read more

SQL joins combine rows from two or more tables based on related columns, enabling complex queries and data retrieval.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.a_id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.a_id;

• RIGHT JOIN: Returns all records from t...read more

A cursor is a database object used to retrieve and manipulate data in a result set.

• A cursor allows sequential access to the rows in a result set.

• It can be used to fetch and update data in a controlled manner.

• Cursors are important for managing large result sets and performing complex data operations.

• They provide a way to navigate through query results and perform operations on individual rows.

• Examples of cursor types in...read more

Yes, I have experience working with Oracle Forms and Reports.

• I have worked on developing and maintaining Oracle Forms and Reports applications.

• I am familiar with the Oracle Forms and Reports development environment.

• I have experience in designing and implementing user interfaces using Oracle Forms.

• I have used Oracle Reports to generate various types of reports.

• I am proficient in writing PL/SQL code to interact with the ...read more

I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.

• 5 years of experience in software development

• Proficient in developing web applications

• Skilled in using various technologies

• Passionate about software engineering

My salary expectation is in line with industry standards and based on my experience and skills.

• Research industry standards for software engineer salaries in the specific location and company

• Consider my years of experience and relevant skills when determining salary expectation

• Be prepared to negotiate based on the job responsibilities and benefits package offered

Yes, I am willing to shift anywhere as per the requirement of the job.

• I am open to relocating for the right opportunity

• I understand that flexibility in location may be necessary for certain roles

• I am willing to adapt to new environments and challenges