Interview Questions

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.

The interviewer is listening for an answer that indicates you've given this some thought and are not sending out resumes just because there is an opening. For example, "I've selected key companies whose mission statements are in line with my values, where I know I could be excited about what the company does, and this company is very high on my list of desirable choices."

Java applications can call code written in C, C++, or assembler. This is sometimes done for performance and sometimes to access the underlying host operating system or GUI API using the JNI.

The steps for doing that are:

First write the Java code and compile it

Then create a C header file

Create C stubs file

Write the C code

Create shared code library (or DLL)

Run application

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;

Separation of an employee exists when the service of an employee comes to an end because of one reason or other. "Separation of employment" refers broadly to the process of managing the termination of employment. It is a sensitive issue for any organization. 

Types of separation:

1) Volunntary:

a) Resignation
b) Job abandonment
c) Retirement

2) Involuntary:

a) Layoff
b) Dismissal
c) Plant closure
d) Death or Disability.

SQL is a structured query language while PL/SQL is an extension of SQL by introducing a procedural flow. PL/SQL has blocks of statements. PL/SQL works like other procedural languages and has concepts like control statements, sequential statements, exception handling etc.

PL/SQL is Procedural Language SQL that is an extension of SQL that results in a more structural language composed of blocks. It is mainly used in writing applications that needs to be structured and has error handling.

-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.