Interview Questions

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 2018
Q:

What is the difference between Silverlight 1.0 and 2?

Answer

Silverlight 1 is purely AJAX and JavaScript based. All the code has to be written in JavaScript and XAML. 


 Silverlight 2 supports managed code. When the Silverlight 2 runtime is installed, it installs a limited version of the .NET runtime on the client machine

Report Error

View answer Workspace Report Error Discuss

0 2018
Q:

Which of the following best describes term life insurance? 

A) The insured pays a premium for a specified number of years. B) The insured is covered during his or her entire lifetime.
C) The insured pays the premium until his or her death. D) The insured can borrow or collect the cash value of the policy.
 
Answer & Explanation Answer: A) The insured pays a premium for a specified number of years.

Explanation:
Report Error

View Answer Report Error Discuss

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

0 2017
Q:

A tank-full petrol in Veeru’s Car last for 20 days. If he starts using 25% more every day, how many days will the tank-full petrol last?

A) 18 days B) 12 days
C) 14 days D) 16 days
 
Answer & Explanation Answer: D) 16 days

Explanation:

The analogy here is like this: Veeru has 20 lt of petrol and he uses 1 lt per each day and consumes it in 20 days. If he uses 1.25 lt every day, in how many days it will be consumed?
We considered 1.25 lt here because it’s 25% more than 1 lt.

The answer would be  20/1.25=16 days.

Report Error

View Answer Report Error Discuss

Filed Under: Team Work
Exam Prep: CAT , Bank Exams
Job Role: Bank PO , Bank Clerk

11 2017
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 2017
Q:

What is static initializer block? What is its use?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2017
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 2016
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 2015