Interview Questions

Data warehouse

- It is a decision support database system for the purpose of organizational needs. 

-It is non volatile, integrated and time variant collection of data

Operational Data Stage

- It is an integrated collection of information. 

-It can contain 90 days of information at maximum.

-ODS supports dynamic data.

Paycheck - this is the method by which the Employee is paid (A Bank Check/Cheque or Direct Deposit to Bank)

Payslip - Also called as Pay Stub is the paper which will typically detail the gross income and all taxes and any other deductions such as retirement plan contributions, insurances, garnishments, or charitable contributions taken out of the gross amount to arrive at the final net amount of the pay, also including the year to date totals in some circumstances.

SELECT "column_name"

FROM "table_name"

WHERE "column_name" IS NULL.

Server control events can be handled inside a server itself

It is a letter of credit or a contractual agreement between financial institute (Bank) and the party to which the letter is handed. The ILOC letter cannot be cancelled under any circumstance and, guarantees the payment to the party. It requires the bank to pay against the drafts meeting all the terms of ILOC. It is valid upto the stated period of time. For example, if a small business wanted to contract with an overseas supplier for a specified item they would come to an agreement on the terms of the sale like quality standards and pricing, and ask their respective banks to open a letter of credit for the transaction. The buyer’s bank would forward the letter of credit to the seller’s bank, where the payment terms would be finalized and the shipment would be made.

Both GET and POST are used to collect data from a form. However, when security is desired $_POST should be used. When the $_ POST variable is used, all variables used are NOT displayed in the URL. Also, they have no restrictions to the length of the variables. GET should be used when the interaction with the form is more like a question. For e.g. firing a query etc. POST should be used more often when the interaction is more like an order or the interaction changes the state of the resource.

POST example:

<form action="sample.php" method="post">

Name: <input type="text" name="name" />

Age: <input type="text" name="age" />

<input type="submit" />

</form>

On clicking submit the URL resembles to: https://www.mysamplesite.com/sample.php

The sample.php file can be used for catching the form data using $_POST 

Hello <?php echo $_POST["name"]; ?>.<br />

You are <?php echo $_POST["age"]; ?> years old!

GET EXAMPLE

<form action="sample.php" method="get">

Name: <input type="text" name="name" />

Age: <input type="text" name="age" />

<input type="submit" />

</form>

On clicking submit the URL resembles to : https://www.mysamplesite.com/sample.php?name=jim&age=37

The sample.php file can be used for catching the form data using $_GET 

Hello <?php echo $_GET["name"]; ?>.<br />

You are <?php echo $_GET["age"]; ?> years old!