Technology 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)

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.

Friends can be either functions or other classes. The class grants friends unlimited access privileges.

* The declaration of the function should be preceded by the keyword 'friend'.
* The function definition will not use the keyword or the scope operator '::'.

Thus, a friend function is an ordinary function or a member of another class.

Timers allow you to execute code at a set time or repeatedly using an interval. This is accomplished with the setTimeout, setInterval, and clearInterval functions. The setTimeout(function, delay) function initiates a timer that calls a specific function after the delay; it returns an id value that can be used to access it later. The setInterval(function, delay) function is similar to the setTimeout function except that it executes repeatedly on the delay and only stops when cancelled. The clearInterval(id) function is used to stop a timer. Timers can be tricky to use since they operate within a single thread, thus events queue up waiting to execute.

C# is a type-safe, managed and object oriented language, which is compiled by .Net framework for generating intermediate language (IL).

Below are some of the features supported in C# -
* Constructors and Destructors
* Properties
* Passing Parameters
* Arrays
* Main
* XML Documentation and
* Indexers

Below are the advantages of C# -

* Easy to learn
* Object oriented
* Component oriented
* Part of .NET framework

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

We can send 1024 bytes utilizing GET() yet POST() can exchange extensive measure of information and POST is the protected strategy than GET technique .