Interview Questions

Demand is said to be inelastic, when the demand for the good doesn't change much or it is negotiable when the price of the good changed.

1. Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart. 

2. ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS. 

3. Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.

<?php
$tomorrow = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"));
echo ($tomorrow-$lastmonth)/86400;
?>

What are your strengths?

Purpose - The question is asked by the interviewer to understand your key selling point and get to know if it is relevant and helpful to handle the responsibilities that the person will handle if hired.

Note - All Most all Interviewers/Hiring people in management who assign tasks and responsibilities feel that a person is productive in work if his strength matches to the responsibilities of the role. So expect this question in most interviews. Also, be aware Strengths give clues on your interest.

Approach - Pick 2 or 3 strengths and give examples for each 1 to demonstrate how you used it in the previous job or in life. You can identify Some of your strengths from below list.
Continuous learning
Problem solving
Multi-tasking
Self learning
Flexible
Team Player
Hard working
Like Challenges
Quick Learner
Self Motivated
Communication, Oral and Written
Process Oriented
Analytical

Pre-work -Understand the job requirement in detail and get to know in advance what are the responsibilities the role you are applying and accordingly pick your strength that is relevant to the role. It would be advantageous to know the problems are issues the company is facing and what was the reason for the opening. You should be prepared for this question. It is one of the most commonly asked interview question.

E.g.: Communication and presentation - Communication and presentation is my strength.
In my previous job, I was given additional responsibilities to present and facilitate project status meetings with executive management and team building activities across departments.

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.

A database is used to store, modify, extract and to search for the data within it.

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.

A static initializer block is a block of code that declares with the static keyword. It normally contains the block of code that must execute at the time of class loading. The static initializer block will execute only once at the time of loading the class only.