Interview Questions

Q:

Why we can't create an aggregate on an ODS Object?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

2 2045
Q:

What is Payroll Journal?

Answer

A payroll journal is like a payroll register. It has salary, bonuses, commission in other words earnings, any deductions such as 401k, fsa etc, state and income taxes etc.
It shows the gross salary less any deductions "Net pay" for the period.

Report Error

View answer Workspace Report Error Discuss

0 2045
Q:

What is DriverManager ?

Answer

DriverManager is a class in java.sql package. It is the basic service for managing a set of JDBC drivers.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2044
Q:

What are the benefits of Automated Testing?

Answer

The benefits of Automation Testing are below:


 


- Test engineer productivity.


- Coverage of regression testing.


- Reusability of test cases.


- Consistency in testing.


- Test interval reduction


- Reduced software maintenance cost


- Increased test effectiveness

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2041
Q:

The income and substitution effects account for

A) the upward sloping curve B) the downward sloping curve
C) Both A & B D) None of the above
 
Answer & Explanation Answer: B) the downward sloping curve

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 2040
Q:

What is a sub query? What are its various types?

Answer

- Sub Query also termed as Nested Query or Inner Query is used to get data from multiple tables.
- A sub query is added in the where clause of the main query.

There can be two types of subqueries:
a.) Correlated sub query :
- It can reference column in a table listed in the from list of the outer query but is not as independent as a query.
b.) Non-Correlated sub query :
- Results of this sub query are submitted to the main query or parent query.
- It is independent like a query

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2040
Q:

What is the CICS LOAD command ?

Answer

The LOAD command retrieves an object program from disk and loads it into main storage - it's primarily used for a constant table that will be available system-wide.


 

Report Error

View answer Workspace Report Error Discuss

0 2039
Q:

What is the SimpleTimeZone class?

Answer

SimpleTimeZone is a concrete subclass of TimeZone class. The TimeZone class represents a time zone, that is to be used with Gregorian calendar.


The SimpleTimeZone is created by using the base time zone offset from GMT time zone ID and rules, for starting and ending the time of daylight.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2038