Interview Questions

The primary keys of entity tables are the foreign keys of dimension tables.

The Primary keys of fact dimensional table are the foreign keys of fact tablels.

<?php
session_start();
// store session data
$_SESSION['views']=1;
unset($_SESSION['views']); // If you wish to delete some session data, you can use the unset()
session_destroy(); // You can also completely destroy the session by calling the session_destroy() function. session_destroy() will reset your session and you will lose all your stored session data.
?>

A journal is also called as a book of prime entry.Transactions occurred are first entered in this book to show which accounts should be debited and which should be credited.

on the basis of entries made in the journal, accounts are prepared, the book which contains the accounts is called a ledger. Transactions entered in the journal are classified according to their nature and posted in their respective accounts in ledger. it is also called as book of final entry.

A commercial bank is a type of bank that provides services such as accepting deposits, making business loans, and offering basic investment products.

Commercial bank can also refer to a bank or a division of a bank that mostly deals with deposits and loans from corporations or large businesses, as opposed to individual members of the public.

whenever user visits a page application Application_start event occurs

At the time of updating the data warehouse, a lookup table is used. When placed on the fact table or warehouse based upon the primary key of the target, the update is takes place only by allowing new records or updated records depending upon the condition of lookup.

The materialized views are aggregate tables. It contains summarized data. For example, to generate sales reports on weekly or monthly or yearly basis instead of daily basis of an application, the date values are aggregated into week values, week values are aggregated into month values and month values into year values. To perform this process aggregate function is used.

In most cases, the best answer to this question is answering yes. Working well under pressure is a good trait to have. However, I think if you answer that you work the same with pressure and without pressure, the interviewer will be more impressed. However, you will need to explain in words why this is better. Here are some of my answers.

1. "I work well under pressure because I use the pressure to help me work more efficiently."

2. "I enjoy working under pressure because I believe it helps me grow. In my previous experience, I always worked well during deadlines, and I always learned how to work more efficiently afterwards."

3. "I work well under pressure because I don't panic. I maintain self control and work as efficiently as possible. In all my experiences, I did well and I always enjoyed the experience."