Interview Questions

SQL JOIN allows access to records of other table based on the given conditions between two tables.

Ex: If we are provided with the department ID of each employee, then we can use the department ID of the employee table to merge with the department ID of the department table to access department names.

UNION operation allows addition of 2 similar data sets to create a resulting set that contains all the data from the source data sets.

Ex: If we are provided with 2 employee tables of the same structure, we can UNION them to create a singular result that will contain all employee from both the table.

An in-stream PROC is defined right in the jcl stream and doesn't reside in the proclib. This is an older technique associated with punched cards but it is still in use with setup and installation programs from vendors.

for the in-line perform instead of:

perform add-paragraph until switch = 'y'

you can code

perform until switch = 'y'

body of code

end-perform

body of code is the code from add-paragraph appearing in-line (ie right in the perform) instead of in a separate paragraph (out of line code)

A binary tree with n nodes has exactly n+1 null nodes

Always prioritize by what's most important to what is less important to us to reach our goals as soon as possible.

When you are applying for a job at a call center you should know that there will be moments when unsatisfied customers will get angry on you. The key here is to focus on what is the purpose of the call, maintain your calmness and be polite.

As an answer to this question, you can say that you would rate your level of patience and people friendliness above average. You can back it up with an example from your personal or professional life. 

* JSON full form is JavaScript Object Notation.
* JSON is a lightweight text-based open standard designed for human-readable data interchange.
* It is derived from the JavaScript programming language for representing simple data structures and associative arrays, called objects.
* And JSON is language-independent, with parsers available for virtually every programming language.
* Uses conventions that are familiar to programmers of the C-family of languages, including C, C++, C#, Java, JavaScript, Perl, Python,php
* The JSON format is often used for serializing and transmitting structured data over a network connection.
* When third party data interchane(REST Services) then JSON may used there LIKE SHOP.
* It is primarily used to transmit data between a server and web application, serving as an alternative to XML.

EX:

- High Priority and Low Severity:

Company logo is not properly displayed on their website.

- High Priority and High Severity:

Suppose you are doing online shopping and filled payment information, but after submitting the form, you get a message like "Order has been cancelled."

- Low Priority and High Severity:

If we have a typical scenario in which the application get crashed, but that scenario exists rarely.

- Low Priority and Low Severity:

There is a mistake like "You have registered success" instead of successfully, success is written.