Interview Questions

A collection just like an array is an ordered group of elements of the same type. Each elements position is determined by a unique subscript.

Index by tables:- They are similar to hash arrays that allows to search for subscript values using arbitrary numbers and strings.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL]

INDEX BY [BINARY_INTEGER | PLS_INTEGER | VARCHAR2(size_limit)];

INDEX BY key_type;

Example:

TYPE studenttyp IS TABLE OF emp%ROWTYPE

INDEX BY BINARY_INTEGER;

stud_tab studenttyp;

Nested tables:- they hold random number of elements and use sequential numbers as sub scripts.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL];

Example: TYPE employee_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);

Varrays: Holds a fixed number of elements which can be changed in run time. 

They can be declared as:

TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF element_type [NOT NULL];

Example: TYPE Calendar IS VARRAY(366) OF DATE;

Different types of risk exist in ivesting schemes depending on what you've invested in.

Savings accounts are generally regarded as the least risky investments as in this we just save our wealth for future expenses.

What are your strengths?

Purpose - The question is asked by the interviewer to understand your key selling point and get to know if it is relevant and helpful to handle the responsibilities that the person will handle if hired.

Note - All Most all Interviewers/Hiring people in management who assign tasks and responsibilities feel that a person is productive in work if his strength matches to the responsibilities of the role. So expect this question in most interviews. Also, be aware Strengths give clues on your interest.

Approach - Pick 2 or 3 strengths and give examples for each 1 to demonstrate how you used it in the previous job or in life. You can identify Some of your strengths from below list.
Continuous learning
Problem solving
Multi-tasking
Self learning
Flexible
Team Player
Hard working
Like Challenges
Quick Learner
Self Motivated
Communication, Oral and Written
Process Oriented
Analytical

Pre-work -Understand the job requirement in detail and get to know in advance what are the responsibilities the role you are applying and accordingly pick your strength that is relevant to the role. It would be advantageous to know the problems are issues the company is facing and what was the reason for the opening. You should be prepared for this question. It is one of the most commonly asked interview question.

E.g.: Communication and presentation - Communication and presentation is my strength.
In my previous job, I was given additional responsibilities to present and facilitate project status meetings with executive management and team building activities across departments.

-The shift() method is similar as the pop() method but the difference is that Shift method works at the beginning of the array. 

-The shift() method take the first element off of the given array and returns it. The array on which is called is then altered.

For example

var myarray = ["apple ", "banana ", "mango "]; 

console.log(myarray.shift());

console.log(myarray);

we get the following console output:

apple

["banana ", "mango "];

When we call shift() on an empty array, it will return an undefined value.

Following guidelines to be following while writing Cobol program:

- Use ? EVALUATE ? statement for constructing cases.

- Use scope terminators for nesting.

- Use in-line Perform statement for writing ?do? constructions.

- Use Test Before and Test After in the Perform statement while writing Do-While statements.

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

Wage Revisions as per wage policy every finanical year means April of the every year will revised.

At the same time Basic is revised as per appointment order like we are given probation period to every employee after completion of the employee probation than basic also revised and depends upon Organisation Structure also.